Excel - Combo (Levels 1-3) Course



Course Details:

Length: 3 days

Price: $825/person (USD)

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

Enroll in all 3 Levels of our instructor-led Excel classes and save $60. This course package includes:


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

Course Notes

Course Combo Refund Policy: Once payment is received, there are no refunds on instructor-led course bundles, due to a discount being given. However, you may reschedule any of the included classes if needed.

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

• To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites. You can obtain this level of skills and knowledge by taking the Windows for End Users Course.

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

Excel - Level 1 (Day 1)

Chapter 1: Set up a workbook - 3 Create workbooks Modify workbooks
Modify worksheets
Merge and unmerge cells
Customize the Excel app window
• Manage the ribbon
• Manage the Quick Access Toolbar
• Customize the status bar
• Change the magnification level of a worksheet
• Arrange multiple workbook windows
Skills review
Practice tasks

Chapter 2: Work with data and Excel tables - 41
Enter and revise data
Manage data by using Flash Fill
Move data within a workbook
• Sidebar: Quickly access data-formatting commands
Find and replace data
Correct and fine-tune data
Define Excel tables
Skills review
Practice tasks

Chapter 3: Perform calculations on data - 71
Name data ranges
• Sidebar: Operators and Precedence
Create formulas to calculate values

Chapter 4: Change workbook appearance - 103
Format cells
Define and merge cell styles
Apply and modify workbook themes
Apply and modify table styles
Make numbers easier to read
Change the appearance of data based on its value
Add images to worksheets
Skills review
Practice tasks

Chapter 9: Create charts and graphics - 207
Create standard charts
Create combo charts
Create specialized charts
• Hierarchy charts
• Statistic charts
• Scatter charts
• Stock charts
• Map charts
Customize chart appearance
Identify data trends
Summarize data by using sparklines
Illustrate processes and relationships
Insert and manage shapes
Sidebar: Insert mathematical equations
Skills review
Practice tasks

Chapter 11: Print worksheets and charts - 285
Add headers and footers to printed pages
Prepare worksheets for printing
• Fit your worksheet contents to the printed page
• Change page breaks in a worksheet
• Change the page printing order for worksheets
Print worksheets
Print parts of worksheets
Print charts
Skills review
Practice task

 

Excel - Level 2 (Day 2)

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

 

Excel - Level 3 (Day 3)

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 10: Create PivotTables and PivotCharts - 253
Analyze data dynamically in PivotTables
Filter, show, and hide PivotTable data
Edit PivotTables
Format PivotTables
Create dynamic PivotCharts
Skills review
Practice tasks

Chapter 12: Automate tasks and input - 307
Enable and examine macros
• Set macro security levels in Excel
• Examine macros
Create and modify macros
Run macros
• Assign a macro to a Quick Access Toolbar button
• Assign a macro to a shape
• Run a macro when a workbook opens
Present information and options as form controls
Skills review
Practice tasks

Chapter 13: Work with other Microsoft 365 apps - 335
Combine Excel, Word, and PowerPoint content
• Link from Excel to a document or presentation
• Embed file content
Create hyperlinks from worksheets
Copy or link to charts
Skills review
Practice tasks

Chapter 15: Perform business intelligence analysis - 373
Manage the Excel Data Model
• Sidebar: Power View data visualizations
Define relationships between data sources
Manage data by using Power Pivot
Display data on timelines
Import data by using Power Query
Skills review
Practice tasks

Chapter 16: Create forecasts and visualizations - 403
Create Forecast Worksheets
• Linear forecasting
• Exponential smoothing forecasting
Define and manage measures
Define and display Key Performance Indicators
Create 3D maps
Skills review
Practice tasks






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/22/2025 10:00:00 AM
Online Class

Registration Deadline - 04/07/2025

 

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

Registration Deadline - 04/15/2025

 

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

Registration Deadline - 04/22/2025

 

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

Registration Deadline - 04/28/2025

 

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

Registration Deadline - 05/04/2025

 

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

Registration Deadline - 05/18/2025

 

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

Registration Deadline - 05/26/2025

 

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

Registration Deadline - 06/01/2025

 

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

Registration Deadline - 06/10/2025

 

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

Registration Deadline - 06/24/2025

 

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

Registration Deadline - 07/01/2025

 

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

Registration Deadline - 07/07/2025

 

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

Registration Deadline - 07/15/2025

 

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

Registration Deadline - 07/22/2025

 

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

Registration Deadline - 08/05/2025

 

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

Registration Deadline - 08/11/2025

 

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

Registration Deadline - 08/19/2025

 

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

Registration Deadline - 08/25/2025

 

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

Registration Deadline - 09/01/2025

 

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

Registration Deadline - 09/07/2025

 

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

Registration Deadline - 09/21/2025

 

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

Registration Deadline - 09/30/2025

 

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

Registration Deadline - 10/06/2025

 

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

Registration Deadline - 10/14/2025

 

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

Registration Deadline - 10/19/2025

 

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

Registration Deadline - 11/02/2025

 

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

Registration Deadline - 11/10/2025

 

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

Registration Deadline - 11/18/2025

 

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

Registration Deadline - 11/24/2025

 

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

Registration Deadline - 11/30/2025

Start your training today!