• Excel and VBA
    • VBA Course
    • 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
  • DownloadsPopular
    • Excel VBA Tools
    • Dashboard
      • Excel Dashboard
      • KPI Dashboard
      • Power BI Dashboard
    • Charts
      • Progress Charts
      • Info-graphics
      • Animated Charts
      • Comparisons
      • Gantt Charts
      • Heatmaps
      • Speedometers
      • Timelines
    • Inventory Management
    • HR and Payrolls
    • VBA Automation
    • Utilities and Converters
    • Checklist
    • Calendars
    • Data Analysis
    • Excel Templates
    • Financial Tools
    • Project Management
    • Sales and Marketing
    • Productivity
  • Excel Dashboard
  • Templates
  • Tutorials
    • Charts and Visualization
    • VBA
    • Excel Tips and Tricks
  • Power BI
  • Template StoreNew
  • CoursesNew
  • About Us
  • Contact Us

PK: An Excel Expert

Transforming Data into Decisions

Blogs

Sort by Cell color
Excel Tips and Tricks

Quick Re-Arrange Columns Sequence Using Data Sorting

July 24, 2019September 30, 2024 PKComments Off on Quick Re-Arrange Columns Sequence Using Data Sorting
In this article, you will learn how to sort the data by columns. If you have multiple columns in your excel sheet and you want to arrange the order of
Read More
Dynamic Chart with Option buttons
Charts and Visualization

Dynamic Chart with Option Button for Employees Count by Age group

July 22, 2019September 28, 2024 PKComments Off on Dynamic Chart with Option Button for Employees Count by Age group
In our last article, we created a Dynamic Chart with Slicer for Employees Count by Age group. Now in this article, we have created same chart with Form Control Option
Read More
Dynamic Chart with Slicer
Charts and Visualization

Dynamic Chart with Slicer for Employees Count by Age group

July 17, 2019March 3, 2025 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
Dynamic Number Format
Excel Tips and Tricks

Dynamic Number Format for Millions and Thousands

July 15, 2019September 29, 2024 PKComments Off on Dynamic Number Format for Millions and Thousands
Many times, when we create a chart and our numbers are quite big then our data labels on the chart are not proper readable. In that case we can change
Read More
Name Manager
VBA

Create Multiple Names using VBA in Excel

July 12, 2019September 28, 2024 PKComments Off on Create Multiple Names using VBA in Excel
Our daily Excel activities can be automated using VBA. Here we have created an example of Create Multiple Names using the Name range in Excel using VBA. Lets’ say we
Read More
Multiple KPI Visualization
Charts and Visualization

Multiple KPIs Visualization in Excel

July 10, 2019March 10, 2025 PKComments Off on Multiple KPIs Visualization in Excel
We have created an attractive visualization to display multiple KPI performance in Excel. We have used Excel auto shapes to create this visualization. RAG (Red, Amber, and Green) color changes
Read More
Birthday Count
Excel Tips and Tricks

Highlight and get birthdays count from Date of Birth

July 8, 2019September 28, 2024 PKComments Off on Highlight and get birthdays count from Date of Birth
In this article, you will learn how to get count of persons from a Date of Birth data whose birthdays are in the specific month. You will also learn how
Read More
Horizontal Timeline Chart
Charts and Visualization

Horizontal Timeline Chart using Scatter chart in Excel

July 5, 2019March 3, 2025 PKComments Off on Horizontal Timeline Chart using Scatter chart in Excel
Project management is a complex task that involves multiple aspects, including planning, execution, control, and closure. Among the crucial elements of successful project management is the use of timeline charts,
Read More
Vertical Timeline Chart
Charts and Visualization

Vertical Timeline Chart using Scatter chart in Excel

July 3, 2019March 4, 2025 PKComments Off on Vertical Timeline Chart using Scatter chart in Excel
A timeline chart is an effective way to visualize the different Milestones of a Project. Here we have created a Vertical Timeline Chart using Scatter Chart in Excel. This is
Read More
Waffle Chart
Charts and Visualization

Waffle Charts in Excel Without Macro

July 1, 2019March 4, 2025 PKComments Off on Waffle Charts in Excel Without Macro
The Waffle Chart is an attractive 10x10 grid in which each cell represents one percentage point. You can use this chart to display your KPI metrics like Service Level %,
Read More

Posts pagination

Previous 1 … 224 225 226 … 237 Next
  • Excel and VBA
    • VBA Course
    • 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
  • DownloadsPopular
    • Excel VBA Tools
    • Dashboard
      • Excel Dashboard
      • KPI Dashboard
      • Power BI Dashboard
    • Charts
      • Progress Charts
      • Info-graphics
      • Animated Charts
      • Comparisons
      • Gantt Charts
      • Heatmaps
      • Speedometers
      • Timelines
    • Inventory Management
    • HR and Payrolls
    • VBA Automation
    • Utilities and Converters
    • Checklist
    • Calendars
    • Data Analysis
    • Excel Templates
    • Financial Tools
    • Project Management
    • Sales and Marketing
    • Productivity
  • Excel Dashboard
  • Templates
  • Tutorials
    • Charts and Visualization
    • VBA
    • Excel Tips and Tricks
  • Power BI
  • Template StoreNew
  • CoursesNew
  • About Us
  • Contact Us
Copyright © 2023 PK-AnExcelExpert.com - Privacy Policy
This website uses cookies to improve your user experience, analyze site traffic and serve targeted ads in accordance with our Privacy Policy ACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT