Home / Courses / Microsoft End User / Excel 2013: Level 2

Excel

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

 

Course Registration

 

1 day
$245.00

 

Course Outline

 

Request