Microsoft Private Public On-Demand

Advanced Microsoft Excel Training (EXC365.3)

1 day
Microsoft ExcelMicrosoft OfficeMicrosoft

Build advanced Excel 365 skills with PivotTables, complex formulas, workbook auditing, data tools, protection, collaboration, and macro automation techniques.

Talk to a Learning ConsultantRegister for a Public ClassRequest a Private Class

Register or Request Training

Price per student
$245.00
Guaranteed to run
Select a date
Please select a class.
Interested in a private class?
  • Private class for your team
  • Live expert instructor
  • Online or on‑location
  • Customizable agenda
  • Proposal responses same day as request
Request Proposal
Price per student
$49.95 or 1 voucher
  • On-Demand 24/7
  • Readings, Video Presentations, Exercises
  • Quizzes to knowledge check
  • Life-Time Access

Course Overview

Take your Excel skills beyond everyday spreadsheet work in this advanced course for experienced users. Learn to analyze data with PivotTables and PivotCharts, create sophisticated formulas and lookups, audit complex workbooks, and use Excel’s data management tools more effectively.

You will also explore data validation, What-If Analysis, importing and consolidating data, workbook protection, collaboration features, and macros for automating repetitive tasks. By the end of the course, you will be prepared to troubleshoot formulas, streamline common processes, and create more reliable workbooks.

Course Benefits

  • Summarize and visualize large data sets with PivotTables, PivotCharts, slicers, and timeline filters.
  • Build advanced formulas using arrays, lookup functions, and functions such as INDEX, XMATCH, XLOOKUP, LET, and FILTER.
  • Audit and troubleshoot workbooks by tracing precedents and dependents, evaluating formulas, and checking for errors.
  • Import, link, convert, validate, and consolidate data from multiple sources.
  • Apply What-If Analysis tools, including Goal Seek, to evaluate possible outcomes.
  • Protect worksheets and workbooks for safer collaboration and sharing.
  • Record, run, edit, and access macros to automate repetitive Excel tasks.

Delivery Methods

Public Class
Live expert-led online training from anywhere. Guaranteed to run .
Private Class
Delivered for your team at your site or online.
On-Demand
Learn at your own pace with 24/7 access.

Microsoft Certified Partner

Webucator is a Microsoft Certified Partner. We design and deliver training that aligns directly with Microsoft's official technologies, standards, and learning objectives.

Microsoft Certified Partner

Course Outline

  1. Using PivotTables
    1. How PivotTables Work
    2. Timeline Filters
    3. Inserting Slicers
    4. Grouping Data
    5. Calculated Fields
    6. PivotCharts
    7. Working with PivotTables (exercise)
  2. Advanced Functions
    1. Function Syntax
    2. ROWS, COLUMNS, INDEX, and XMATCH
    3. Arrays and Array Formulas
    4. Getting Unique Values (exercise)
    5. SORT, FILTER, and SORTBY
    6. Lookup Functions
    7. Using the XLOOKUP Function (exercise)
    8. The LET Function
    9. The TRANSPOSE Function
  3. Auditing Workbooks
    1. Inspecting a Workbook
    2. Tracing Precedents and Dependents
    3. Tracing Precedents and Dependents Practice (exercise)
    4. Watch Window
    5. Evaluating Formulas
    6. Error Checking
  4. Data Tools
    1. Importing Data from online source
    2. Converting Text to Columns
    3. Converting Text to Columns (exercise)
    4. Importing Files
    5. Importing Text Files (exercise)
    6. Linking to External Data
    7. Controlling Calculation Options
    8. Data Validation
    9. Using Data Validation (exercise)
    10. Consolidating Data
    11. Consolidating Data (exercise)
    12. What-If Analysis
    13. Using Goal Seek (exercise)
  5. Working with Others
    1. Comments and Notes
    2. Protecting Worksheets and Workbooks
    3. Password Protecting a Workbook (exercise)
    4. Marking a Workbook as Final
    5. Other Sharing Concerns
  6. Recording and Using Macros
    1. Recording Macros
    2. Recording a Macro (exercise)
    3. Running Macros
    4. Editing Macros
    5. Adding Macros to the Quick Access Toolbar
    6. Adding a Macro to the Quick Access Toolbar (exercise)

Class Materials

Each student receives a comprehensive set of materials, including course notes and all class examples.

Class Prerequisites

Experience in the following is required for this Microsoft Excel class:

  • Basic to intermediate experience using Microsoft Excel.

Prerequisite Courses

Courses that can help you meet these prerequisites:

Have questions about this course?

We can help with curriculum details, delivery options, pricing, or anything else. Reach out and we’ll point you in the right direction.

Talk to a Learning Consultant