Course length:  2-days

Course Overview

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.

Outline

Creating Advanced Formulas

  • Cell References
  • Working with Named Ranges
  • Formula Auditing

Analyzing Data with Functions

  • Text Functions
  • Logical Functions
  • Lookup Functions
  • Date Functions
  • Protecting Worksheets

Organizing Worksheet Data with Tables

  • Create and Format Tables
  • Total Row
  • Removing Duplicates
  • Table References

Analyzing Data with Data Tools

  • Data Validation
  • Advanced Filter
  • Conditional Formatting with Rules
  • Database Functions
  • Subtotal Functions

Visualizing Data with Charts

  • Selecting appropriate charts for data
  • Modify and format various charts

Introduction to PivotTables

  • Create basic PivotTables
  • Sort and Filter PivotTables
  • Insert PivotCharts and Slicers

Working with Graphical Objects

You may also be interested in:

Excel - Data Analysis and Forecasting

Advanced 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