Microsoft® Excel® 2013: Level 2
< Back to Course Catalog
Duration:
1 Day (6.5 instructional hours)
Excel 2013
Course Number: 091052
Course Objective:
Upon successful completion of this course, you will be able to leverage the power of data analysis and
presentation in order to make informed, intelligent organizational decisions.
Target Student:
This course is intended for students who already have the foundational understanding of Microsoft Office Excel 2013 and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data.
Course Objective:
To ensure success, students will need to be familiar with or have the equivalent knowledge and experience of Microsoft® Office Excel® 2013: Part 1 (Second Edition).
Course Outline
Lesson 1: Customizing the Excel Environment
Topic A: Configure Excel Options
Topic B: Customize the Ribbon and the Quick Access Toolbar
Topic C: Enable Excel Add-Ins
Lesson 2: Creating Advanced Formulas
Topic A: Use Range Names in Formulas
Topic B: Use Specialized Functions
Topic C: Use Array Formulas
Lesson 3: Analyzing Data with Functions and Conditional
Formatting
Topic A: Analyze Data by Using Text and Logical Functions
Topic B: Apply Advanced Conditional Formatting
Lesson 4: Organizing and Analyzing Datasets and Tables
Topic A: Create and Modify Tables
Topic B: Sort Data
Topic C: Filter Data
Topic D: Use SUBTOTAL and Database Functions
Lesson 5: Visualizing Data with Basic Charts
Topic A: Create Charts
Topic B: Modify and Format Charts
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
< Back to Course Catalog
