• 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 V3.0
    • PK’s Utility Tool V2.0
    • PK’s Utility Tool V1.0
    • Task Management
    • AMS – Lite
    • 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

Transforming Data into Decisions

Blogs

Web browser in User form
VBA

VBA: Web browser in the User Form

November 18, 2018February 27, 2021 PK0
In this article you will learn how to use a web browser in the user form. You can search anything or open a website using the text box. [caption id="attachment_7077"
Read More
Fill Blanks
Excel Tips and Tricks

Excel Tip : Fill the blanks cells in your data

November 14, 2018November 14, 2018 PK0
Many times we have zig-zag data which has to be formatted in proper manner to create some report or dashboard. In this article you will learn how we can fill
Read More
Dependent Drop-Down in VBA User Form
VBA

VBA: Multilevel dependent drop-down in User Form

November 11, 2018November 11, 2018 PK0
While creating the data entry form in VBA, we need to put several validations. One of them is dependent drop-down. In this article you will learn how to create multilevel
Read More
Slide Meter Chart (Ver-3)
Charts and Visualization

Slide Meter Chart (Version-3)

November 8, 2018November 8, 2018 PK0
This is the version-3 of Slide Meter Chart. In the Slide Meter Chart (Version-1), we displayed the KPI metric performance with solid bar. In the Slide Meter Chart (Version-2), we
Read More
Slide Meter Chart (Ver-2)
Charts and Visualization

Slide Meter Chart (Version-2)

November 7, 2018November 7, 2018 PK0
This is the version-2 of Slide Meter Chart. In the Slide Meter Chart (Version-1), we displayed the KPI metric performance with solid bar but in this version-2, we have displayed
Read More
Slide Meter Chart
Charts and Visualization

Slide Meter Chart – Version 1

November 4, 2018November 4, 2018 PK0
Slide Meter Chart is very useful and eye catching chart to show the KPI metrics performance. This chart has been designed with the help of Column Chart, Line Chart and
Read More
Conditional Formatting in Line Chart
Charts and Visualization

Conditional Formatting in a Line Chart

November 3, 2018November 3, 2018 PK0
Using Conditional Formatting in a Line chart is very nice idea. This chart is very useful to show the trends of the data. Here we have showcased the month on
Read More
Highlight the data point
Charts and Visualization

Highlight the Specific data point in a Line Chart Dynamically

October 30, 2018 PK0
In this chart we have highlight the Minimum, Maximum and Selected data points in a beautiful line chart. This chart can be used in Business Dashboard or Presentation. Below is
Read More
Animated Hour Glass Chart
Charts and Visualization

Info-graphics: Animated Hour Glass Chart in Excel

October 28, 2018February 27, 2021 PK0
Animated Hour Glass Chart has been designed to display the KPI metrics like – Service Level, Quality Score, and Productivity etc. Whenever the value of metric will be changes it
Read More
Innovative Chart
Charts and Visualization

An Innovative chart for team level performance

October 27, 2018February 7, 2023 PK0
This innovative and eye-catching chart, we have created using Line with Marker chart. In this chart we have displayed seven teams and their performance. Below is the team wise Performance
Read More

Posts navigation

Previous 1 … 26 27 28 … 32 Next
  • 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 V3.0
    • PK’s Utility Tool V2.0
    • PK’s Utility Tool V1.0
    • Task Management
    • AMS – Lite
    • 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
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