How much does Microsoft Excel Level 2 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 2?

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 2 class?

The next scheduled date is Wed, Oct 14. There are 7 upcoming dates in total, 1 of which is guaranteed to run regardless of enrollment.

Is Microsoft Excel Level 2 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 2?

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 2?

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-02 Microsoft Excel Level 2 | 1-day class

Upcoming dates

All times shown in the class's own timezone. 1 of 7 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
Wed, Oct 14	9:00 AM to 4:00 PM PDT Taught by us	Live virtual	GUARANTEED	$295
Wed, Oct 21	9:00 AM to 4:00 PM PDT Taught by us	Live virtual	RUNS WITH 1+	$295
Tue, Nov 3	9:00 AM to 4:00 PM PST Taught by us	Live virtual	RUNS WITH 1+	$295
Tue, Nov 10	9:00 AM to 4:00 PM PST Taught by us	Live virtual	RUNS WITH 1+	$295
Tue, Nov 24	9:00 AM to 4:00 PM PST Taught by us	Live virtual	RUNS WITH 1+	$295
Tue, Dec 15	9:00 AM to 4:00 PM PST Taught by us	Live virtual	RUNS WITH 1+	$295
Wed, Dec 30	9:00 AM to 4:00 PM PST Taught by us	Live virtual	RUNS WITH 1+	$295

About this class

We have 7 scheduled dates of Microsoft Excel Level 2, from Wed, Oct 14 through Wed, Dec 30. 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?

Whether you need to crunch numbers for sales, inventory, information technology, human resources, or other organizational purposes and departments, the ability to get the right information to the right people at the right time can create a powerful competitive advantage. After all, the world runs on data more than ever before and that’s a trend not likely to hange, or even slow down, any time soon. But with so much data available and being created on a nearly constant basis, the ability to make sense of the data becomes more critical and challenging with every passing day. You already know how to get Microsoft Excel to perform simple calculations and how to modify your workbooks and worksheets to make them easier to read, interpret, and present to others. But, Excel is capable of doing so much more. To gain a truly competitive edge, you need to be able to extract actionable, organization intelligence from your raw data. In other words, when you have questions about your data, you need to know how to get Excel to provide the answers for you. And that’s exactly what this course aims to help you do. During this one-day, instructor-led course, students will learn how to perform advanced calculations; use advanced functions, including IF and VLookup; use sort and filter options; create Excel tables; create Excel templates and themes; create pivot tables and pivot charts; create and modify charts; and use Excel Sparklines

Features and functions in Office 365 and Office 2019 / 2016 are nearly identical. For this reason, users for all three versions (365, 2019 and 2016) 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

Perform and use advanced calculations in worksheets
Calculate using IF functions
Use the VLookup function
Use database functions
Create Excel tables
Create Excel templates and themes
Create Pivot tables and Pivot charts
Create and modify charts
Use Excel Sparklines

Course outline

Module 1 Performing Advanced Calculations

Naming Cell Ranges
Editing Cell Ranges
Calculating Functions on Multiple Ranges
Calculating Data with Multiple Sheets
Calculating Date Functions
Using Formula Functions

Module 2 Using Advanced Functions

Calculating Using IF Functions
Using the VLOOKUP Function
Using Database Functions

Module 3 Using Sort and Filter Options

Sorting Data
Creating a Filter
Creating an Advanced Filter

Module 4 Creating Excel Tables

Inserting an Excel Table and Creating a Table Style
Creating Table Calculations
Filtering Tables
Creating Subtotals

Module 5 Creating Excel Templates and Themes

Using a Built-in Excel Template
Creating a Template from an Existing Workbook
Creating an Excel Theme

Module 6 Creating Pivot Tables and Pivot Charts

Creating a Pivot Table
Pivoting Data in a Pivot Table
Creating a Pivot Chart
Changing the Look of a Pivot Chart
Creating and Modifying Charts
Creating Charts
Working with Chart Layouts
Formatting a Chart

Module 7 Using Excel Sparklines

Building Sparklines
Customizing Sparklines

Before you attend

Completion of the following course or equivalent knowledge and skills is recommended:
-Microsoft Excel Level 1