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

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

 

Explore Microsoft Excel Classes Near Me:

 

 



Start your training today!