• 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

Charts and Visualization

Multicolor data bar with REPT function
Charts and Visualization

Multi-color Data bar with REPT function

July 12, 2022July 12, 2022 PKComments Off on Multi-color Data bar with REPT function
Charts and Visualization Excel Tips and Tricks

Find Top Employee with FILTER and RANK Function

June 7, 2022July 5, 2022 PKComments Off on Find Top Employee with FILTER and RANK Function
Progress Circle charts in Excel 2010
Charts and Visualization

Process Circle Chart in Excel 2010

May 9, 2022 PK0
Dynamic Chart with Camera
Charts and Visualization

Dynamic Graph with Camera

May 3, 2022 PKComments Off on Dynamic Graph with Camera
Conditional formatting in Excel Chart
Charts and Visualization

Conditional formatting in Excel Chart

May 3, 2022 PKComments Off on Conditional formatting in Excel Chart
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
Beer Mug Chart
Charts and Visualization

Beer Mug Graph in excel

March 3, 2022 PKComments Off on Beer Mug Graph in excel
Double Doughnut Chart in Excel
Charts and Visualization

Double Doughnut Chart in Excel

February 28, 2022 PKComments Off on Double Doughnut Chart in Excel
Progress Bar Chart in Excel
Charts and Visualization

Progress Bar Chart in Excel

February 22, 2022 PKComments Off on Progress Bar Chart in Excel
Dynamic Circle Chart in Excel
Charts and Visualization

Dynamic Circle Chart in Excel

February 6, 2022February 6, 2022 PKComments Off on Dynamic Circle Chart in Excel

Posts navigation

1 2 … 13 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