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. Instead of splurging on expensive software, 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, data validation tools, 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.
