Power Pivot

This category offers detailed tutorials on using Power Pivot to build powerful data models and perform complex data analysis tasks in Excel. From importing and organizing data to creating relationships between tables and writing advanced DAX, our tutorials cover a range of topics to help you work more efficiently with large datasets. Each tutorial comes with a free practice file for download and tutorial videos to help you understand the concepts better. Start exploring this category now and take your Excel skills to the next level. Impress your colleagues and boss with your proficiency in Power Pivot by exploring this category today.

Dashboard Power Pivot

KANBAN Board with Power Pivot and VBA for Project Management

May 2, 2023May 2, 2023 PKComments Off

In today's fast-paced business environment, effective project management is essential for achieving success. One tool that has gained significant popularity in recent years is the KANBAN board. In this comprehensive

Data Transformation to create Comma Separated List automatically

Excel Tips and Tricks Power Pivot

Automatically Creating Employee-wise Skill Set Lists

December 12, 2022March 8, 2023 PKComments Off

Data transformation is an important aspect of data analysis and is often used to manipulate data in a way that suits our needs. One such manipulation is creating comma-separated lists

Power Pivot

Profit Analysis Dashboard using What-if Parameter

April 27, 2022May 10, 2022 PKComments Off

In this article, we have created a Profit Analysis using What-if Parameter in Microsoft Power BI. You can use this trick in your Sales dashboard. [caption id="attachment_57629" align="alignnone" width="1920"]

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

Power Pivot Templates VBA

Price Fetching Tool from Amazon and Flipkart

December 21, 2020December 23, 2020 PKComments Off

In this article, we have created a price fetching tool from Amazon and Flipkart. You can input your search keyword and click on Search button. First it will open WWW.Amazon.in

Charts and Visualization Power Pivot Templates

Power Gantt Chart (Project Planner) for Project Management

October 11, 2020October 11, 2020 PKComments Off

In the article, we have created the Powerful Gantt Chart (Project Planner) for Project Management in Microsoft Excel with Power Pivot. You can use this template for your Project Management

Charts and Visualization Power Pivot

Smart Chart with Laptop Shape in Excel

May 3, 2020May 3, 2020 PKComments Off

In this article, we have created a beautiful and smart chart with Conditional formatting in Microsoft Excel. We have create a laptop shape also using Excel shapes. We have placed

Power Pivot VBA

Email Data Consolidation Tool in Excel

April 26, 2020February 27, 2023 PKComments Off

Now a days businesses rely more heavily on email communication. Managing data from multiple sources can become a real challenge. Fortunately, there is a solution: an email data consolidation tool

Dashboard Power Pivot

Fully Automated Excel dashboard with multiple source files

April 12, 2020April 12, 2020 PKComments Off

In this article, we have create a full automatic excel dashboard with multiple excel source files. Each source file can have multiple worksheets. For data consolidation we have used Power

Power Pivot VBA

User level security in Excel Workbook for different worksheets

April 5, 2020April 5, 2020 PKComments Off

In this article, we have created User level security in Excel workbook. If you have multiple worksheets in your excel file and you want to protect/hide the data according to