Excel 2013: Level 2

Lesson 1: Creating Advanced Formulas
Topic A: Apply Range Names
Topic B: Use Specialized Functions
Lesson 2: Analyzing Data with Logical and Lookup Functions
Topic A: Leverage Questions and Testing to Write Formulas
Topic B: Use Logical and Lookup Functions to Find Answers to Questions
Lesson 3: Organizing Worksheet Data with Tables
Topic A: Create and Modify Tables
Topic B: Sort and Filter Data
Topic C: Use Summary and Database Functions to Calculate Data
Lesson 4: Visualizing Data with Charts
Topic A: Create Charts
Topic B: Modify and Format Charts
Topic C: Create a Trendline
Topic D: Create Advanced Charts
Lesson 5: Analyzing Data with PivotTables, Slicers, and PivotCharts
Topic A: Create a PivotTable
Topic B: Filter Data by Using Slicers
Topic C: Analyze Data by Using PivotCharts
Lesson 6: Inserting Graphics
Topic A: Insert and Modify Graphic Objects
Topic B: Layer and Group Graphic Objects
Topic C: Incorporate SmartArt
Lesson 7: Enhancing Workbooks
Topic A: Customize Workbooks
Topic B: Manage Themes
Topic C: Create and Use Templates
Topic D: Protect Files