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