In this beneficial presentation, Excel expert David H. Ringstrom, CPA, introduces you to Excel dashboards. Dashboards are quite popular because they empower users to quickly assimilate large amounts of data by way of charts and summary tables. David demonstrates how to: use Excel’s Pivot Table feature to create charts that display data trends, filter data faster using the Slicer feature in Excel 2010 and later, present a variety of information in dashboard form, use the Linked Picture feature to place pivot tables in close proximity to each other, and more.

David typically teaches from Excel 2016, but he points out any differences in earlier versions of Excel. He’s also happy to demonstrate techniques in a specific version of Excel upon request. David’s detailed handouts, with numbered steps, serve as reference material you can utilize going forward. He also provides an Excel workbook that includes a majority of the examples he uses to demonstrate techniques during the presentation.

• Create a dashboard that looks less like an Excel spreadsheet by hiding screen elements
• Create dynamic and interactive graphs with Excel’s Pivot Chart feature
• Discover how Microsoft Query allows you to create self-updating links to databases, spreadsheets, text files, and other data sources
• Filter data faster by way of the Slicer feature in Excel 2010 and later
• Learn how to control multiple pivot tables and charts instantly with the Slicer feature in Excel 2010 and later
• Learn why certain features, including slicers, sparklines, and charts, are disabled in some workbooks
• Use Excel’s Pivot Table feature to condense large amounts of information into manageable chunks
• Use the Linked Picture feature to place pivot tables in close proximity to each other without posing conflicts

Learning Objectives