Microsoft Excel, Level 2

Session Detail:    Classroom, Virtual 2013, 2016, Office 365 1 Day

Session Detail:

This course is intended to help all users get up to speed on the different features of Excel and to become familiar with its more advanced selection of features. We will cover how to create and use advanced formulas, analyze data, organize worksheet data with tables, visualize data with charts, insert graphics, and enhance workbooks.

What You’ll Learn

  • Creating Advanced Formulas
  • Analyzing Data with Logical and Lookup Functions
  • Organizing and Analyzing Datasets and Tables
  • Visualizing Data with Charts
  • Analyzing Data with PivotTables, Slicers, and PivotCharts
  • Inserting Graphics
  • Enhancing Workbooks

Session Outline

Lesson 1: Creating Advanced Formulas

Topic A: Use Range Names in Formulas

Topic B: Use Specialized Functions

Lesson 2: Analyzing Data with Logical and Lookup Functions

Topic A: Use Text Functions

Topic B: Use Logical Functions

Topic C: Use Lookup Functions

Topic D: Use Date Functions

Topic E: Use Financial Functions

Lesson 3: Organizing Worksheet Data with Tables

Topic A: Create and Modify Tables

Topic B: Sort and Filter Data

Topic C: Use Subtotal and Database Functions to Calculate Data

Lesson 4: Visualizing Data with Basic 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 with 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

Topic E: Preparing a Workbook for Multiple Audiences

Need to train your team?

All of our sessions can be customized to meet your team’s specific need. Build the perfect program by picking and choosing topics from any of the courses in our catalog. A personalized private session gives you the ultimate flexibility and helps maximize your team’s valuable time!

Requesting Team Training
DateTimeTypePriceAdd To Cart
Jun 19, 20209:00AM-4:00PM ESTClassroom$265.00
Jun 19, 20209:00AM-4:00PM ESTVirtual$265.00
Jul 20, 20209:00AM-4:00PM ESTClassroom$265.00
Jul 20, 20209:00AM-4:00PM ESTVirtual$265.00
Aug 18, 20209:00AM-4:00PM ESTClassroom$265.00
Aug 18, 20209:00AM-4:00PM ESTVirtual$265.00
Sep 18, 20209:00AM-4:00PM ESTClassroom$265.00
Sep 18, 20209:00AM-4:00PM ESTVirtual$265.00
Oct 20, 20209:00AM-4:00PM ESTClassroom$265.00
Oct 20, 20209:00AM-4:00PM ESTVirtual$265.00
Nov 20, 20209:00AM-4:00PM ESTClassroom$265.00
Nov 20, 20209:00AM-4:00PM ESTVirtual$265.00
Dec 14, 20209:00AM-4:00PM ESTClassroom$265.00
Dec 14, 20209:00AM-4:00PM ESTVirtual$265.00

Microsoft Excel, Level 2

1 Day
Classroom, Virtual



Chat with a Coach

Chat with a Coach

Have a more immediate need? Why spend the next hour searching online for answers when you can spend just 15 minutes with one of our experts and get accurate and personalized answers to all of your questions. 

$9.99 | 15 Minutes

Book Now