• Advanced Excel
    • Shortcut Keys
    • Useful Formulas
    • Basic Charts
    • Advanced Chart
    • Sort and Filter
    • Pivot Table
    • Data Validation
    • Conditional Formatting
    • Auto Fill and Flash Fill
  • VBA Course
  • Products
    • 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
    • PM Dashboard
    • Outbound Dashboard
    • Incentive Dashboard
    • Zonal Dashboard in Excel
    • Quick Dashboard
  • Power BI
  • About Us
  • Contact Us

PK: An Excel Expert

Online Excel Tutorials

Blogs

Circular Bullet Chart in Excel
Charts and Visualization

Vertical and Circular Bullet Chart in Excel

January 24, 2021January 24, 2021 PKComments Off on Vertical and Circular Bullet Chart in Excel
10 Pro Tips for Excel Charts
Charts and Visualization

10 Pro Tips for Excel Charts

January 10, 2021January 10, 2021 PKComments Off on 10 Pro Tips for Excel Charts
Hourly Project Planner
Charts and Visualization Dashboard

Dynamic Hourly Project Planner (Gantt Chart)

December 27, 2020December 27, 2020 PKComments Off on Dynamic Hourly Project Planner (Gantt Chart)
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
Ideas in Excel
Excel Tips and Tricks

Ideas in Excel

November 22, 2020November 22, 2020 PKComments Off on Ideas in Excel
DSR
Power BI

Daily Sales Report – Data Extraction from multiple PDF files

November 15, 2020November 15, 2020 PKComments Off on Daily Sales Report – Data Extraction from multiple PDF files
Auto Email using Schedule
VBA

Hourly Auto Email with Scheduler

November 1, 2020November 15, 2020 PKComments Off on Hourly Auto Email with Scheduler
Row Level Security in Power BI
Power BI

Static and Dynamic Row Level Security in Power BI

October 25, 2020October 25, 2020 PKComments Off on Static and Dynamic Row Level Security in Power BI
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
10 Super Tips in Excel
Excel Tips and Tricks

10 Super Tips in Microsoft Excel

October 4, 2020October 4, 2020 PKComments Off on 10 Super Tips in Microsoft Excel

Posts navigation

1 2 … 22 Next

Top Categories

  • Charts and Visualization (101)
  • Dashboard (5)
  • Excel Tips and Tricks (33)
  • Power BI (12)
  • Power Pivot (11)
  • Power Point Visualization (4)
  • Predictive Analytics (3)
  • Templates (29)
  • VBA (61)

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

  • Vertical and Circular Bullet Chart in Excel
  • Inventory Management Template for Store
  • 10 Pro Tips for Excel Charts
  • Dynamic Hourly Project Planner (Gantt Chart)
  • Price Fetching Tool from Amazon and Flipkart
  • Automated Attendance Sheet in Excel
  • Ideas in Excel
  • Daily Sales Report – Data Extraction from multiple PDF files
  • Hourly Auto Email with Scheduler
  • Static and Dynamic Row Level Security in Power BI
Copyright © 2018 PK-AnExcelExpert.com - Privacy Policy