• 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: data analysis

Quick Dynamic Sales by Employees chart with Slicers
Charts and Visualization

Quick Dynamic Sales by Employees chart with Slicer in Excel

March 16, 2023March 16, 2023 PKComments Off on Quick Dynamic Sales by Employees chart with Slicer in Excel
Excel is a powerful tool which can be used for a wide range of business applications, for analyzing data, creating charts and graphs etc. One useful feature in Excel is
Read More
Simple Dashboard in Excel
Dashboard

One Pager KPI dashboard in Excel

February 15, 2023February 17, 2023 PKComments Off on One Pager KPI dashboard in Excel
Excel is a widely used tool for businesses and individuals for data analysis, tracking, and visualization. Excel Dashboard is an effective way to present complex data in a simplified manner,
Read More
4 Tips of Text to Column
Excel Tips and Tricks

4 Ultimate Tips for Data Separation and Conversion using Text to column

February 9, 2023February 9, 2023 PKComments Off on 4 Ultimate Tips for Data Separation and Conversion using Text to column
Excel is a veritable powerhouse when it comes to managing and analyzing data. Regardless of whether you are dealing with massive datasets or tiny lists, Excel offers an array of
Read More
Awesome formula tricks in Excel
Excel Tips and Tricks

Five awesome formulas in Excel

January 9, 2023February 27, 2023 PKComments Off on Five awesome formulas in Excel
The Excel formulas are absolute lifesavers when it comes to dealing with data in spreadsheets. They're like the Swiss Army knives of Excel, allowing you to calculate, manipulate, and automate
Read More
3D Gauge Chart
Charts and Visualization

3D Gauge Chart in Excel

March 30, 2020February 25, 2023 PKComments Off on 3D Gauge Chart in Excel
In this article, we have created beautiful 3D Gauge Chart. We have used Excel shapes and Pie Chart to create this beautiful visualization. You can use this chart in your
Read More
Dynamic Chart with Form Controls
Charts and Visualization

Fully dynamic chart in Excel with Scroll bar and Spin button

March 19, 2020February 5, 2023 PKComments Off on Fully dynamic chart in Excel with Scroll bar and Spin button
Are you ready to unleash the full potential of Excel's data analysis and visualization capabilities? Hold on tight, because we're diving into the mysterious realm of creating a fully dynamic
Read More
Dynamic Chart with Slicer
Charts and Visualization

Dynamic Chart with Slicer for Employees Count by Age group

July 17, 2019February 7, 2023 PKComments Off on Dynamic Chart with Slicer for Employees Count by Age group
Data analysis is an essential aspect of any business. It helps to make informed decisions based on evidence and trends. One of the ways to present data is through charts,
Read More
  • 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
Copyright © 2023 PK-AnExcelExpert.com - Privacy Policy