Microsoft Excel Dashboards

Section 1: Using Names in Formulas and Functions

Examine Dashboards

Use Range Names in Formulas

Use Specialized Functions

Section 2: Automating Workbook Functionality

Apply Data Validation

Work with Forms and Controls

Section 3: Applying Conditional Logic

Use Lookup Functions

Combine Functions

Section 4: Visualizing Data with Basic Charts

Create Charts

Modify and Format Charts

Section 5: Using Advanced Charting Techniques

Create Dual-Axis Charts and Trendlines

Create Sparklines

Section 6: Analyzing Data with Pivot Tables, Pivot Charts, and Slicers

Create a Pivot Table

Analyze Pivot Table Data

Present Data with Pivot Charts

Filter Data by Using Slicers