Course length:  1-day

Course Overview

Excel is Microsoft’s powerful and easy-to-use spreadsheet program. This third part of Microsoft 365 Excel is intended to help all users get up to speed quickly on the advanced features of Excel.

By the end of this course, students should be comfortable in both the online and desktop environments, using automating functions, analyzing and presenting data, auditing and error checking their work, working in multiple workbooks, and accessing and distributing data.

Prerequisites

Excel Level 1 or equivalent knowledge

Excel Level 2 or equivalent knowledge

Outline

Worksheet Automation

  • Managing Workbook Properties
  • Working with Macros
  • Create and Use a Template

Auditing and Error Checking

  • Tracing Cells
  • Error Checking
  • Evaluating Formulas and Using the Watch Window and Camera Tool
  • Data List Outlines

Data Analysis and Presentation

  • Quick Analysis Tool
  • Adding Sparklines
  • What-If Analysis
  • The Analysis ToolPak
  • Solver Add-in
  • Explore the Power Pivot Add-in

Working with Multiple Workbooks

  • Arrange Workbooks
  • Linking to Data in Multiple Workbooks
  • Consolidating Data

Exporting and Sourcing Data

  • Exporting Data
  • Using Data Sources
  • Using a Microsoft Form for Data Collection

You may also be interested in:

Macros

Data Wrangling 

 

What's Next?

View our Excel Flowchart

 

 

Certification

Before testing you will need:

  • Excel Level 1 Foundation
  • Excel Level 2 Intermediate
  • Excel - Data Analysis and Forecasting Advanced

Is Excel - Data Analysis and Forecasting right for you?

Try our self-assessment