• 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

Power Pivot

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
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
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
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
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
Email Data Consolidation Tool
Power Pivot VBA

Email Data Consolidation Tool in Excel

April 26, 2020April 26, 2020 PKComments Off on Email Data Consolidation Tool in Excel
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
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
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

Posts navigation

1 2 Next

Top Categories

  • Charts and Visualization (121)
  • Dashboard (8)
  • Excel Tips and Tricks (41)
  • Power BI (17)
  • Power Pivot (13)
  • Power Point Visualization (4)
  • Predictive Analytics (3)
  • Templates (46)
  • VBA (73)

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

  • Quick Productive Tips in Microsoft Excel
  • Automatic Data Transfer Excel to PowerPoint
  • Multi-color Data bar with REPT function
  • Invoice Management System V1.0
  • Find Top Employee with FILTER and RANK Function
  • Automated Multiple Emails with Multiple Attachments and “From” option
  • Sparklines in Power BI
  • COUNTIF by cells background color in Excel
  • Process Circle Chart in Excel 2010
  • Break-Even Analysis Template in Excel
Copyright © 2018 PK-AnExcelExpert.com - Privacy Policy