If you need to keep tabs on essential data in your Excel spreadsheet, consider making an Excel Dashboard worksheet. This sheet is a handy reporting tool that displays key performance indicators through charts, tables, and views connected to your data. You can create your dashboard using Excel's built-in tools. In this 90-minute webinar, we'll show you how to make a simple dashboard using Excel's tools, such as tables, pivot tables, slicers, charts, and the Excel camera feature.

Topics include:

Adding a Dashboard Sheet
Adding PivotTables to the Dashboard Sheet
Grouping/Ungrouping Date Fields
Changing the Layout of a Pivot Table
Removing Subtotals from a Pivot Table
Changing the Format of a Pivot Table
Adding a Pivot Chart
Adding a Timeline to a Pivot Table
Adding a Slicer to a Pivot Table
Connecting Multiple Pivot Tables to Slicers/Timelines
Inserting a People Graph
Using the Excel Camera Tool
Hiding the Source Worksheets

Course materials include a quick reference guide and practice files. We will host this training using Teams.

Are you interested in offering this class to your organization?

Contact officeproductivitytraining@gmail.com for more information. Visit OfficeProductivityTraining.com to view information about our company and what services we offer.

Excel L4-Interactive Dashboards