Excel Yourself/Advanced Excel 2024 4.5+ hours

Advanced Excel

This is a three-part series of recorded webinars run over three consecutive days in November 2024. Each session is about 90 minutes long. There is a quiz for each session.

The sessions take you through the following topics.

  • Advanced summing techniques

  • Logic formulas

  • INDEX-MATCH combination

  • Text functions

  • INDIRECT function

  • Advanced Pivot Tables

  • Relationships

  • Dynamic Arrays


    Version: Microsoft 365
    Recorded: Nov 2024
    Level: Advanced
    Duration: 4 hours 45 minutes
    Price: AU$50

  • $50

Advanced Excel 2024 4.5+ hours

Learn how to take Excel to the next level.

Discover new functions that make building solutions to common reporting problems much easier.

Contents

Course materials

The session materials

  • a pdf manual which you can print out and make notes in

  • Excel file to work through during the session

  • the completed file are in each Daily section to review if you need to

You need to download the materials and save them on you systems where can easily retrieve them.

The materials apply to all three sessions.

Advanced Excel 2024.pdf
Advanced Excel 2024.xlsx

Day One - Functions

Advanced-2024-Day-1 Recording
Completed File Day 1: - Advanced Excel 2024 20241112.xlsx
Day One - Functions: Quiz

Day Two - Functions and PivotTables

Advanced-2024-Day-2-Recording
Completed File Day 2: Advanced Excel 2024 20241113.xlsx
Day Two - Functions and PivotTables Quiz

Day Three - Dynamic Arrays

Advanced-2024-Day-3-Recording
Completed File Day 3: Advanced Excel 2024 20241114.xlsx
Day Three - Dynamic Arrays: Quiz