Excel - Level 3 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 advanced tasks in Microsoft Excel. In this advanced Excel course, you will learn about: Alternative Data Sets, Dynamic Worksheets with PivotTables, Automating Repetitive Tasks with Macros, Working with Other Microsoft Office Apps, Business Intelligence Analysis, and Forecasts and Visualizations.


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
Excel - Level 2

Suggested Follow-Ons

Excel - VBA Programming
Excel - Dashboards

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

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

Registration Deadline - 04/08/2025

 

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

Registration Deadline - 04/22/2025

 

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

Registration Deadline - 05/06/2025

 

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

Registration Deadline - 05/20/2025

 

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

Registration Deadline - 06/03/2025

 

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

Registration Deadline - 06/17/2025

 

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

Registration Deadline - 07/01/2025

 

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

Registration Deadline - 07/15/2025

 

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

Registration Deadline - 07/28/2025

 

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

Registration Deadline - 08/12/2025

 

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

Registration Deadline - 08/26/2025

 

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

Registration Deadline - 09/09/2025

 

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

Registration Deadline - 09/23/2025

 

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

Registration Deadline - 10/07/2025

 

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

Registration Deadline - 10/21/2025

 

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

Registration Deadline - 11/04/2025

 

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

Registration Deadline - 11/18/2025

 

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

Registration Deadline - 12/02/2025

Start your training today!