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
Nov 25, 20199:00AM-4:00PM ESTClassroom$265.00
Nov 25, 20199:00AM-4:00PM ESTVirtual$265.00
Dec 17, 20199:00AM-4:00PM ESTClassroom$265.00
Dec 17, 20199:00AM-4:00PM ESTVirtual$265.00

Microsoft Excel, Level 2

1 Day
Classroom, Virtual

$265.00

Clear

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