Excel Yourself/New and Updated Courses 2024

$315 or 3 monthly payments of $105

New and Updated Courses 2024

Bundle
31 Products

New courses were added in 2024 & others updated. This Bundle brings them all together. Free and Paid sessions. Includes Budgets, Dashboards, Macros, Functions and Dynamic Arrays. Get all the latest courses for one low price. Payment plan available at no extra cost. Versions: Microsoft 365 Recorded: During 2024 Level: Beginner to Advanced Duration: 45 hours Price: AU$315 Payment Plan: AU$105 per month x 3 months

Contents

$25

Advanced Budgeting Techniques 2024

Course
6 Lessons

Discover how to build in row level selections into your budget. Incorporate Excel's new dynamic arrays in your budget. Techniques covered include - range names - logic calculations involving TRUE and FALSE - check boxes and how to turn off features - the INDIRECT function - dynamic arrays - creating a custom function example Version: Microsoft 365 Recorded: Feb 2024 Level: Advanced Duration 1 hour Price: AU$25

$50

Advanced Excel 2024 4.5+ hours

Course
11 Lessons

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

$25

Budget and Power Query 2024

Course
8 Lessons

See how to solve two budget issues with Power Query. Power Query can ensure all files have the same inputs and it can automate the budget consolidation process. Version: All Versions Recorded: Feb 2024 Level: Advanced Duration: 1 hour Price: AU$25

Free

Budget Challenge 2024 - Subscription version

Course
8 Lessons

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 2024 Level: Intermediate to Advanced Duration: 1 hour Price: Free

$25

Budget Template 2024 (1hr 45min)

Course
8 Lessons

See how you can use a Budget Template to speed up the budget creation process. This course uses new features and functions in the subscription version of Excel. Includes an extras video to cover the new functions in more depth. Version: Microsoft 365 Recorded: Feb 2024 Level: Advanced Duration: 1 hr 45 min Price: AU$25

$25

Dynamic Arrays Advanced Functions

Course
4 Lessons

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

Course
5 Lessons

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

Course
5 Lessons

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

Course
6 Lessons

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

$25

Excel Budget Payroll 2024

Course
4 Lessons

This session examines an existing payroll budget structure. Payroll is one of largest expenses in many organisations. Getting it right is an important step in the budget process. Often the payroll budget is separate to the main budget due to confidentiality issues. This payroll model handles up 250 staff & can be scaled. Version: Microsoft 365 Recorded: Feb 2024 Level: Advanced Duration: 1.5 hours Price: AU$25

Free

Excel Copy and Paste Techniques 2024

Course
4 Lessons

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 Dashboards #1 - Guidelines - 2024

Course
4 Lessons

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

Course
6 Lessons

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 #3 - Sparklines & Conditional Formats 2024

Course
6 Lessons

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

Course
6 Lessons

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 #5 - Dynamic Arrays 2024 (1.5hrs)

Course
7 Lessons

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 Level One - Beginners - 2024 - 4.5 hrs

Course
11 Lessons

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

$25

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

Course
13 Lessons

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 Loan Schedules

Course
6 Lessons

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

Free

Financial Functions Part 1 (2024)

Course
5 Lessons
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)

Course
5 Lessons
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

Closed
Course
4 Lessons

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 2024

Course
5 Lessons

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

Macros 1 - Recording Tips, Tricks & Traps 2024

Course
5 Lessons

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

$25

Macros 2 - Recorded to Remarkable 2024

Course
5 Lessons

Recorded macros have lots of limitations. See how to remove many of the limitations with a little bit of programming. No programming experience required. Learn how to speed up your macros and use variables. (This session assumes you have completed the Macros 1 session or that you are comfortable with recording macros) Version: All versions Recorded: May 2024 Level: Intermediate Duration: 1hr 30min Price: AU$25

$25

Macros 3 - Interaction & Debugging 2024

Course
5 Lessons

Recorded macros can’t interact with the user. Interaction makes macros more user-friendly and flexible. Debugging involves removing errors from your code. Learning these techniques help improve your macros. Macros 1 and 2 are prerequisites or you must be familiar with editing recorded macros to do this session. Version: All versions Recorded; May 2024 Level: Intermediate Duration: 1hr 30min Price: AU$25

$25

Macros 8 - VBA Variables 2024

Course
5 Lessons

This session covers variables in depth and expands on previous sessions. Learn how to make the most of variables in your VBA code. There are so many advantages to using variables, but you need to get a good understanding of them to get the most out of them. Version: All versions Recorded: May 2024 Level: Intermediate Duration: 1 hour 15 minutes Price: AU$25

Free

Power Query - Import Multiple Files 2024

Closed
Course
7 Lessons

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

Three Statement Excel Budget 2024

Course
6 Lessons

A three statement Budget built using dynamic arrays, Excel's new formula and function calculation engine. You need the subscription version of Excel for this session. See how to integrate the Profit & Loss, Balance Sheet and Cash Flow. Version: Microsoft 365 Recorded: Feb 2024 Level: Advanced Duration: 1 hr 15 min Price: AU$25

$25

VLOOKUP Function 2024 (1.5 hrs)

Course
6 Lessons

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)

Closed
Course
5 Lessons

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