Course length:  1-day

This course is intended to help all users become familiar with the more advanced selection of features of Excel. We will cover how to create and use advanced formulas, analyze data, organize worksheet data with tables, visualize data with charts, work with graphical objects, and enhance workbooks.

Prerequisites

To be successful in this course, you should have completed Excel Level 1 or have equivalent knowledge.

Course Outline

Lesson 1: Creating Advanced Formulas

  • Topic A: Apply Range
  • 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 Format Tables
  • Topic B: Modifying Tables
  • Topic C: Table References

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 Using Slicers
  • Topic C: Analyze Data with PivotCharts

Lesson 6: Working with Graphical Objects

  • 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: Protect Files
  • Topic D: Preparing a Workbook for Multiple Audiences

You may also be interested in:

Excel Level 3

Formulas

Macros

What's Next?

View our Excel Flowchart

Certification

Before testing you will need:

 

 

Is Level 2 right for you?

Try our self-assessment