Course length:  1-day

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

Lesson 1: Excel Online

  • Topic A: Accessing and Using Excel Online
  • Topic B: Features that Differ Between Excel Online and the Excel Desktop Application

Lesson 2: Worksheet Automation

  • Topic A: Managing Workbook Properties
  • Topic B: Working with Macros
  • Topic C: Create and Use a Template
  • Topic D: Use Data Validation in a Workbook

Lesson 3: Auditing and Error Checking

  • Topic A: Tracing Cells
  • Topic B: Error Checking
  • Topic C: Evaluating Formulas and Using the Watch Window
  • Topic D: Data List Outlines

Lesson 4: Data Analysis and Presentation

  • Topic A: Quick Analysis Tool
  • Topic B: Adding Sparklines
  • Topic C: What-If Analysis
  • Topic D: The Analysis ToolPak

Lesson 5: Working with Multiple Workbooks

  • Topic A: Arrange Workbooks
  • Topic B: Linking to Data in Multiple Workbooks
  • Topic C: Consolidating Data

Lesson 6: Exporting and Sourcing Data

  • Topic A: Exporting Data
  • Topic B: Using Data Sources
  • Topic C: Use 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 Level 3 Advanced

Is Level 3 right for you?

Try our self-assessment