Microsoft® Excel® 2013: Level 2

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