1 Day (6.5 instructional hours)
Course Number: 091036
You will create advanced workbooks and worksheets that you can use to create dashboards and analyze data.
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.
To ensure success, students will need to be familiar with using or have equivalent knowledge of
Excel® 2013: Level 1.
Topic A: Use Range Names in Formulas
Topic B: Use Specialized Functions
Topic A: Apply Data Validation
Topic B: Work with Forms and Controls
Topic A: Use Lookup Functions
Topic B: Combine Functions
Topic A: Create Charts
Topic B: Modify and Format Charts
Topic A: Use Advanced Chart Features
Topic B: Create Sparklines
Topic A: Create a PivotTable
Topic B: Analyze PivotTable Data
Topic C: Present Data with PivotCharts
Topic D: Filter Data by Using Slicers