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
  • 2.12 MB
Advanced Excel 2024.xlsx
  • 2.15 MB

Day One - Functions

Advanced-2024-Day-1 Recording
  • (1h 29m 27s)
  • 269 MB
Completed File Day 1: - Advanced Excel 2024 20241112.xlsx
  • 2.15 MB
Day One - Functions: Quiz

    Day Two - Functions and PivotTables

    Advanced-2024-Day-2-Recording
    • (1h 29m 55s)
    • 291 MB
    Completed File Day 2: Advanced Excel 2024 20241113.xlsx
    • 2.82 MB
    Day Two - Functions and PivotTables Quiz

      Day Three - Dynamic Arrays

      Advanced-2024-Day-3-Recording
      • (1h 43m 49s)
      • 403 MB
      Completed File Day 3: Advanced Excel 2024 20241114.xlsx
      • 3.5 MB
      Day Three - Dynamic Arrays: Quiz