Course Description
Presenter: David Ringstrom, CPA
Effective Excel dashboards help users turn large amounts of data into clear, useful insights. In this course, Excel expert and author David Ringstrom, CPA, demonstrates practical techniques for assembling and refining dashboards with PivotTables and other built-in Excel tools.
You’ll learn how to create a dashboard from multiple PivotTables, refresh every PivotTable in a workbook at once, and use Recommended PivotTables to jump-start your analysis. The course also shows you how to manage information overload with Top 10 views, connect multiple PivotTables to a single slicer, and use timelines to filter data by date range.
Designed for professionals who summarize and analyze large amounts of spreadsheet data, this course provides practical techniques for creating dashboards that are easier to navigate, refresh, and understand.
Learning objectives:
- Connect two or more PivotTables to a single slicer
- Use a keyboard shortcut to enter a formula or value in multiple cells at once
- Identify which versions of Excel support slicers for PivotTables
- Refresh all PivotTables in a workbook at once
- Use Top 10 views and timelines to focus dashboard data
David H. Ringstrom, CPA, has more than 30 years of experience as a spreadsheet and accounting software consultant, author, and speaker. He has delivered more than 2,500 live presentations and is the author or co-author of ten books, including Microsoft 365 Excel All-in-One For Dummies, Microsoft 365 Excel For Dummies, Exploring Microsoft Excel’s Hidden Treasures, and QuickBooks Online For Dummies.
David focuses on practical Excel techniques that help professionals work more effectively. His guiding principle is simple: “Either you work Excel, or it works you.”
Review our course policies and procedures page for further information