Call

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