Microsoft® Excel® 2013: Dashboards

Microsoft® Excel® 2013: 

< 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