• 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: Power Pivot

Data Transformation to create Comma Separated List automatically
Excel Tips and Tricks Power Pivot

Data Transformation to create Comma Separated List automatically

December 12, 2022December 12, 2022 PKComments Off on Data Transformation to create Comma Separated List automatically
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
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
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
SUMX Function
Power Pivot

SUMX Function in Power Pivot

January 13, 2020January 13, 2020 PKComments Off on SUMX Function in Power Pivot
Power Pivot

Calculated Column in Power Pivot (LOOKUPVALUE Vs RELATED)

January 9, 2020January 9, 2020 PKComments Off on Calculated Column in Power Pivot (LOOKUPVALUE Vs RELATED)
Drill Down in Pivot Chart
Charts and Visualization Power Pivot

Drill Down/Drill Up Feature in Pivot Chart

January 6, 2020January 6, 2020 PKComments Off on Drill Down/Drill Up Feature in Pivot Chart
Relationship in Power Pivot
Power Pivot

Create Relationship in Power Pivot

January 3, 2020January 3, 2020 PKComments Off on Create Relationship in Power Pivot

Top Categories

  • Charts and Visualization (126)
  • Dashboard (8)
  • Excel Tips and Tricks (52)
  • 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

  • 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
  • Fill Series in Excel
Copyright © 2018 PK-AnExcelExpert.com - Privacy Policy