Excel – Creating Dashboards
Get more from Excel – learn to use Forms, Lookup Functions, Charts, PivotTables, and Slicers to turn data into answers. Crunching numbers is what Microsoft Excel does best – but how do you use those numbers to get the answers you need? This course will show you how to use advanced Excel features to turn massive amounts of data into visual, customizable dashboards. The ability to easily query and display information from your Excel data is a helpful tool for decision making, and this course will demonstrate five advanced Excel features (Forms, Lookup Functions, Charts, Pivot Tables, and Slicers) which will do just that.
- Using Defined Names in a Formula
- Using Specialized Functions
- Applying Data Validation
- Using a Data Form
- Adding Form Controls
- Using Lookup Functions
- Combining Functions
- Working with Charts
- Inserting Pivot Tables
- Analyzing Pivot Table Data
- Presenting Data with Pivot Charts
- Filtering Data with Slicers
