Blogs Archives - Page 263 of 267 - PK: An Excel Expert

Highlight Top and Bottom Performer using conditional formatting

October 19, 2018September 11, 2024 PK0

In this article you will learn how to use Conditional Formatting to Highlight Top and Bottom performer on the base of performance score. Top performer has been highlighted in green

Charts and Visualization

3D KPI Indicator in Excel

September 30, 2018March 8, 2025 PK0

Several times we have to show the some indicator of our KPI metrics to indicate that particular metrics is in Red, Yellow or Green. 3D KPI Indicator in Excel Here

Charts and Visualization

Filling Stacked Column Chart in Excel

September 23, 2018March 11, 2025 PK0

Today I have come with a beautiful Filling Stacked Column Chart. In this chart I have showcased day wise Sales Conversion. There are 5 circles for 100% each for 20%.

Charts and Visualization

Dynamic Project Planner (Gantt Chart) in Excel

September 16, 2018February 18, 2025 PK0

Here we have created a beautiful and dynamic Project Planer (Gantt chart) in Excel. We have given a drop-down to change the weekly and daily view. There are 3 type

VBA

VBA: Filter Data with Multiple Values

September 14, 2018September 11, 2024 PK0

In this article you will learn how we can use an excel range as a filter criteria and paste the filtered data on another worksheet VBA: Filter Data . For

VBA

User Defined Function for Sub-strings count from Excel Cell

September 10, 2018September 10, 2024 PK0

We often need the count of sub-strings from out text available in Excel. For example we have comma separated ticket number in a cell and we have to count how

Excel Tips and Tricks

Lock Excel Cell after Updating

September 8, 2018September 10, 2024 PK0

One of our client asked us to create a template wherein data can entered only once. As soon as data is entered in the cell, it should be locked for

Excel Tips and Tricks

Excel Template with Protection and Validation

August 26, 2018September 9, 2024 PK0

We often required an Excel Template to send some persons or teams so that they can enter the data in the template and can sent it to us and then

Charts and Visualization

Info-graphics with Column chart (Part-2)

August 15, 2018March 9, 2025 PK0

In this article you will learn how we can use info-graphics in the column chart for KPI metrics. We have created 4 different charts for Service Level. These charts can

Charts and Visualization

Info-graphics with Column chart (Part-1)

August 12, 2018March 9, 2025 PK0

Using the info-graphics in the charts is very nice idea. It will increase the visual appeal and audience attention of your report or dashboard. We have created 4 different charts