LEARN EXCEL FOR FREE

Free Excel Training

We’ve turned hours of YouTube Excel tutorials into free, step-by-step courses. No endless searches, sign-up forms or subscription fees. Just pick a course and and get started today!

Excel for Beginners Course

Get off to a great start in Excel with our free step-by-step course made up of 50 high-quality, in-depth YouTube tutorials.

free xero course for beginners australia

On this free course you'll learn how to:

  • Manage rows, columns, cells, worksheets, workbooks and more.

  • Speed up your workflow with Autofill and Find & Replace.

  • Format numbers, align text and AutoFit your data.

  • Use basic functions like SUM, AVERAGE, COUNT and IF.

  • Sort and Filter data with ease.

  • Lock and protect your data for added security.

  • Print perfectly in Excel no matter the size of your workbook.

Just click on the button below to go straight to lesson 1.

Excel Formulas and Functions Course

This high-quality, in-depth YouTube video will take you from being a total beginner with Excel formulas and functions to a complete pro in just 2 hours.

On this free course you'll learn:

  • The difference between formulas and functions in Excel.

  • The Big 5 easy functions: SUM, COUNT, AVERAGE, MAX and MIN.

  • SUMIFS and COUNTIFS so you can look up data with conditions.

  • Modern lookup functions such as VLOOKUP and XLOOKUP.

  • Logical functions such as IF, IFS and nested IFs.

  • Advanced techniques such as INDEX/MATCH.

  • And more!

Just click on the button below to go straight to lesson 1.

free xero payroll course australia