Slicer Archives - PK: An Excel Expert

Circular Economy Startups Dashboard in Power BI

March 31, 2026March 31, 2026 PKComments Off

Circular Economy Startups Dashboard in Power BI is a professionally designed analytics template that helps sustainability-focused businesses, green investors, and circular economy advocates track, measure, and optimize startup performance across

Charts and Visualization

Excel Magic: Connect Charts Slicers in Seconds

January 10, 2024March 2, 2025 PKComments Off

Welcome to our step-by-step guide on how to seamlessly connect charts slicers in Excel. This tutorial is perfect for anyone looking to add a bit of magic to their data visualization

Charts and Visualization

3 Useful Tips for the Pivot Chart

May 16, 2021March 5, 2025 PKComments Off

In this article, you will learn 3 useful tips for the Pivot Chart. Using these tips you can create an interactive Excel Dashboard. Learn and download interactive Excel Dashboard free

Charts and Visualization

Dynamic Comparison Analysis Chart in Excel

May 3, 2021March 2, 2025 PKComments Off

In this article, you will learn how to create a dynamic comparison Analysis Chart in Microsoft Excel. Using this chart you can compare one employee's performance with other all employees

Charts and Visualization Dashboard

Top/Bottom Analysis dashboard in Excel

May 24, 2020September 19, 2026 PKComments Off

The Top/Bottom Analysis dashboard in Excel ranks employees and locations using a sample sales dataset. It combines slicers, Form Control option buttons and a scrollbar to change the ranking view

Excel Tips and Tricks

Pivot Table Super Tips in Excel

February 16, 2020October 7, 2024 PKComments Off

In this article, we have used two excel super tips for pivot table. You can use this tips in your excel report wherein you use pivot table. Below are the

Charts and Visualization

RAG waffle Chart visualization with Slicer

November 18, 2019March 5, 2025 PKComments Off

In this article, we have create a RAG waffle Chart visualization with slicer to display the Red, Amber and Green percentage. We have used Conditional Formatting and linked picture feature

Charts and Visualization

Dynamic Chart with Slicer in Excel: Employees by Age Group

July 17, 2019October 9, 2026 PKComments Off

A dynamic chart with slicer in Excel lets anyone click a department and instantly see how many employees fall into each age group. In this tutorial you build it from

Charts and Visualization

3D Container Pivot Chart in Excel with Slicer and Timeline

May 15, 2019October 9, 2026 PKComments Off

A 3D container pivot chart shows a percentage as a liquid level inside a glass-like box: the solid part is what you achieved and the see-through part is what is

Charts and Visualization

Dynamic Sales Funnel Chart in Excel with Slicers

May 8, 2019October 9, 2026 PKComments Off

A sales funnel chart in Excel shows how many deals move from one stage to the next, from the first identified lead down to the deals you won. In this