Microsoft

Microsoft Excel Level 4 EXL-04

Not sure this is the right class? Read What Microsoft Excel Class Should I Take?

  • 1 day
  • 1 upcoming date 1 open for booking
  • $295 per seat

Upcoming dates

Dates Where Status Seat Book
Nov 18 2026 Live Online 9:00 AM to 4:00 PM PT Confirmed to run $295

See every class on the schedule

About this class

Students will learn advanced features of pivot tables, functions, charts, macros, and will also round out their knowledge of Microsoft Excel.

Features and functions in Office 365 and Office 2021 / 2019 are nearly identical. For this reason, users for all versions (365, 2019) attend the same class. The instructor will explain the few visual differences in the versions to you; just let the instructor know what version you are using.

What you'll be able to do

  • Build custom date number formats for their cells
  • Use conditional aggregate functions
  • Use financial and array function
  • Manipulate data in Excel
  • Custom data separations
  • Utilize different ways to paste data
  • Use data validation with Lookups
  • Advanced pivot tables
  • Create a pivot table from a table
  • Group and ungroup dates
  • Format pivot tables
  • Drill down into your data
  • Adding calculated fields to pivot tables
  • Using slicers
  • Work with advanced macros
  • Recording macros
  • Examining and changing VBA code
  • Insert a button for your macro
  • Analyze data through statistical functions
  • Use statistical functions
  • Advanced charts

Before you attend

For this course, you should have the equivalent knowledge of the first three courses in the Microsoft Excel series, Levels one, two, and three. This involves your knowing how to build Excel files, enter formulas both for basic and complex calculations, format Excel files, sort and filter data, build charts, record macros, and run data analysis tools, such as pivot tables

Course outline

  1. Module 1Advanced Formats and Functions

    • Building Custom Date and Number Formats
    • Using Conditional Aggregate Functions
    • Using Financial Functions
    • Using Array Functions

  2. Module 2Manipulating Data

    • Custom Data Separations
    • Utilize Different Ways to Paste Data
    • Use Data Validation with Lookups

  3. Module 3Advanced Pivot Tables

    • Create a PivotTable from a Table
    • Group and Ungroup Dates
    • Format Pivot Tables
    • Update Pivot Table Information
    • Drill down into the PivotTable
    • Add Calculated Fields to Pivot Tables
    • Use Slicers

  4. Module 4Working with Advanced Macros

    • Record Macros
    • Examine VBA Code
    • Change VBA Code
    • Copy an existing macro
    • Add button controls

  5. Module 5Using Statistical Functions

    • Using RANK Functions
    • Using Standard Deviation Functions
    • Using other Deviation Functions

  6. Module 6Advanced Charts

    • Creating a chart style
    • Adjusting data ranges
    • Saving chart templates
    • Using chart templates

Download the full outline (PDF)

Run this for a team

Private cohorts run on your dates, at your site or online, with the labs pointed at your environment. Above about four people it usually costs less than buying seats.

Or call 916-920-1700, weekdays 8 to 5 Pacific.

More desktop applications classes

See all