Call

Microsoft® Excel® 2013: Dashboards

< Back to Course Catalog

Duration:

1 Day (6.5 instructional hours)

Excel 2013

Course Number: 091036

Course Objective:  

You will create advanced workbooks and worksheets that you can use to create dashboards and analyze data. 

Target Student: 

This course is meant for those desiring to gain advanced skills in Excel to summarize table data in Excel by using

functions, charts, and PivotTables and display those elements in a dashboard format.

Course Objective: 

To ensure success, students will need to be familiar with using or have equivalent knowledge of 

Microsoft® Office

Excel® 2013: Level 1.

Course Outline

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

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

Pivot Charts 

Topic A: Create a PivotTable

Topic B: Analyze PivotTable Data

Topic C: Present Data with PivotCharts                  

Topic D: Filter Data by Using Slicers

< Back to Course Catalog