How much does Microsoft Excel Level 4 cost?

$295 per seat. That covers courseware and lab access. Exam vouchers are quoted separately. Volume pricing is available for teams, and a private cohort is usually cheaper per seat past about four people.

How long is Microsoft Excel Level 4?

1 day of instructor-led training, delivered live online. Classes run during business hours in the timezone shown on each date.

When is the next Microsoft Excel Level 4 class?

The next scheduled date is Fri, Oct 16. There are 2 upcoming dates in total, 1 of which is guaranteed to run regardless of enrollment.

Is Microsoft Excel Level 4 delivered online?

Yes. It runs live online with an instructor, not as a recording, so you can ask questions as you go. It can also be delivered privately at your site.

Can a government agency buy Microsoft Excel Level 4?

Yes. Purchase orders and government purchase cards are both accepted at checkout, and quotes can be formatted for a solicitation response. Terms are net 30 on invoiced orders.

What happens if I need to cancel Microsoft Excel Level 4?

Course fees are fully refundable with written notice at least ten business days before the class. Inside that window the fee is forfeited, though one free retake is available within six months of the class date.

EXL-04 Microsoft Excel Level 4 | 1-day class

Upcoming dates

All times shown in the class's own timezone. 1 of 2 are guaranteed to run, meaning they go ahead regardless of enrollment. Dates we teach ourselves run once 1 people are booked, so a pair of seats confirms one.

Dates	Starts	Where	Status	Seat	Book
Fri, Oct 16	9:00 AM to 4:00 PM PDT Taught by us	Live virtual	RUNS WITH 1+	$295
Wed, Nov 18	9:00 AM to 4:00 PM PST Taught by us	Live virtual	GUARANTEED	$295

About this class

We have 2 scheduled dates of Microsoft Excel Level 4, from Fri, Oct 16 through Wed, Nov 18. 1 of them is guaranteed to run regardless of enrollment. We teach this one ourselves, with our own instructors and courseware. Seats are $295 each over 1 day, courseware included. Book online with a card, or send a purchase order and we will invoice on net 30 terms.

Which Microsoft Excel Course should I take?

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

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

Course outline

Module 1 Advanced Formats and Functions

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

Module 2 Manipulating Data

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

Module 3 Advanced 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

Module 4 Working with Advanced Macros

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

Module 5 Using Statistical Functions

Using RANK Functions
Using Standard Deviation Functions
Using other Deviation Functions

Module 6 Advanced Charts

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

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