• 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

Blogs

Dynamic Step Chart
Charts and Visualization

Dynamic Step Chart in Excel

June 2, 2018June 2, 2018 PK0
Stunning-Battery-Chart
Charts and Visualization

Stunning Battery Chart

May 27, 2018 PK0
Searchable Dropdown
Excel Tips and Tricks

Searchable Drop down list for Multiple Cells

May 26, 2018May 26, 2018 PK0
Text-Join-UDF
VBA

Text Join Formula for all Excel Versions

May 23, 2018May 23, 2018 PK0
RAG Conditional formatting in Progress Circle Chart
Charts and Visualization

RAG Conditional Formatting in Progress Circle Chart

May 20, 2018May 20, 2018 PK0
Gantt Chart in Excel
Charts and Visualization

Quick Gantt Chart

May 19, 2018 PK0
Frequency Analysis Chart
Charts and Visualization

Frequency Analysis Chart in Excel

May 17, 2018May 17, 2018 PK0
VBA

VLOOKUP by cell background color

May 13, 2018May 13, 2018 PK0
Yesterday Vs Today Sales Chart
Charts and Visualization

Yesterday Vs Today Sales Chart

May 12, 2018May 12, 2018 PK0
3D Doughnut Chart
Charts and Visualization

3D Doughnut Chart for KPI Metrics

May 6, 2018May 6, 2018 PK0

Posts navigation

Previous 1 … 27 28 29 Next

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