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.
