Course length:  1-day

Course Description

Microsoft Office Excel is Microsoft’s popular spreadsheet program that allows users to organize, format, and calculate data with formulas using a structure broken up by rows and columns.

The Intermediate (Level 2) course is meant for those desiring to advance their skills in calculating data using functions and formulas, such as the VLOOKUP and IF; managing data using Tables and filters; and using PivotTables for analyzing and summarizing data.

Prerequisites

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

Excel Foundation or equivalent knowledge

Course Outline

Formulas and Functions

Working with Named Ranges

Managing Data

Working with Tables

Working with Records and Fields

Charting Data

Introduction to PivotTables

Certification

Before testing you will need:

  • Excel Level 1 Foundation
  • Excel Level 2 Intermediate
  • Excel Level 3 Advanced

 

 

Is Level 2 right for you?

Try our self-assessment