• 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 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

Tag: Pivot Table

Quick Analysis Tool
Charts and Visualization Excel Tips and Tricks

Quick Analysis Tool in Microsoft Excel

October 2, 2022October 2, 2022 PKComments Off on Quick Analysis Tool in Microsoft Excel
Sales Analysis Heat Map
Charts and Visualization

Sales Analysis Heat Map by Time and Day

March 27, 2022March 27, 2022 PKComments Off on Sales Analysis Heat Map by Time and Day
Final Report
Charts and Visualization Excel Tips and Tricks

Conditional Formatting in a Pivot Table with Example

December 6, 2021December 6, 2021 PKComments Off on Conditional Formatting in a Pivot Table with Example
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
Pivot Chart Tips
Charts and Visualization

3 Useful Tips for the Pivot Chart

May 16, 2021May 16, 2021 PKComments Off on 3 Useful Tips for the Pivot Chart
10 Productivity Tips in Excel
Excel Tips and Tricks

10 Super useful Productivity Tips in Excel

March 7, 2021March 7, 2021 PKComments Off on 10 Super useful Productivity Tips in Excel
Dynamic Pivot Table with Multiple Tables
Charts and Visualization

Dynamic Pivot Table with Multiple Tables using Power Query

January 31, 2021January 31, 2021 PKComments Off on Dynamic Pivot Table with Multiple Tables using Power Query
Table view in Excel
Power BI VBA

Custom Toggle Button in Excel and Power BI

August 9, 2020August 9, 2020 PKComments Off on Custom Toggle Button in Excel and Power BI
Pivot Table Super Tips
Excel Tips and Tricks

Pivot Table Super Tips in Excel

February 16, 2020February 16, 2020 PKComments Off on Pivot Table Super Tips in Excel
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

Posts navigation

1 2 Next

Top Categories

  • Charts and Visualization (126)
  • Dashboard (8)
  • Excel Tips and Tricks (53)
  • Power BI (19)
  • Power Pivot (14)
  • Power Point Visualization (5)
  • Predictive Analytics (3)
  • Templates (49)
  • VBA (75)

Read More about..

  • Advanced Excel
  • VBA Course
  • Dashboard
  • Chart and Visualization
  • VBA Tips
  • Excel Tips and Trics
  • Our Excel Products
  • About US
  • Contact Us

 

Subscribe to our Newsletter



Download Free Dashboards

  • Project Management Dashboard
  • Zonal Dashboard
  • Sales Dashboard
  • Outbound Dashboard
  • A Quick Dashboard
  • C-SAT Dashboard
  • Performance Dashboard
  • Process Dashboard
  • Incentive Dashboard

Recent Posts

  • How Chat GPT can help to write Complex Excel Function, VBA code and DAX for Power BI
  • Power BI dashboard with 3D Glass Chart
  • Use of Symbols and Emojis in Excel Drop-down List and Excel Charts
  • Five awesome formulas in Excel
  • Quick 3D Container chart in Excel
  • TEXTSPLIT function with three use cases in Excel
  • LAMBDA Function in Excel with Example
  • Data Transformation to create Comma Separated List automatically
  • Inventory Management Template for Multiple Locations
  • Paste Special in Microsoft Excel
Copyright © 2018 PK-AnExcelExpert.com - Privacy Policy