• Advanced Excel
    • Shortcut Keys
    • Useful Formulas
    • Basic Charts
    • Advanced Chart
    • Sort and Filter
    • Pivot Table
    • Data Validation
    • Conditional Formatting
    • Auto Fill and Flash Fill
    • Find and Replace
  • VBA Course
  • Products
    • Restaurant Management
    • PK’s Utility Tool V3.0
    • PK’s Utility Tool V2.0
    • PK’s Utility Tool V1.0
    • Task Management
    • AMS V1.0
    • AMS V2.0
    • Sale/Purchase Software
    • PK’s Function Kit
  • Blogs
    • Charts and Visualization
    • VBA
    • Excel Tips and Tricks
    • Templates
  • Excel Dashboard
    • Sales Dashboard
    • Process Dashboard
    • Performance Dashboard
    • Project Management
    • Outbound Dashboard
    • Incentive Dashboard
    • Zonal Dashboard in Excel
    • Quick Dashboard
  • Free Templates
  • Power BI
  • About Us
  • Contact Us

PK: An Excel Expert

Excel, VBA, and Power BI tutorials

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.

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 on Automatically Creating Employee-wise Skill Set Lists
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
Read More
Profit Analysis using What if Analysis
Power Pivot

Profit Analysis Dashboard using What-if Parameter

April 27, 2022May 10, 2022 PKComments Off on Profit Analysis Dashboard using What-if Parameter
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"]
Read More
Comparative Analysis Dashboard in Excel
Dashboard Power Pivot

Comparative Analysis Dashboard in Excel

June 20, 2021June 20, 2021 PKComments Off on Comparative Analysis Dashboard in Excel
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
Read More
Web Automation
Power Pivot Templates VBA

Price Fetching Tool from Amazon and Flipkart

December 21, 2020December 23, 2020 PKComments Off on Price Fetching Tool from Amazon and Flipkart
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
Read More
Power Gantt Chart
Charts and Visualization Power Pivot Templates

Power Gantt Chart (Project Planner) for Project Management

October 11, 2020October 11, 2020 PKComments Off on Power Gantt Chart (Project Planner) for Project Management
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
Read More
Smart Chart with Condition Formatting
Charts and Visualization Power Pivot

Smart Chart with Laptop Shape in Excel

May 3, 2020May 3, 2020 PKComments Off on Smart Chart with Laptop Shape in Excel
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
Read More
Email Data Consolidation Tool
Power Pivot VBA

Email Data Consolidation Tool in Excel

April 26, 2020February 27, 2023 PKComments Off on Email Data Consolidation Tool in Excel
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
Read More
Excel Dashboard With Multiple Source Files
Dashboard Power Pivot

Fully Automated Excel dashboard with multiple source files

April 12, 2020April 12, 2020 PKComments Off on Fully Automated Excel dashboard with multiple source files
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
Read More
User Level Security
Power Pivot VBA

User level security in Excel Workbook for different worksheets

April 5, 2020April 5, 2020 PKComments Off on User level security in Excel Workbook for different worksheets
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
Read More
KPI in Power Pivot
Power Pivot

KPI in Power Pivot for dashboard and report

January 15, 2020January 15, 2020 PKComments Off on KPI in Power Pivot for dashboard and report
Key performance indicators (KPIs) are visual measures of performance. Based on a specific calculated field, a KPI is designed to help users quickly evaluate the current value and status of
Read More

Posts navigation

1 2 Next
  • Advanced Excel
    • Shortcut Keys
    • Useful Formulas
    • Basic Charts
    • Advanced Chart
    • Sort and Filter
    • Pivot Table
    • Data Validation
    • Conditional Formatting
    • Auto Fill and Flash Fill
    • Find and Replace
  • VBA Course
  • Products
    • Restaurant Management
    • PK’s Utility Tool V3.0
    • PK’s Utility Tool V2.0
    • PK’s Utility Tool V1.0
    • Task Management
    • AMS V1.0
    • AMS V2.0
    • Sale/Purchase Software
    • PK’s Function Kit
  • Blogs
    • Charts and Visualization
    • VBA
    • Excel Tips and Tricks
    • Templates
  • Excel Dashboard
    • Sales Dashboard
    • Process Dashboard
    • Performance Dashboard
    • Project Management
    • Outbound Dashboard
    • Incentive Dashboard
    • Zonal Dashboard in Excel
    • Quick Dashboard
  • Free Templates
  • Power BI
  • About Us
  • Contact Us
Copyright © 2023 PK-AnExcelExpert.com - Privacy Policy