Microsoft

Microsoft Excel Level 4 EXL-04

  • 2 upcoming dates 1 open for booking
  • $295 per seat

Upcoming dates

Dates Where Status Seat Book
Oct 16 2026 Live Online 9:00 AM to 4:00 PM PT Scheduled $295
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 2019 / 2016 are nearly identical. For this reason, users for all versions (365, 2019.2016 and 2013) 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

  • Advanced Formats and Functions
  • Manipu lating Data
  • Advanced Pivot Tables
  • Working with Advanced Macros
  • Using Statistical Functions
  • A dvanced Chart s

Course outline

  1. Module 1Advanced Formats and Functions

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

  2. Module 2Manipu lating 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 6A dvanced Chart s

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

Download the full outline (PDF)

Before you attend

e Insert a button for your macro Analyze data through statistic al functions Us e statistical functions Advanced charts equivalent knowledge of the first three courses in the Microsoft Excel series, Levels one, two, and three. T his 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

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
Microsoft Access Level 1
Microsoft ACC-01

Microsoft Access Level 1

  • $650 per seat
Next: Oct 1–2 Confirmed to run

2 dates on the calendar