Silver Excel Bundle 2023 - no Book, Budget or Macros

Excel Yourself/Silver Excel Bundle 2023 - no Book, Budget or Macros

Enrollment is closed

$405 or 3 monthly payments of $135

Silver Excel Bundle 2023 - no Book, Budget or Macros

Closed
Bundle
186 Products

All the Excel courses up to 2023 (except the book, budget and macro courses) in one Mega bundle.

No time limit on completion
Over 60 hours of Excel training videos
All courses include a certificate of completion
All courses include a detailed pdf manual
All courses have example files
Many courses have the completed files
Some courses have quizzes
You also get all the new courses from 2024 (except new budget and macro courses)
Two payment options below

Payment Options

There are two payment options to choose from.

Full Payment

$AU405

Pay the course fee in one payment via credit card.

No credit card fees.

Payment Plan

3 x $AU135 per month

Pay off the course fee with three equal payments over three months.
Credit card required.

No extra fees or credit card fees are involved.

Enrol $AU135 per month

Contents

All the courses below are included. Scroll down to see the variety of topics.
Click on the course names below to see more details.
This bundle saves you hundreds of dollars.

$50

Advanced Excel 2024 4.5+ hours

Learn how to take Excel to the next level. Includes many advanced functions. Advanced PivotTable techniques including how to create relationships between tables. Dynamic arrays are covered in depth. Version: Microsoft 365 Recorded: Nov 2024 Level: Advanced Duration: 4.5+ hours Price: AU$50

$50

Advanced Excel 2024 4.5+ hours

Learn how to take Excel to the next level. Includes many advanced functions. Advanced PivotTable techniques including how to create relationships between tables. Dynamic arrays are covered in depth. Version: Microsoft 365 Recorded: Nov 2024 Level: Advanced Duration: 4.5+ hours Price: AU$50

$49

Advanced Excel Course 4.5+ hours

Learn how to take Excel to the next level. Includes many advanced functions, importing data with Power Query. Advanced PivotTable techniques and how to create relationships between tables. Level: Advanced Duration: 4.5+ hours Price: $49AUD

$49

Advanced Excel Course 4.5+ hours

Learn how to take Excel to the next level. Includes many advanced functions, importing data with Power Query. Advanced PivotTable techniques and how to create relationships between tables. Level: Advanced Duration: 4.5+ hours Price: $49AUD

$80

Advanced Macros

Over 5 hours of video, detailed pdf manuals, example code, bonuses and quizzes. Includes a course on automating macros so they run automatically. Creating re-usable programming functions plus functions that work on a sheet. There are two workshops taking with real world examples. Create a reporting Add-in that runs reports from a right click menu. Level: Advanced Duration: 5+ hours Price: AU$80

$80

Advanced Macros

Over 5 hours of video, detailed pdf manuals, example code, bonuses and quizzes. Includes a course on automating macros so they run automatically. Creating re-usable programming functions plus functions that work on a sheet. There are two workshops taking with real world examples. Create a reporting Add-in that runs reports from a right click menu. Level: Advanced Duration: 5+ hours Price: AU$80

$5

Bonus - Dynamic Arrays - Macro to format spill ranges

Bonus Macro A macro that formats a spill range and runs off a shortcut key. ONLY AVAILABLE WITH THE DYNAMIC ARRAYS BUNDLE!

$5

Bonus - Dynamic Arrays - Macro to format spill ranges

Bonus Macro A macro that formats a spill range and runs off a shortcut key. ONLY AVAILABLE WITH THE DYNAMIC ARRAYS BUNDLE!

$100

Bonus Excel Content

A few extra videos to say thanks for your support.

$100

Bonus Excel Content

A few extra videos to say thanks for your support.

Free

Budget Challenge Solution

This course is based on a budgeting challenge set by an academic. People from around the world entered. In this session I take you through my solution which matched his results. Level: Intermediate to Advanced Duration: 1 hour Price: Free

Free

Budget Challenge Solution

This course is based on a budgeting challenge set by an academic. People from around the world entered. In this session I take you through my solution which matched his results. Level: Intermediate to Advanced Duration: 1 hour Price: Free

Free

Budget Challenge Solution Subscription 2023

This course is based on a budgeting challenge set by an academic. People from around the world entered. In this session I take you through a revision to my original solution which matched his results. This revised solution uses the subscription version of Excel and dynamic arrays - a new way to calculate in Excel. Version: Microsoft 365 Recorded: Feb 2023 Level: Intermediate to Advanced Duration: 1 hour Price: Free

Free

Budget Challenge Solution Subscription 2023

This course is based on a budgeting challenge set by an academic. People from around the world entered. In this session I take you through a revision to my original solution which matched his results. This revised solution uses the subscription version of Excel and dynamic arrays - a new way to calculate in Excel. Version: Microsoft 365 Recorded: Feb 2023 Level: Intermediate to Advanced Duration: 1 hour Price: Free

Free

Budget Challenge Solution - Subscription Version

This course is based on a budgeting challenge set by an academic. People from around the world entered. In this session I take you through a revision to my original solution which matched his results. This revised solution uses the subscription version of Excel and dynamic arrays - a new way to calculate in Excel. Level: Intermediate to Advanced Duration: 1 hour Price: Free

Free

Budget Challenge Solution - Subscription Version

This course is based on a budgeting challenge set by an academic. People from around the world entered. In this session I take you through a revision to my original solution which matched his results. This revised solution uses the subscription version of Excel and dynamic arrays - a new way to calculate in Excel. Level: Intermediate to Advanced Duration: 1 hour Price: Free

$25

Create an Excel Index Sheet

An Index or a Contents sheet is required for Excel files that have multiple tabs. The techniques covered in this session can also be applied to Instruction sheets and other sheets to improve the general navigation around your Excel files. Version: All Versions Recorded: Aug 2020 Level: Advanced Duration: 1 hour Price: AU$25

$25

Create an Excel Index Sheet

An Index or a Contents sheet is required for Excel files that have multiple tabs. The techniques covered in this session can also be applied to Instruction sheets and other sheets to improve the general navigation around your Excel files. Version: All Versions Recorded: Aug 2020 Level: Advanced Duration: 1 hour Price: AU$25

$25

Custom Functions and Range Names (1.5 hrs)

Learn how to create your own functions in Excel without using macros or VBA. This session requires the subscription version of Excel. Functions created include SheetName, IFBLANK, SUMCOL, SUMROW and SUMDA. These SUM functions work with two-dimensional spill ranges. Version: Microsoft 365 Recorded: August 2022 Level: Advanced Duration: 1.5 hours Price: AU$25

$25

Custom Functions and Range Names (1.5 hrs)

Learn how to create your own functions in Excel without using macros or VBA. This session requires the subscription version of Excel. Functions created include SheetName, IFBLANK, SUMCOL, SUMROW and SUMDA. These SUM functions work with two-dimensional spill ranges. Version: Microsoft 365 Recorded: August 2022 Level: Advanced Duration: 1.5 hours Price: AU$25

$25

Dynamic Arrays Advanced Functions

Dynamic arrays are a game changer for creating formulas in Excel. This session introduces the advanced level functions and formula techniques you need to make the most of dynamic arrays. Includes creating your own custom functions. Version: Microsoft 365 Recorded: April 2024 Level: Advanced Duration: 1 hour Price: AU$25

$25

Dynamic Arrays Advanced Functions

Dynamic arrays are a game changer for creating formulas in Excel. This session introduces the advanced level functions and formula techniques you need to make the most of dynamic arrays. Includes creating your own custom functions. Version: Microsoft 365 Recorded: April 2024 Level: Advanced Duration: 1 hour Price: AU$25

$25

Dynamic Arrays Basic Functions

Dynamic arrays are a game changer for creating formulas in Excel. Functions covered SEQUENCE, UNIQUE, CHOOSECOLS, CHOOSEROWS, TAKE, DROP, FILTER and SORTBY. This session introduces the basic functions and techniques you need to make the most of dynamic arrays. Examples include a loan schedule and a simple budget. Version: Microsoft 365 Recorded: April 2024 Level: Intermediate Duration: 1 hour Price: AU$25

$25

Dynamic Arrays Basic Functions

Dynamic arrays are a game changer for creating formulas in Excel. Functions covered SEQUENCE, UNIQUE, CHOOSECOLS, CHOOSEROWS, TAKE, DROP, FILTER and SORTBY. This session introduces the basic functions and techniques you need to make the most of dynamic arrays. Examples include a loan schedule and a simple budget. Version: Microsoft 365 Recorded: April 2024 Level: Intermediate Duration: 1 hour Price: AU$25

$25

Dynamic Arrays Intermediate Functions

Dynamic arrays are a game changer for creating formulas in Excel. This session introduces the intermediate level functions and techniques you need to make the most of dynamic arrays. Version: Microsoft 365 Recorded: April 2024 Level: Intermediate Duration: 1 hour Price: AU$25

$25

Dynamic Arrays Intermediate Functions

Dynamic arrays are a game changer for creating formulas in Excel. This session introduces the intermediate level functions and techniques you need to make the most of dynamic arrays. Version: Microsoft 365 Recorded: April 2024 Level: Intermediate Duration: 1 hour Price: AU$25

Free

Dynamic Arrays Introduction

Dynamic arrays are a game changer for creating formulas in Excel. This session introduces important concepts plus new symbols and functions to get you started using dynamic arrays. Version: Microsoft 365 Recorded: April 2024 Level: Intermediate Duration: 1 hour Price: Free

Free

Dynamic Arrays Introduction

Dynamic arrays are a game changer for creating formulas in Excel. This session introduces important concepts plus new symbols and functions to get you started using dynamic arrays. Version: Microsoft 365 Recorded: April 2024 Level: Intermediate Duration: 1 hour Price: Free

Free

Excel Ask Me Anything July 2022

As a follow up to my 400th public webinar I ran another Excel Ask Me Anything session. Thanks to all who submitted questions. Topics include. • Power Query and exceptions • Pivot table headings and formats • Allocations • Paste annoyances • Icon annoyance • Finding the last date for a code Version: All Versions Recorded: Jul 2022 Level: Mixed - Beginner to Advanced Duration: 1.25 hours Price: Free

Free

Excel Ask Me Anything July 2022

As a follow up to my 400th public webinar I ran another Excel Ask Me Anything session. Thanks to all who submitted questions. Topics include. • Power Query and exceptions • Pivot table headings and formats • Allocations • Paste annoyances • Icon annoyance • Finding the last date for a code Version: All Versions Recorded: Jul 2022 Level: Mixed - Beginner to Advanced Duration: 1.25 hours Price: Free

Free

Excel Ask Me Anything June 2022 (1.25 hours)

To celebrate my 400th public webinar I ran an Excel Ask Me Anything session. Thanks to all who submitted questions. Topics include. • Charts • Pivot tables • Formatted tables • Unlocking cells • Financial models • Time calculations • The zodiac – well sort of Version: All Versions Recorded: Jun 2022 Level: Beginner to Advanced Duration: 1.25 hours Price: Free

Free

Excel Ask Me Anything June 2022 (1.25 hours)

To celebrate my 400th public webinar I ran an Excel Ask Me Anything session. Thanks to all who submitted questions. Topics include. • Charts • Pivot tables • Formatted tables • Unlocking cells • Financial models • Time calculations • The zodiac – well sort of Version: All Versions Recorded: Jun 2022 Level: Beginner to Advanced Duration: 1.25 hours Price: Free

$25

Excel Chart Hacks

Learn how to create non-standard charts in Excel. Includes using text boxes, high/low charts, variance charts, conditional colours, Waterfall charts, banding and expanding ranges. Version: All versions Recorded: April 2020 Level: Intermediate Duration: 1 hour Price: AU$25

$25

Excel Chart Hacks

Learn how to create non-standard charts in Excel. Includes using text boxes, high/low charts, variance charts, conditional colours, Waterfall charts, banding and expanding ranges. Version: All versions Recorded: April 2020 Level: Intermediate Duration: 1 hour Price: AU$25

Free

Excel Chart Tips and Tricks

Discover quick and easy ways to edit charts.

Free

Excel Chart Tips and Tricks

Discover quick and easy ways to edit charts.

Free

Excel Chart Tips and Tricks 2021

Discover quick and easy ways to edit charts. Version: All Versions Recorded: Nov 2021 Level: Intermediate Duration: 1 hour Price: Free

Free

Excel Chart Tips and Tricks 2021

Discover quick and easy ways to edit charts. Version: All Versions Recorded: Nov 2021 Level: Intermediate Duration: 1 hour Price: Free

$25

Excel Checkbox Bonanza

See how to make the most of checkboxes in your spreadsheet. This user interface feature makes it easy to turn calculations off and on. Version: All versions Recorded: Feb 2021 Level: Intermediate Duration: 1 hour Price: AU$25

$25

Excel Checkbox Bonanza

See how to make the most of checkboxes in your spreadsheet. This user interface feature makes it easy to turn calculations off and on. Version: All versions Recorded: Feb 2021 Level: Intermediate Duration: 1 hour Price: AU$25

Free

Excel Conditional Formats

Automate your formats and learn how to control conditional formats. Level: Intermediate Duration: 1 hour Price: Free

Free

Excel Conditional Formats

Automate your formats and learn how to control conditional formats. Level: Intermediate Duration: 1 hour Price: Free

Free

Excel Copy and Paste Techniques

Learn the basics plus some advanced techniques. Level: Beginner Duration: 1 hour Price: Free

Free

Excel Copy and Paste Techniques

Learn the basics plus some advanced techniques. Level: Beginner Duration: 1 hour Price: Free

Free

Excel Copy and Paste Techniques 2024

Learn the basics of pasting plus some advanced techniques. Version: All versions Recorded: Dec 2024 Level: Beginner Duration: 1 hour 15 min Price: Free

Free

Excel Copy and Paste Techniques 2024

Learn the basics of pasting plus some advanced techniques. Version: All versions Recorded: Dec 2024 Level: Beginner Duration: 1 hour 15 min Price: Free

$25

Excel COUNTIFS Function

The COUNTIFS function has been around for many versions. COUNTIFS offers the ability to perform single or multiple criteria counting. This session explores the way you can use it to solve real world problems. Version: All versions Recorded: Aug 2021 Level: Intermediate Duration: 1 hour Price: AU$25

$25

Excel COUNTIFS Function

The COUNTIFS function has been around for many versions. COUNTIFS offers the ability to perform single or multiple criteria counting. This session explores the way you can use it to solve real world problems. Version: All versions Recorded: Aug 2021 Level: Intermediate Duration: 1 hour Price: AU$25

Free

Excel Custom Number Formats

Learn a few formatting tricks to help you display numbers exactly as you want. Level: Intermediate Duration: 1 hour Price: Free

Free

Excel Custom Number Formats

Learn a few formatting tricks to help you display numbers exactly as you want. Level: Intermediate Duration: 1 hour Price: Free

Free

Excel Dashboards #1 - Guidelines

Lots of ideas to improve your charts and dashboards.

Free

Excel Dashboards #1 - Guidelines

Lots of ideas to improve your charts and dashboards.

Free

Excel Dashboards #1 - Guidelines - 2024

Lots of ideas to improve your charts and dashboards. Version: All Versions Recorded: March 2024 Level: Intermediate Duration: 1 hour Price: Free

Free

Excel Dashboards #1 - Guidelines - 2024

Lots of ideas to improve your charts and dashboards. Version: All Versions Recorded: March 2024 Level: Intermediate Duration: 1 hour Price: Free

$25

Excel Dashboards #2 - Formula-based 2024

Discover how to use classic Excel formulas to create charts for your dashboard. Version: All versions Recorded: March 2024 Level: Intermediate Duration: 1 hour Price: AU$25

$25

Excel Dashboards #2 - Formula-based 2024

Discover how to use classic Excel formulas to create charts for your dashboard. Version: All versions Recorded: March 2024 Level: Intermediate Duration: 1 hour Price: AU$25

$25

Excel Dashboards #2 - Formula based dashboard

Discover how to use classic Excel formulas to create charts for your dashboard. Lots of different techniques covered. Version: All versions Recorded: April 2020 Level: Intermediate Duration: 1 hour Price: AU$25

$25

Excel Dashboards #2 - Formula based dashboard

Discover how to use classic Excel formulas to create charts for your dashboard. Lots of different techniques covered. Version: All versions Recorded: April 2020 Level: Intermediate Duration: 1 hour Price: AU$25

$25

Excel Dashboards #3 - Sparklines and Conditional Formats

Discover how effective Sparkline charts are for dashboards. See how to add icons to your dashboard. Version: All Versions Recorded: Apr 2020 Level: Intermediate Duration: 1 hour Price: AU$25

$25

Excel Dashboards #3 - Sparklines and Conditional Formats

Discover how effective Sparkline charts are for dashboards. See how to add icons to your dashboard. Version: All Versions Recorded: Apr 2020 Level: Intermediate Duration: 1 hour Price: AU$25

$25

Excel Dashboards #3 - Sparklines & Conditional Formats 2024

Discover how effective Sparkline charts are for dashboards. See how to add icons to your dashboard. This sessions has been updated to use dynamic arrays. Version: Microsoft 365 Recorded: March 2024 Level: Intermediate Duration: 1 hour Price: AU$25

$25

Excel Dashboards #3 - Sparklines & Conditional Formats 2024

Discover how effective Sparkline charts are for dashboards. See how to add icons to your dashboard. This sessions has been updated to use dynamic arrays. Version: Microsoft 365 Recorded: March 2024 Level: Intermediate Duration: 1 hour Price: AU$25

$25

Excel Dashboards #4 - PivotCharts and Slicers 2024

See how easy it add interaction to your dashboards by using Slicers to enable live filtering. Versions: All versions Recorded: March 2024 Level: Intermediate Duration: 1 hour Price: AU$25

$25

Excel Dashboards #4 - PivotCharts and Slicers 2024

See how easy it add interaction to your dashboards by using Slicers to enable live filtering. Versions: All versions Recorded: March 2024 Level: Intermediate Duration: 1 hour Price: AU$25

$25

Excel Dashboards #4 - PivotCharts & Slicers

See how easy it add interaction to your dashboards by using Slicers to enable live filtering. Version: All versions Recorded: Apr 2020 Level: Intermediate Duration: 1 hour Price: AU$25

$25

Excel Dashboards #4 - PivotCharts & Slicers

See how easy it add interaction to your dashboards by using Slicers to enable live filtering. Version: All versions Recorded: Apr 2020 Level: Intermediate Duration: 1 hour Price: AU$25

$25

Excel Dashboards #5 - Dynamic Arrays (1.5 hours)

This is the fifth in the dashboard series & focuses on creating a dashboard using dynamic arrays. This session requires the subscription version of Excel. See how to use Excel's new dynamic array calculation feature to automate dashboards. Includes new functions plus a technique to return detail & a total in a single formula. Version: Microsoft 365 Recorded: Mar 2023 Level: Advanced Duration: 1.5 hours Price: AU$25

$25

Excel Dashboards #5 - Dynamic Arrays (1.5 hours)

This is the fifth in the dashboard series & focuses on creating a dashboard using dynamic arrays. This session requires the subscription version of Excel. See how to use Excel's new dynamic array calculation feature to automate dashboards. Includes new functions plus a technique to return detail & a total in a single formula. Version: Microsoft 365 Recorded: Mar 2023 Level: Advanced Duration: 1.5 hours Price: AU$25

$25

Excel Dashboards #5 - Dynamic Arrays 2024 (1.5hrs)

This is the fifth in the dashboard series and focuses on creating a dashboard using dynamic arrays. Subscription version required. See how to use Excel's new dynamic array calculation feature to automate dashboards. Includes new functions plus a technique to return detail and a total in a single formula. Version: Microsoft 365 Recorded: March 2024 Level: Advanced Duration: 1.5 hours Price: AU$25

$25

Excel Dashboards #5 - Dynamic Arrays 2024 (1.5hrs)

This is the fifth in the dashboard series and focuses on creating a dashboard using dynamic arrays. Subscription version required. See how to use Excel's new dynamic array calculation feature to automate dashboards. Includes new functions plus a technique to return detail and a total in a single formula. Version: Microsoft 365 Recorded: March 2024 Level: Advanced Duration: 1.5 hours Price: AU$25

Free

Excel Data Handling Tips

This session focuses on using Excel's built-in data handling features like Format as Table, filtering, sorting and advanced filters. I will share tips, tricks and some traps when using the above features. Level: Intermediate Duration: 1 hour Price: Free

Free

Excel Data Handling Tips

This session focuses on using Excel's built-in data handling features like Format as Table, filtering, sorting and advanced filters. I will share tips, tricks and some traps when using the above features. Level: Intermediate Duration: 1 hour Price: Free

Free

Excel Date and Time Calculations

Learn the tricks to perform calculation with dates and time. Level: Intermediate Duration: 1 hour Price: Free

Free

Excel Date and Time Calculations

Learn the tricks to perform calculation with dates and time. Level: Intermediate Duration: 1 hour Price: Free

Free

Excel Financial Functions Part One and Two (2 hours)

Learn how to use Excel's specialised financial functions. Level: Intermediate Duration: 2 hours Price: Free

Free

Excel Financial Functions Part One and Two (2 hours)

Learn how to use Excel's specialised financial functions. Level: Intermediate Duration: 2 hours Price: Free

Free

Excel Format as Table Feature

Make the most of tables in Excel by using Format As Table. Level: Intermediate Duration: 1 hour Price: Free

Free

Excel Format as Table Feature

Make the most of tables in Excel by using Format As Table. Level: Intermediate Duration: 1 hour Price: Free

Free

Excel Formatting Tips and Tricks

Lots of ideas and shortcuts to help improve your spreadsheet formatting. Level: Beginner Duration: 1 hour Price: Free

Free

Excel Formatting Tips and Tricks

Lots of ideas and shortcuts to help improve your spreadsheet formatting. Level: Beginner Duration: 1 hour Price: Free

Free

Excel Formula and Function Tips and Tricks

Discover quick ways to create and edit formulas and functions.

Free

Excel Formula and Function Tips and Tricks

Discover quick ways to create and edit formulas and functions.

$25

Excel Gantt Chart Workshop (1.75hrs)

Learn how to combine many of Excel's features to create flexible date based reports. Version: All Versions Recorded: Apr 2020 Level: Advanced Duration: 1.75 hours Price: AU$25

$25

Excel Gantt Chart Workshop (1.75hrs)

Learn how to combine many of Excel's features to create flexible date based reports. Version: All Versions Recorded: Apr 2020 Level: Advanced Duration: 1.75 hours Price: AU$25

Free

Excel Guidelines

Suggestions and recommendations to improve your Excel files. Level: Intermediate Duration: 1 hour Price: Free

Free

Excel Guidelines

Suggestions and recommendations to improve your Excel files. Level: Intermediate Duration: 1 hour Price: Free

Free

Excel Guidelines 2023

Suggestions and recommendations to improve your Excel files. These guidelines will help you use and create spreadsheets that. - are more reliable - identify errors - are easier to use and understand - have more flexible formulas (can be copied to more places) - are more structured - are easy to navigate Version: All Versions Recorded: Sep 2023 Level: Intermediate Duration: 1 hour Price: Free

Free

Excel Guidelines 2023

Suggestions and recommendations to improve your Excel files. These guidelines will help you use and create spreadsheets that. - are more reliable - identify errors - are easier to use and understand - have more flexible formulas (can be copied to more places) - are more structured - are easy to navigate Version: All Versions Recorded: Sep 2023 Level: Intermediate Duration: 1 hour Price: Free

Free

Excel Keyboard Shortcuts

Speed up your Excel work with better keyboard shortcuts. Level: Beginner Duration: 1 hour Price: Free

Free

Excel Keyboard Shortcuts

Speed up your Excel work with better keyboard shortcuts. Level: Beginner Duration: 1 hour Price: Free

Free

Excel Level One - Beginners - 2024 - 4.5 hrs

The best place to start. Learn the Excel basics plus lots of techniques and shortcuts to speed up your work. Version: All versions Level: Beginner Recorded: Aug 2024 Duration: 4 hours 30 min Price: Free

Free

Excel Level One - Beginners - 2024 - 4.5 hrs

The best place to start. Learn the Excel basics plus lots of techniques and shortcuts to speed up your work. Version: All versions Level: Beginner Recorded: Aug 2024 Duration: 4 hours 30 min Price: Free

Free

Excel Level One - Beginners - 4+ hours

The best place to start. Learn the Excel basics plus lots of shortcuts to speed up your work. Over 700 people have enrolled. Includes bonus videos not included in the live event. Level: Beginner Duration: 4 hours Price: Free

Free

Excel Level One - Beginners - 4+ hours

The best place to start. Learn the Excel basics plus lots of shortcuts to speed up your work. Over 700 people have enrolled. Includes bonus videos not included in the live event. Level: Beginner Duration: 4 hours Price: Free

$25

Excel Level Two - Intermediate - 2024 - 4hrs 30min

Learn how to work better with data, functions, formats and charts. Combine formatted tables and pivot tables to create reports without a single formula. Have you formats automatically update based on cell values. Use charts to visualise the numbers. Learn the secrets of the SUM function plus see how to use XLOOKUP, SUMIFS and IF. Recorded: Sep 2024 Level: Intermediate Duration: 4 hours 30 min Price: AU$25

$25

Excel Level Two - Intermediate - 2024 - 4hrs 30min

Learn how to work better with data, functions, formats and charts. Combine formatted tables and pivot tables to create reports without a single formula. Have you formats automatically update based on cell values. Use charts to visualise the numbers. Learn the secrets of the SUM function plus see how to use XLOOKUP, SUMIFS and IF. Recorded: Sep 2024 Level: Intermediate Duration: 4 hours 30 min Price: AU$25

$25

Excel Level Two - Intermediate - 4.5+ hours

Learn how to work better with data, functions, formats and charts. Include bonus content not in the live event. Level: Intermediate Duration: 4.5+ hours Recorded: May 2020 Price: AU$25

$25

Excel Level Two - Intermediate - 4.5+ hours

Learn how to work better with data, functions, formats and charts. Include bonus content not in the live event. Level: Intermediate Duration: 4.5+ hours Recorded: May 2020 Price: AU$25

$25

Excel Loan Schedules

This session examines 5 + 2 different loan schedules. 1. Standard Loan Schedule – standard formulas. 2. Standard Loan Schedule – dynamic array formulas. 3. Loan Drawdown Schedule. 4. Interest Only Period Loan Schedule. 5. Extra Repayments Loan Schedule. 6. *Custom Function 7. *Interest Only Version: All versions + Microsoft 365 Recorded: Jun 2024 Level: Intermediate to Advanced Duration: 1 hour Price: AU$25

$25

Excel Loan Schedules

This session examines 5 + 2 different loan schedules. 1. Standard Loan Schedule – standard formulas. 2. Standard Loan Schedule – dynamic array formulas. 3. Loan Drawdown Schedule. 4. Interest Only Period Loan Schedule. 5. Extra Repayments Loan Schedule. 6. *Custom Function 7. *Interest Only Version: All versions + Microsoft 365 Recorded: Jun 2024 Level: Intermediate to Advanced Duration: 1 hour Price: AU$25

$25

Excel Logic Formulas (1.25hrs)

Its not just the IF function - find out how to make the most of logic in Excel. See how you can use TRUE and FALSE in formulas. Version: Old (pre-Dynamic arrays) Level: Intermediate Recorded: March 2020 Duration: 1.25 hours Price: AU$25

$25

Excel Logic Formulas (1.25hrs)

Its not just the IF function - find out how to make the most of logic in Excel. See how you can use TRUE and FALSE in formulas. Version: Old (pre-Dynamic arrays) Level: Intermediate Recorded: March 2020 Duration: 1.25 hours Price: AU$25

$25

Excel Lookup Formulas

See various ways to lookup demonstrated and explained. From VLOOKUP and HLOOKUP to INDEX and MATCH. Level: Intermediate Duration: 1 hour Recorded: Mar 2020 Price: AU$25

$25

Excel Lookup Formulas

See various ways to lookup demonstrated and explained. From VLOOKUP and HLOOKUP to INDEX and MATCH. Level: Intermediate Duration: 1 hour Recorded: Mar 2020 Price: AU$25

Free

Excel Mouse Shortcuts

Speed up your Excel work with better mouse skills. Level: Beginner Duration: 1 hour Price: Free

Free

Excel Mouse Shortcuts

Speed up your Excel work with better mouse skills. Level: Beginner Duration: 1 hour Price: Free

$25

Excel Option Button Blitz

Learn how to use option buttons (aka radio buttons) to improve the Excel User interface. Version: All Versions Recorded: Jun 2021 Level: Intermediate Duration: 1 hour Price: AU$25

$25

Excel Option Button Blitz

Learn how to use option buttons (aka radio buttons) to improve the Excel User interface. Version: All Versions Recorded: Jun 2021 Level: Intermediate Duration: 1 hour Price: AU$25

$39

Excel Power Query Series

Discover how you can import single or multiple files and also consolidate a budget with Power Query.

$39

Excel Power Query Series

Discover how you can import single or multiple files and also consolidate a budget with Power Query.

$25

Excel Project - Index Sheet 2022

An Index or a Contents sheet is required for Excel files that have multiple tabs. The techniques covered in this session can also be applied to Instruction sheets and other sheets to improve the general navigation around your Excel files. Version: Microsoft 365 Recorded: Nov 2022 Level: Advanced Duration: 1 hour Price: AU$25

$25

Excel Project - Index Sheet 2022

An Index or a Contents sheet is required for Excel files that have multiple tabs. The techniques covered in this session can also be applied to Instruction sheets and other sheets to improve the general navigation around your Excel files. Version: Microsoft 365 Recorded: Nov 2022 Level: Advanced Duration: 1 hour Price: AU$25

Free

Excel Questions & Answers April 2020 (1.5 hours)

Functions, formulas, formats and lots of other topics are covered in this wide ranging session. Version: All Versions Recorded: Apr 2020 Level: Intermediate Duration: 1.5 hours Price: Free

Free

Excel Questions & Answers April 2020 (1.5 hours)

Functions, formulas, formats and lots of other topics are covered in this wide ranging session. Version: All Versions Recorded: Apr 2020 Level: Intermediate Duration: 1.5 hours Price: Free

Free

Excel Text Functions

Everyone knows how well Excel handles numbers, but not everyone knows that Excel can work well with text as well. This session demonstrates frequently used techniques to manipulate text and get the output you require. Level: Intermediate Duration: 1 hour Price: Free

Free

Excel Text Functions

Everyone knows how well Excel handles numbers, but not everyone knows that Excel can work well with text as well. This session demonstrates frequently used techniques to manipulate text and get the output you require. Level: Intermediate Duration: 1 hour Price: Free

Free

Excel Text Functions 2023

Everyone knows how well Excel handles numbers, but not everyone knows that Excel can work well with text as well. This session demonstrates frequently used techniques to manipulate text and get the output you require. The session includes old and new text functions and features. Version: Microsoft 365 Recorded: Oct 2023 Level: Intermediate Duration: 1 hour Price: Free

Free

Excel Text Functions 2023

Everyone knows how well Excel handles numbers, but not everyone knows that Excel can work well with text as well. This session demonstrates frequently used techniques to manipulate text and get the output you require. The session includes old and new text functions and features. Version: Microsoft 365 Recorded: Oct 2023 Level: Intermediate Duration: 1 hour Price: Free

$25

Excel VLOOKUP Function (1.5 hours)

One of the most popular functions in Excel. See how to avoid many of the issues and handle the various errors that can happen. Versions: All versions Recorded: March 2020 Level: Intermediate Duration: 1.5 hours Price: AU$25

$25

Excel VLOOKUP Function (1.5 hours)

One of the most popular functions in Excel. See how to avoid many of the issues and handle the various errors that can happen. Versions: All versions Recorded: March 2020 Level: Intermediate Duration: 1.5 hours Price: AU$25

Free

Excel What If Techniques

Use Excel's built-in features to help solve complex problems. Level: Intermediate Duration: 1 hour Price: Free

Free

Excel What If Techniques

Use Excel's built-in features to help solve complex problems. Level: Intermediate Duration: 1 hour Price: Free

$25

Excel XLOOKUP Function (1.5 hours)

A brand new function that replaces VLOOKUP, HLOOKUP and INDEX-MATCH formulas. It has some special features. See how to apply them in the 1.5 hour session. Version: All Versions Recorded: Mar 2021 Level: Intermediate Duration: 1.5 hours Price: AU$25

$25

Excel XLOOKUP Function (1.5 hours)

A brand new function that replaces VLOOKUP, HLOOKUP and INDEX-MATCH formulas. It has some special features. See how to apply them in the 1.5 hour session. Version: All Versions Recorded: Mar 2021 Level: Intermediate Duration: 1.5 hours Price: AU$25

Free

Excel Yourself Webinar Series (13 hours)

See my magazine articles come to life with extra and updated content. From 2012 to 2022 - each module is a smorgasbord of Excel topics and skill levels. Lots of tips, tricks and traps explained in each module. Recorded: 2022 and earlier Level: Beginner to Advanced Duration: 13 hours Price: Free

Free

Excel Yourself Webinar Series (13 hours)

See my magazine articles come to life with extra and updated content. From 2012 to 2022 - each module is a smorgasbord of Excel topics and skill levels. Lots of tips, tricks and traps explained in each module. Recorded: 2022 and earlier Level: Beginner to Advanced Duration: 13 hours Price: Free

Free

Financial Functions 2022 Parts 1 and 2 (2+ hours)

Learn how to use Excel's specialised financial functions. Includes a bonus 15 minute video on goal seek and macros. Version: Microsoft 365 Recorded: May 2022 Level: Intermediate Duration: 2+ hours Price: Free

Free

Financial Functions 2022 Parts 1 and 2 (2+ hours)

Learn how to use Excel's specialised financial functions. Includes a bonus 15 minute video on goal seek and macros. Version: Microsoft 365 Recorded: May 2022 Level: Intermediate Duration: 2+ hours Price: Free

Free

Financial Functions Part 1 (2024)

Includes 1 additional product

Most of these functions involve loans or calculations associated with the time value of money. They take three or more arguments (parts of a function), but there are a few things you need to know to use them correctly. This session covered the following six functions PV, PMT,CUMIPMT,RATE, FV, NPER, IFERROR Version: Microsoft 365 Recorded: Oct 2024 Level: Intermediate to Advanced Duration: 1 hour Price: Free

Includes 1 additional product

Financial Functions Part 2 (2024)

Free

Financial Functions Part 1 (2024)

Includes 1 additional product

Most of these functions involve loans or calculations associated with the time value of money. They take three or more arguments (parts of a function), but there are a few things you need to know to use them correctly. This session covered the following six functions PV, PMT,CUMIPMT,RATE, FV, NPER, IFERROR Version: Microsoft 365 Recorded: Oct 2024 Level: Intermediate to Advanced Duration: 1 hour Price: Free

Includes 1 additional product

Financial Functions Part 2 (2024)

Free

Financial Functions Part 2 (2024)

Includes 1 additional product

Most of these functions involve the time value of money. There are a few things you need to know to use them correctly. This session covered the following functions NPV, PV, XNPV, IRR and XIRR. Version: All versions Recorded: Nov 2024 Level: Intermediate to Advanced Duration: 1 hour Price: Free

Includes 1 additional product

Financial Functions Part 1 (2024)

Free

Financial Functions Part 2 (2024)

Includes 1 additional product

Most of these functions involve the time value of money. There are a few things you need to know to use them correctly. This session covered the following functions NPV, PV, XNPV, IRR and XIRR. Version: All versions Recorded: Nov 2024 Level: Intermediate to Advanced Duration: 1 hour Price: Free

Includes 1 additional product

Financial Functions Part 1 (2024)

Free

Format as Table Feature 2024

Learn how make the most of tables in Excel by using Format As Table. This is an important data handing skill to master. Version: All Versions Recorded: Jan 2024 Level: Intermediate Duration: 1 hour Price: Free

Free

Format as Table Feature 2024

Learn how make the most of tables in Excel by using Format As Table. This is an important data handing skill to master. Version: All Versions Recorded: Jan 2024 Level: Intermediate Duration: 1 hour Price: Free

Free

Formula & Function Tips 2022

Discover quick ways to create and edit formulas and functions. Version: All Versions Recorded: Jan 2022 Level: Beginner Duration: 1 hour Price: Free

Free

Formula & Function Tips 2022

Discover quick ways to create and edit formulas and functions. Version: All Versions Recorded: Jan 2022 Level: Beginner Duration: 1 hour Price: Free

Free

Formula & Function Tips 2024

Discover quick ways to create and edit formulas and functions. Includes many different techniques and shortcuts to speed up formula creation. Version: All Versions Recorded: July 2024 Level: Beginner Duration: 1 hour Price: Free

Free

Formula & Function Tips 2024

Discover quick ways to create and edit formulas and functions. Includes many different techniques and shortcuts to speed up formula creation. Version: All Versions Recorded: July 2024 Level: Beginner Duration: 1 hour Price: Free

$25

INDEX and MATCH Solutions (1.5 hrs)

The INDEX-MATCH combination is an advanced technique that can solve many look up problems. The two functions are useful in their own right, but together they provide a range of solutions to common look up requirements. INDEX and MATCH with Dynamic Arrays explained. Version: All versions for most content (Dynamic Arrays require Microsoft 365) Recorded: Aug 2022 Level: Advanced Duration: 1.5 hours Price: AU$25

$25

INDEX and MATCH Solutions (1.5 hrs)

The INDEX-MATCH combination is an advanced technique that can solve many look up problems. The two functions are useful in their own right, but together they provide a range of solutions to common look up requirements. INDEX and MATCH with Dynamic Arrays explained. Version: All versions for most content (Dynamic Arrays require Microsoft 365) Recorded: Aug 2022 Level: Advanced Duration: 1.5 hours Price: AU$25

$25

INDIRECT Function

The function of last resort - it can perform calculations no other function can match. See how to solve common problems using the INDIRECT function. Version: All versions Recorded: March 2020 Level: Intermediate Duration: 1 hour Price: AU$25

$25

INDIRECT Function

The function of last resort - it can perform calculations no other function can match. See how to solve common problems using the INDIRECT function. Version: All versions Recorded: March 2020 Level: Intermediate Duration: 1 hour Price: AU$25

Free

Interactive Excel Chart

Learn how to build in interaction to your charts. Level: Intermediate Duration: 1 hour Price: Free

Free

Interactive Excel Chart

Learn how to build in interaction to your charts. Level: Intermediate Duration: 1 hour Price: Free

Free

Interactive Excel Chart 2022

Learn how to build in interaction to your charts. Includes worksheet controls - combo boxes and a scroll bar. Version: All Versions Recorded: Aug 2022 Level: Intermediate Duration: 1 hour Price: Free

Free

Interactive Excel Chart 2022

Learn how to build in interaction to your charts. Includes worksheet controls - combo boxes and a scroll bar. Version: All Versions Recorded: Aug 2022 Level: Intermediate Duration: 1 hour Price: Free

Free

Introduction to Dynamic Arrays

Level: Intermediate Duration: 1 hour Price: Free

Free

Introduction to Dynamic Arrays

Level: Intermediate Duration: 1 hour Price: Free

Free

Introduction to Power BI (1.5 hours)

Get started with this incredible reporting App. Level: Intermediate Duration: 1.5 hours Price: Free

Free

Introduction to Power BI (1.5 hours)

Get started with this incredible reporting App. Level: Intermediate Duration: 1.5 hours Price: Free

Free

Introduction To Power Pivot

Pivot Tables on steroids - in a good way. Level: Intermediate Duration: 1 hour Price: Free

Free

Introduction To Power Pivot

Pivot Tables on steroids - in a good way. Level: Intermediate Duration: 1 hour Price: Free

Free

Introduction to Power Pivot 2022

Pivot Tables on steroids - in a good way. See how to report on multiple tables in one report. Includes an introduction to DAX functions. Version: All Versions Recorded: Aug 2022 Level: Intermediate Duration: 1.5 hours Price: Free

Free

Introduction to Power Pivot 2022

Pivot Tables on steroids - in a good way. See how to report on multiple tables in one report. Includes an introduction to DAX functions. Version: All Versions Recorded: Aug 2022 Level: Intermediate Duration: 1.5 hours Price: Free

Free

Introduction to Power Query - 2021

Learn how to automate the data importation process in Excel. Version: All Versions Recorded: May 2021 Level: Intermediate Duration: 1 hour Price: Free

Free

Introduction to Power Query - 2021

Learn how to automate the data importation process in Excel. Version: All Versions Recorded: May 2021 Level: Intermediate Duration: 1 hour Price: Free

Free

Introduction to Power Query in Excel

Learn how to automate the data importation process in Excel.

Free

Introduction to Power Query in Excel

Learn how to automate the data importation process in Excel.

Free

Macros 1 - Recording tips,tricks and traps

Learn how to reduce keystrokes, automate tasks and speed up your work. Level: Intermediate Duration: 1 hour Price: Free

Free

Macros 1 - Recording tips,tricks and traps

Learn how to reduce keystrokes, automate tasks and speed up your work. Level: Intermediate Duration: 1 hour Price: Free

Free

Macros 1 - Recording Tips, Tricks & Traps 2024

Learn how to reduce keystrokes, automate tasks and speed up your work. Plus get some bonus macros. Get started with recorded macros. Version: All versions Recorded: May 2024 Level: Intermediate Duration: 1 hour Price: Free

Free

Macros 1 - Recording Tips, Tricks & Traps 2024

Learn how to reduce keystrokes, automate tasks and speed up your work. Plus get some bonus macros. Get started with recorded macros. Version: All versions Recorded: May 2024 Level: Intermediate Duration: 1 hour Price: Free

Free

Master Excel's Form Controls

Learn how to create easy to use interfaces. Level: Intermediate Duration: 1 hour Price: Free

Free

Master Excel's Form Controls

Learn how to create easy to use interfaces. Level: Intermediate Duration: 1 hour Price: Free

$25

Pivot Tables from Start to Finish

PivotTables allow you to summarise large data sets with a few clicks and no formulas. This bundle introduces PivotTables and takes you though the basics and covers more advanced topics. Version: All Versions Recorded: Jun 2020 Level: Intermediate Duration: 2.5+ hours Price: AU$25

$25

Pivot Tables from Start to Finish

PivotTables allow you to summarise large data sets with a few clicks and no formulas. This bundle introduces PivotTables and takes you though the basics and covers more advanced topics. Version: All Versions Recorded: Jun 2020 Level: Intermediate Duration: 2.5+ hours Price: AU$25

Free

Power BI - importing data with Get Data (Power Query)

An introduction in how to get data in Power BI. Level: Intermediate Duration: 1 hour Price: Free

Free

Power BI - importing data with Get Data (Power Query)

An introduction in how to get data in Power BI. Level: Intermediate Duration: 1 hour Price: Free

Free

Power Query - Import Multiple Files - 2021

Learn how to automate the data importation process in Excel. Level: Intermediate Duration: 1 hour Price: Free

Free

Power Query - Import Multiple Files - 2021

Learn how to automate the data importation process in Excel. Level: Intermediate Duration: 1 hour Price: Free

Free

Power Query - Import Multiple Files - 2022

Learn how to automate the data importation process in Excel. Version: All Versions Recorded: Apr 2022 Level: Intermediate Duration: 1 hour Price: Free

Free

Power Query - Import Multiple Files - 2022

Learn how to automate the data importation process in Excel. Version: All Versions Recorded: Apr 2022 Level: Intermediate Duration: 1 hour Price: Free

Free

Power Query - Import Multiple Files 2024

Learn how to automate the data importation process in Excel. Discover how to combine all the CSV files from a folder and sib-folder. See how to combine sheets from multiple Excel files. Version: All Versions Recorded: June 2024 Level: Intermediate Duration: 1 hour Price: Free

Free

Power Query - Import Multiple Files 2024

Learn how to automate the data importation process in Excel. Discover how to combine all the CSV files from a folder and sib-folder. See how to combine sheets from multiple Excel files. Version: All Versions Recorded: June 2024 Level: Intermediate Duration: 1 hour Price: Free

$25

Summing Functions for Accountants

Learn the tips, tricks, traps and techniques to summing up right in Excel.

$25

Summing Functions for Accountants

Learn the tips, tricks, traps and techniques to summing up right in Excel.

$25

Summing Functions For Accountants 2022

Learn the tips, tricks, traps and techniques to get summing right in Excel. Version: All Versions Recorded: Apr 2022 Level: Intermediate Duration: 1 hour Price: AU$25

$25

Summing Functions For Accountants 2022

Learn the tips, tricks, traps and techniques to get summing right in Excel. Version: All Versions Recorded: Apr 2022 Level: Intermediate Duration: 1 hour Price: AU$25

$25

SUMPRODUCT Function (1.5 hrs)

It has been called the Swiss army knife of functions. It can do array calculations without the array entry. If you don't have dynamic arrays yet, you can practice some of the techniques with SUMPRODUCT. Version: All versions Recorded: March 2020 Level: Intermediate Duration: 1.5 hours Price: AU$25

$25

SUMPRODUCT Function (1.5 hrs)

It has been called the Swiss army knife of functions. It can do array calculations without the array entry. If you don't have dynamic arrays yet, you can practice some of the techniques with SUMPRODUCT. Version: All versions Recorded: March 2020 Level: Intermediate Duration: 1.5 hours Price: AU$25

$49

The Complete Guide To Range Names 2022

Learn all about range names. See how to simplify formulas & speed up formula creation. Learn different ways to create ranges & how to use naming conventions to make formulas easy to copy & amend. Create your own custom functions with range names. Version: Microsoft 365 Recorded: Aug 2022 Level: Intermediate to Advanced Duration: 3.5 hrs with 1+ hrs bonus Price: AU$49

$49

The Complete Guide To Range Names 2022

Learn all about range names. See how to simplify formulas & speed up formula creation. Learn different ways to create ranges & how to use naming conventions to make formulas easy to copy & amend. Create your own custom functions with range names. Version: Microsoft 365 Recorded: Aug 2022 Level: Intermediate to Advanced Duration: 3.5 hrs with 1+ hrs bonus Price: AU$49

$25

VLOOKUP Function 2024 (1.5 hrs)

One of the most popular functions in Excel. See how to use it and avoid many of the issues plus handle the various errors that can happen. Versions: All versions Recorded: July 2024 Level: Intermediate Duration: 1.5 hours Price: AU$25

$25

VLOOKUP Function 2024 (1.5 hrs)

One of the most popular functions in Excel. See how to use it and avoid many of the issues plus handle the various errors that can happen. Versions: All versions Recorded: July 2024 Level: Intermediate Duration: 1.5 hours Price: AU$25

$25

XLOOKUP Function 2024 (1.5 hrs)

A brand new function that replaces VLOOKUP, HLOOKUP and INDEX-MATCH formulas. It has some special features. See how to apply them in this 90 minute session. Version: Microsoft 365 Recorded: July 2024 Level: Intermediate Duration: 90 minutes Price: AU$25

$25

XLOOKUP Function 2024 (1.5 hrs)

A brand new function that replaces VLOOKUP, HLOOKUP and INDEX-MATCH formulas. It has some special features. See how to apply them in this 90 minute session. Version: Microsoft 365 Recorded: July 2024 Level: Intermediate Duration: 90 minutes Price: AU$25