Excel - Level 2 Course



Course Details:

Length: 1 day

Price: $295/person (USD)

Bundle & Save: View Bundle

Group Price: Request Quote

Training Reviews

Course Features:

Live Instructor Teaching

Certificate of Completion

Digital Badge

Courseware: Print

Free 6 Month Online Retake

Hands-On Learning?: Yes

Software Lab Included?: Yes

Delivery Methods:

Live Online

Individuals and Groups
@ Your Location

Onsite for Teams

Group Teams
@ Your Organization

This is an instructor-led course. It is taught by an instructor live online or at organizations for groups.
For team training, we can teach onsite at your office or private live online.

 

Course Overview

This course will teach students how to perform more advanced calculations and work with larger worksheets in Microsoft Excel. In this intermediate Excel course, you will learn how to: Perform Calculations on Data, Manage Worksheet Data, Reorder and Summarize Data, Combine Data from Multiple Sources, Analyze Alternative Data Sets, and Collaboration.


Register Early: Registration Deadline is 2 Weeks Prior to Class Start.


Course Notes

Versions That Can Attend: Desktop Version of Office 2021, 365, 2019, 2016 (Microsoft Windows PC or Macintosh)
Course Taught With: Desktop Version of Office version 365/2019 (Microsoft Windows PC) Software and Courseware


Knowledge Prerequisites

Excel - Level 1

Suggested Follow-Ons

Excel - Level 3

Related Certifications

MOS: Microsoft Excel Expert Certification
MOS: Microsoft Excel Associate Certification

Certification Notes: Certification exams are administered by third party testing companies. Our courses prepare you for the certification exam, which is an additional fee paid to the testing provider. You must contact the corresponding testing provider to take a certification exam.


Course Topics

Chapter 3: Perform calculations on data - 71
Summarize data that meets specific conditions
Copy and move formulas
Create array formulas
Find and correct errors in calculations
Configure automatic and iterative calculation options
Skills review
Practice tasks

Chapter 5: Manage worksheet data - 137
Filter data ranges and tables
Summarize filtered data
• Sidebar: Randomly select list rows
Enforce data entry criteria
Skills review
Practice tasks

Chapter 6: Reorder and summarize data - 159
Sort worksheet data
Sort data by using custom lists
Outline and subtotal data
Skills review
Practice tasks

Chapter 7: Combine data from multiple sources - 175
Look up data from other locations
• Locate information in the same row (VLOOKUP)
• Locate information in the same column (HLOOKUP)
• Locate information anywhere (XLOOKUP)
Link to data in other locations
Consolidate multiple sets of data
Skills review
Practice tasks

Chapter 8: Analyze alternative data sets - 193
Define and display alternative datasets
Forecast data by using data tables
Identify the input necessary to achieve a specific result
Skills review
Practice tasks

Chapter 14: Collaborate with colleagues - 351
Manage comments
Protect workbooks and worksheets
Finalize workbooks
Save workbook content as a PDF file
Create and distribute workbook templates
Skills review
Practice tasks

Course FAQs

This course is taught by a live instructor and is available in two class formats:

  1. Live Online for Individuals
  2. Onsite/Online for Private Groups







Related Microsoft Excel Information:

Individual live Certstaffix Excel training prices start at $295 per student. Group Excel training cost discounts are available.

Excel eLearning courses cost $150 at the starting point per student. Group purchase discounts are available.

 







Registration:

Have a Group?
Request Private Training

4/1/2025 10:00:00 AM
Online Class

Registration Deadline - 03/17/2025

 

4/8/2025 10:00:00 AM
Online Class

Registration Deadline - 03/24/2025

 

4/23/2025 10:00:00 AM
Online Class

Registration Deadline - 04/08/2025

 

5/2/2025 10:00:00 AM
Online Class

Registration Deadline - 04/15/2025

 

5/8/2025 10:00:00 AM
Online Class

Registration Deadline - 04/22/2025

 

5/14/2025 10:00:00 AM
Online Class

Registration Deadline - 04/29/2025

 

5/20/2025 10:00:00 AM
Online Class

Registration Deadline - 05/05/2025

 

6/3/2025 10:00:00 AM
Online Class

Registration Deadline - 05/19/2025

 

6/11/2025 10:00:00 AM
Online Class

Registration Deadline - 05/27/2025

 

6/17/2025 10:00:00 AM
Online Class

Registration Deadline - 06/02/2025

 

6/26/2025 10:00:00 AM
Online Class

Registration Deadline - 06/10/2025

 

7/11/2025 10:00:00 AM
Online Class

Registration Deadline - 06/24/2025

 

7/17/2025 10:00:00 AM
Online Class

Registration Deadline - 07/01/2025

 

7/23/2025 10:00:00 AM
Online Class

Registration Deadline - 07/08/2025

 

7/31/2025 10:00:00 AM
Online Class

Registration Deadline - 07/15/2025

 

8/8/2025 10:00:00 AM
Online Class

Registration Deadline - 07/22/2025

 

8/22/2025 10:00:00 AM
Online Class

Registration Deadline - 08/05/2025

 

8/27/2025 10:00:00 AM
Online Class

Registration Deadline - 08/12/2025

 

9/4/2025 10:00:00 AM
Online Class

Registration Deadline - 08/19/2025

 

9/10/2025 10:00:00 AM
Online Class

Registration Deadline - 08/26/2025

 

9/17/2025 10:00:00 AM
Online Class

Registration Deadline - 09/02/2025

 

9/24/2025 10:00:00 AM
Online Class

Registration Deadline - 09/09/2025

 

10/7/2025 10:00:00 AM
Online Class

Registration Deadline - 09/22/2025

 

10/16/2025 10:00:00 AM
Online Class

Registration Deadline - 09/30/2025

 

10/22/2025 10:00:00 AM
Online Class

Registration Deadline - 10/07/2025

 

10/30/2025 10:00:00 AM
Online Class

Registration Deadline - 10/14/2025

 

11/4/2025 10:00:00 AM
Online Class

Registration Deadline - 10/20/2025

 

11/18/2025 10:00:00 AM
Online Class

Registration Deadline - 11/03/2025

 

11/26/2025 10:00:00 AM
Online Class

Registration Deadline - 11/11/2025

 

12/4/2025 10:00:00 AM
Online Class

Registration Deadline - 11/18/2025

 

12/10/2025 10:00:00 AM
Online Class

Registration Deadline - 11/25/2025

 

12/17/2025 10:00:00 AM
Online Class

Registration Deadline - 12/02/2025

 

12/30/2025 10:00:00 AM
Online Class

Registration Deadline - 12/15/2025

Start your training today!