Blogs Archives - Page 249 of 258 - PK: An Excel Expert

Highlight Unmatched Cells using Conditional Formatting in Excel

April 22, 2019September 23, 2024 PKComments Off

In this article you will learn how to Highlight Unmatched Cells Cells values from another range using Conditional formatting. For Example, we have Sales and Product Master worksheets. In the

Excel Tips and Tricks

Highlight the Consecutive Duplicates in Excel

April 22, 2019September 20, 2024 PKComments Off

In this article you will learn how to highlight the Consecutive Duplicates in Excel using Conditional Formatting. You will also learn how to highlight consecutive weekly off in an Attendance

VBA

UDF for Evaluate a Formula in Excel

April 18, 2019September 21, 2024 PKComments Off

In this article you will learn how to create a User Defined Function to evaluate a formula in Excel. You will also learn how to get text of formula using

VBA

VBA: Quickly merge cells with same value in Excel

April 16, 2019February 25, 2025 PKComments Off

In this article you will learn how to quickly merge same cells in Excel using VBA. Using this VBA code, you can merge multiple columns data together. This trick can

Charts and Visualization

3D Disk Pie Chart in Excel

April 11, 2019September 20, 2024 PKComments Off

In today's world, data visualization has become an essential part of business presentations and reporting. It helps to communicate complex information in a simple and visually appealing way. One of

VBA

Data Consolidation: Allow User to select files on Runtime

April 8, 2019March 11, 2025 PKComments Off

In this article, we will explain to you the Data Consolidation from multiple Excel files using Application.GetOpenFileName in VBA. You can easily allow the user to select multiple excel files

Charts and Visualization

Info-graphics: Stunning Thermometer Chart in Excel

April 3, 2019March 5, 2025 PKComments Off

I am back with one more innovative chart which is a Stunning Thermometer Chart. This chart can be used for display KPI metrics. You can display your data by category

Charts and Visualization

Small Charts for Weekly Performance

March 31, 2019March 5, 2025 PKComments Off

While creating a dashboard, many times it happens when you don’t have sufficient space to place your multiple charts. However, there is a solution that is small charts. By using

Charts and Visualization

Beautiful and Stylish Circle Chart in Excel

March 28, 2019March 4, 2025 PKComments Off

In today's data-driven world, visualization of data is an essential aspect of decision-making. Excel is a powerful tool which can help you to create beautiful and effective visualizations for your

Charts and Visualization

Employee Rating Table in Excel

March 25, 2019March 10, 2025 PKComments Off

An Employee Rating Table in Excel can be a powerful template to visualize and track employee performance across various parameters. So, instead of displaying simple numerical ratings, you can use