Pivot Table Archives

Templates

Dynamic Attendance Sheet Using Power Pivot

February 20, 2023February 20, 2023 PKComments Off

Introduction In today's digital age, managing attendance in schools, colleges, or offices is a time-consuming task. This dynamic attendance sheet can help streamline this process by providing real-time attendance data

Charts and Visualization Excel Tips and Tricks

Quick Analysis Tool in Microsoft Excel

October 2, 2022October 2, 2022 PKComments Off

Quick Analysis Tool is used to apply the quick conditional formatting, Quick Charts, add Totals, Quick Pivot Tables and to add quick Sparklines in selected data. After selecting the

Charts and Visualization

Sales Analysis Heat Map by Time and Day

March 27, 2022March 27, 2022 PKComments Off

In this article, we have created a dynamic Sales Analysis Heat Map by Time and Day. Using this analysis, you will get to know your most busy time in a

Charts and Visualization Excel Tips and Tricks

Conditional Formatting in a Pivot Table with Example

December 6, 2021December 6, 2021 PKComments Off

Conditional formatting is a very useful feature in Microsoft Excel. If you are working on an Excel Report or Excel Dashboard then often require conditional formatting to highlight the values

Dashboard Power Pivot

Comparative Analysis Dashboard in Excel

June 20, 2021June 20, 2021 PKComments Off

This is the Excel version of the Comparative Analysis Dashboard. We have used Power Pivot to create this dashboard. We have used Current Year Sales Vs Previous Year Same Period

Charts and Visualization

3 Useful Tips for the Pivot Chart

May 16, 2021May 16, 2021 PKComments Off

In this article, you will learn 3 useful tips for Pivot Chart. Using these tips you can create an interactive Excel Dashboard. Learn and download interactive Excel Dashboard free of

Excel Tips and Tricks

10 Super useful Productivity Tips in Excel

March 7, 2021March 7, 2021 PKComments Off

In this article, you will learn 10 useful Productivity Tips in Excel. Using these tips, you can improve you Excel Productivity and your Analytical Power also. Below is the

Charts and Visualization

Dynamic Pivot Table with Multiple Tables using Power Query

January 31, 2021January 31, 2021 PKComments Off

In this article, we have created a dynamic Pivot Table report from multiple tables. We have taken 4 different yearly Sales Table as given in below image- Multiple Sales Table [caption

Power BI VBA

Custom Toggle Button in Excel and Power BI

August 9, 2020August 9, 2020 PKComments Off

In this article, we have created a custom toggle button in Microsoft Excel and Microsoft Power BI to toggle the Chart and Table on click of this toggle button. This

Excel Tips and Tricks

Pivot Table Super Tips in Excel

February 16, 2020February 16, 2020 PKComments Off

In this article, we have used two excel super tips for pivot table. You can use this tips in your excel report wherein you use pivot table. Below are the