Excel 2024: Build Dashboards with Sparklines and Slicers

May 24, 2024 - by Bill Jelen

New tools debuted in Excel 2010 that let you create interactive dashboards that do not look like Excel. This figure shows an Excel workbook with two slicers, Region and Line, used to filter the data. Also in this figure, pivot charts plus a collection of sparkline charts illustrate sales trends.

A dashboard with two charts, sparklines and two slicers.

You can use a setup like this and give your manager's manager a touch screen. All you have to do is teach people how to use the slicers, and they will be able to use this interactive tool for running reports. Touch the East region and the Books line. All of the charts update to reflect sales of books in the East region.

More Reading

Excel 2024: Use a Pivot Table to Compare Lists »

May 22, 2024 - by Bill Jelen

When you think of comparing lists, you probably think of VLOOKUP. If you have two lists to compare, you need to add two columns of VLOOKUP.

Excel 2024: Replicate a Pivot Table for Each Rep »

May 20, 2024 - by Bill Jelen

Here is a great trick I learned from Southern California based Excel consultant Szilvia Juhasz.

Excel 2024: Make Pivot Tables Expandable Using Ctrl+T »

May 15, 2024 - by Bill Jelen

If you choose all of columns A:J and you later want to add more records below the data, it takes only a simple Refresh to add the new data instead of having to find the Change Data Source icon. In the past, this made sense. But today, Change Data Source is right next to the Refresh button and not hard to find.

Programming PowerPoint with VBA

February 2022

This book assumes you already use PowerPoint and want to automate or enhance your presentations using Visual Basic for Applications (VBA). This book includes VBA samples for working with layouts, themes & masters, creating tables, drawing objects, charting, animation effects and event programming.

Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365)

April 2022

Use this guide to automate virtually any routine Excel task: save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you won't find anywhere else, and create automated reports that are amazingly powerful.

Your Excel Survival Kit - Second Edition

March 2021

This book helps you realize that Excel is on your side. It can be your friend, not your enemy. If and when you upgrade your Excel skills you will experience many positives: you will learn to love Excel, you will learn how to use Excel to become an invaluable asset in your workplace.

Supercharge Power BI - 3rd Edition

February 2021

Released in 2021, this book will teach you the DAX language from the ground up, using Power BI as your canvas.

see more products »

Excel 2024: Build Dashboards with Sparklines and Slicers

More Reading

Featured Products