Log On/Register  

855.838.5028

Excel: Dashboards

Duration: 1 Day, 2 Modules
Module Price: $130

Excel: Dashboards

Module 1

Lesson 1: Creating Advanced Formulas

Topic A: Use Range Names in Formulas

Topic B: Use Specialized Functions

 

Lesson 2: Automating Workbook Functionality

Topic A: Apply Data Validation

Topic B: Work with Forms and Controls

 

Lesson 3: Applying Conditional Logic

Topic A: Use Lookup Functions

Topic B: Combine Functions

 

Module 2

Lesson 4: Visualizing Data with Basic Charts

Topic A: Create Charts

Topic B: Modify and Format Charts

 

Lesson 5: Advanced Charting Techniques

Topic A: Use Advanced Chart Features

Topic B: Create Sparklines

 

Lesson 6: Analyzing Data with PivotTables, Slicers, and PivotCharts

Topic A: Create a PivotTable

Topic B: Analyze PivotTable Data

Topic C: Present Data with PivotCharts

Topic D: Filter Data by Using Slicers

Excel: Dashboards

Module 1

Lesson 1: Creating Advanced Formulas

Topic A: Use Range Names in Formulas

Topic B: Use Specialized Functions

 

Lesson 2: Automating Workbook Functionality

Topic A: Apply Data Validation

Topic B: Work with Forms and Controls

 

Lesson 3: Applying Conditional Logic

Topic A: Use Lookup Functions

Topic B: Combine Functions

 

Module 2

Lesson 4: Visualizing Data with Basic Charts

Topic A: Create Charts

Topic B: Modify and Format Charts

 

Lesson 5: Advanced Charting Techniques

Topic A: Use Advanced Chart Features

Topic B: Create Sparklines

 

Lesson 6: Analyzing Data with PivotTables, Slicers, and PivotCharts

Topic A: Create a PivotTable

Topic B: Analyze PivotTable Data

Topic C: Present Data with PivotCharts

Topic D: Filter Data by Using Slicers

Learn More
Please type the letters below so we know you are not a robot (upper or lower case):