Short courses to help you master Excel

Welcome, my name is Neale Blackwood. I have been teaching people how to use Excel for over 20 years. 
My short courses will help you:

  • learn techniques that can save you hours of work.

  • keep up to date with Excel's new features.

  • discover how to create reports without writing a single formula. 

  • import data reliably without manual steps. 

  • automate tasks so you only have to click a button. 

  • find out how to create interactive reports and dashboards.

Scroll down to sign up for my newsletter and to see details of the free and fee-based Excel courses.

Free Live Excel Webinars Every Month

Join over 4,000 subscribers and be the first to hear about my monthly FREE live Excel webinars, 
plus learn about other special Excel training offers. 
I won't share your email. (I hate spam too.)

You're signing up to receive emails from Excel Yourself

Some nice recent feedback

It is always nice to receive e-mails like this.

I have wished Peter well in his retirement.

November 2024 Feedback

Financial Functions Part Two

This accounting webinar series is one of the best for practical CPD hours. It focuses on things we actually use in our day-to-day work, like Excel models and useful tips, instead of theory or topics we may never touch depending on your area of expertise.

It’s clear, easy to follow, and you come away with skills you can put into practice right away. Highly recommend it for anyone wanting CPD that’s actually helpful.

10/10
C Walthew
November 2024

Free Excel Webinars Bundle

Immediate access to free Excel webinar recordings

Get the FREE Excel Webinars Bundle at the button below.
The course contains over 25 free Excel webinar recordings.
Over 2,000 people have already enrolled in this amazing course.
Started improving your Excel skills for FREE now.

Recordings of Live Excel Training Sessions

Most courses on this site are recordings of live Excel webinars.

Course videos are usually between 60 and 90 minutes. 

The only video editing is done to the start of the video. 

It is like attending a live training event, except you can pause and rewind.

All courses include

  • a detailed pdf manual
  • a recording of the live event
  • an example file (most have before and after Excel files)
  • a certificate of completion
Some courses include
  • a quiz or quizzes to test your new found knowledge
  • bonus content not in the live event

Course feedback

R Cox May 2025

Introduction to Dynamic Arrays

9/10

Thanks for updating us with new functionality that offers a lot of very useful applications, can't wait to implement most of what was shared today :-) Thanks

S Tan, February 2024

Budget Challenge 2024

Score 10/10

Really enjoy learning with Neale.  Good pace and useful tips along the way. First time I come across the 3D reference which will be very useful!

Bundled Courses

Bundles save you money

Dashboard Bundle 2024

Updated March 2024

Learn the techniques you need to create and maintain dashboards in Excel. Included in the Bundle

  • Chart Tips and Tricks

  • Interactive Chart

  • Dashboard #1 - Guidelines

  • Dashboard #2 - Formula-based dashboard

  • Dashboard #3 - Sparklines and Conditional Formats

  • Dashboard #4 - PivotCharts and Slicers

  • Dashboard #5 - Dynamic Arrays

  • BONUS - Excel Chart Hacks

Level: Intermediate to Advanced
Duration: 8.5+ hours
Price: AU$100

Formulas & Functions Bundle

Discover new functions and how to better use the ones you already know. Included in the Bundle
  • Formula Tips & Tricks
  • Financial Functions Part One & Part Two
  • Text Functions
  • Lookup formulas
  • Logic formulas
  • Summing functions
  • VLOOKUP function
  • SUMPRODUCT function
  • INDIRECT function
  • INDEX and MATCH functions
  • XLOOKUP function
  • Introduction to Dynamic Arrays
Level: Intermediate to Advanced
Duration: 15+ hours
Price: AU$110.00

  • $60

Dynamic Arrays Bundle 2024

  • Bundle
  • 6 Products

Dynamic arrays are a game changer for creating formulas in Excel. This dynamic array series has four courses and two bonuses. Bonus 1: Macro to format a spill range. Bonus 2: Custom Functions and Range Names (1.5 hour) course added. Version: Microsoft 365 Recorded: April 2024 Level: Intermediate Duration: 5.5 hours Price: AU$60

Course Feedback

J Wallis April 2024

Introduction to Dynamic Arrays

Score 10/10

Excel-lent as usual, many thanks! Neale has a great pace and keeps it interesting.

L Bramich January 2024

Format As Table Features

Score 10/10

Great to see the new features I was not aware of thanks so much.

Other Courses

Take Excel to the next level

Pivot Tables

This two-video course assumes no prior use of Pivot Tables. 

Pivot Tables allow you to summarise large data sets with a few mouse clicks with no formulas.

This course starts with the essential skills and progresses toward more advanced uses of Pivot Tables.

The course has 
  • over 2 and a half hours of video
  • a detailed pdf manual 
  • example Excel files (before and after)
  • and quizzes
Level: Intermediate
Duration: 2 hours
Price: AU$25

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

Course Feedback

A Attrill, January 2024

Format As Table Features

Score 10/10

Very easy to follow and easy to listen to. Great to see new tools that are available, thank you!

S Lee, April 2024

Introduction to Dynamic Arrays

Score 10/10

Great session. I use dynamic arrays but still got something out of it.

Y Gibbs, January 2023

Formatted Tables

Score 10/10

Neale never fails to disappoint. I always learn something new. By far, the best Excel trainer I've ever come across.