
Advanced Microsoft Excel Training
This Advanced Microsoft Excel class teaches you to perform important data management and analysis tasks.
You will learn to summarize your data using PivotTables, audit and analyze worksheet data, consolidate data from multiple sources, collaborate with others, automate repetitive tasks, and more.
By the end of this course, you will be ready to use Excel's most powerful tools to manage your data and gain actionable business insights.
Excel Version: This course primarily targets Excel 365 and Excel 2021; however, we draw attention to features that are not supported in earlier versions of Excel, and point out alternative options, when available.
- Create PivotTables and charts to quickly summarize large amounts of data.
- Work with some of Excel's more advanced functions.
- Learn to trace precedents and dependents to learn about the data connected to your active cell.
- Convert blocks of text into columns.
- Leverage data validation tools to control the data entered into your worksheet.
- Consolidate data from various sources into one master worksheet for easy summary and review.
- Protect your worksheets and workbooks for safe and secure collaboration.
- Work with other applications by importing and exporting data, charts, and files.
Public expert-led online training from the convenience of your home, office or anywhere with an internet connection. Guaranteed to run .
Private classes are delivered for groups at your offices or a location of your choice.
Learn at your own pace with 24/7 access to an On-Demand course.
Webucator is a Microsoft Certified Partner for Learning Solutions (CPLS). Our curriculum has been tested and approved by ProCert Labs, the official tester of Microsoft courseware, and has been found to meet the highest industry standards of instructional quality.

- Using PivotTables
- How PivotTables Work
- Timeline Filters
- Inserting Slicers
- Grouping Data
- Calculated Fields
- PivotCharts
- Working with PivotTables (exercise)
- Advanced Functions
- Function Syntax
ROWS
,COLUMNS
,INDEX
, andXMATCH
- Arrays and Array Formulas
- Getting Unique Values (exercise)
SORT
,FILTER
, andSORTBY
- Lookup Functions
- Using the
XLOOKUP
Function (exercise) - The
LET
Function - The
TRANSPOSE
Function
- Auditing Workbooks
- Inspecting a Workbook
- Tracing Precedents and Dependents
- Tracing Precedents and Dependents Practice (exercise)
- Watch Window
- Evaluating Formulas
- Error Checking
- Data Tools
- Importing Data from online source
- Converting Text to Columns
- Converting Text to Columns (exercise)
- Importing Files
- Importing Text Files (exercise)
- Linking to External Data
- Controlling Calculation Options
- Data Validation
- Using Data Validation (exercise)
- Consolidating Data
- Consolidating Data (exercise)
- What-If Analysis
- Using Goal Seek (exercise)
- Working with Others
- Comments and Notes
- Protecting Worksheets and Workbooks
- Password Protecting a Workbook (exercise)
- Marking a Workbook as Final
- Other Sharing Concerns
- Recording and Using Macros
- Recording Macros
- Recording a Macro (exercise)
- Running Macros
- Editing Macros
- Adding Macros to the Quick Access Toolbar
- Adding a Macro to the Quick Access Toolbar (exercise)
Each student will receive a comprehensive set of materials, including course notes and all the class examples.
Experience in the following is required for this Microsoft Excel class:
- Basic and Intermediate Excel experience.
Courses that can help you meet these prerequisites:
Register for a Live Class
Request a Private Class
- Private Class for your Team
- Online or On-location
- Customizable
- Expert Instructors
Self-Paced Course
- On Demand 24/7
- Readings
- Presentations
- Exercises
- Quizzes
- Full Year of Access
- Learn more