Microsoft® Excel® 2013: Level 2

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