Excel - Level 2 Course



Course Details:

Length: 1 day

Price: $275/person (USD)

Group Price: Request Quote

Training Reviews

Course Features:

Live Instructor Teaching

Certificate of Completion

Courseware: Print

Hands-On Learning?: Yes

Software Lab Included?: Yes

Delivery Methods:

Live Online

Individuals and Groups
@ Your Location or Our Labs

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.

How Online Classes Work? - Learn How Our Live Online Classes Work

 

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: Office 2021, 365, 2019, 2016, & 2013 (Microsoft Windows PC)
Course Taught With: Office version 2019/365 (Microsoft Windows PC) Software and Excel 2021/365 Courseware
Not Appropriate For: Macintosh versions of Office

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
ave workbook content as a PDF file
Create and distribute workbook templates
Skills review
Practice tasks

 

Explore Microsoft Excel Classes Near Me:

 

 



Start your training today!