Excel (12 month access)

Module 1- Excel

Lesson 1: Setting the stage

This lesson sets the stage being the Excel workspace. It covers the very basics of navigating Excel starting from opening and closing a workbook. You will get an introduction to the keyboard shortcuts, basic formatting and even four basic functions. The lesson ends with a practical where you will use all the skills acquired throughout the lesson to do simple data entries and create your first list.

Lesson 2: The blank canvas

This lesson focuses on our blank canvas upon, which to create spreadsheet masterpieces. It builds on the basics of lesson 1 and introduces even more formatting options. Here you will learn about managing data across more than one worksheet and more than one workbook. You will venture into the Insert tab and create your first table. 

Lesson 3: Sheets, tables, and things

This lesson focuses on the area in Excel where few dares to venture, so we go backstage to look at the File tab. This lesson also focuses on a tool for working efficiently in Excel by linking cells, worksheets and workbook and a new function, the handy SUMIF, is unpacked to add to your repertoire of functions. 

Lesson 4: Keep organised

This lesson pays special attention to tools to keep organised in Excel. This includes exploring simple date functions, sorting, and filtering data. A key concept is explained, being absolute and relative referencing that will stand you in good stead to be able to work even more efficiently in Excel. 

Lesson 5: The code of conduct

This lesson focuses on the integrity of data and the skills acquired to do so comprise using outlines to group data, flash fill, removing duplicates, adding control checks, using spell check and creating basic drop down lists. Added extras will be learning another function, AVERAGE as well using cell styles and the thesaurus. 

Lesson 6: Lights, camera, action!

This is a very practical lesson and covers one of the main acts, charts and graphs. These are the stars of the show being the tools you can use to visually represent your data and adds professionalism to any spreadsheet or report. This lesson covers two basic types of graphs, which will be more the sufficient to get you started with presenting meaningful data. 

Lesson 7: Getting into shape

This lesson is also very practical and fun where you get to be a bit more creative. You can add your personal touch to presentations by adding in shapes or using SmartArt to illustrate information in a particular way. Other useful tools that will be covered include people graphs, slicers, icons and 3D models. 

Lesson 8: Keep it clean

This is an action-packed lesson with a focus on using accurate data. The first step to achieving accurate data is ensuring it is cleaned. To do this you will learn the TRIM and CLEAN functions. You will take sorting one step further to be able to sort using multiple levels and highlight duplicate records using conditional formatting. You will also learn some extra keyboard shortcuts to find data quickly. This lesson also covers print settings, so you can keep hard copies of your hard work after finalising your data. 

Lesson 9: Creating footprints

The lesson focuses on creating footsteps for someone to follow in as we will be learning all about templates, what templates are available and even how to create your very own template. Added extras covered will be building on conditional formatting and uncovering the options available to us in this useful command. If you are all for saving trees, this lesson will also show you ways to create PDF versions of your workbook. 

Lesson 10: A helping hand

There are many safety nets available in Excel with multiple ways to access the Help function being the key one. This lesson focuses on all the support available to Excel users and how to access them within the application. We will also discuss customising the Excel workspace to make it really feel like home. Being the last lesson for Module 1, this lesson will culminate all the basic skills acquired throughout the module into an exciting mini project, where you will create your very own personal monthly budget template that you can begin using straight-away. 

Module 2- Excel

Lesson 1: Prelude to pivots

In this lesson we discover the magic of the SUMIF, SUMIFS, and AVERAGEIFS functions. These are only a few of the incredible functions we will explore. When we are working with a large amount of data conditional formatting and the data analysis tool comes in handy. These tools assist us in identifying the valuable pieces of information. Finally we will end the lesson of learning how to create pivot tables. These tables are another great way of sorting through different data sets.  

Lesson 2: Tempting tables

In this lesson we discover the magic of the SUMIF, SUMIFS, and AVERAGEIFS functions. These are only a few of the incredible functions we will explore. When we are working with a large amount of data conditional formatting and the data analysis tool comes in handy. These tools assist us in identifying the valuable pieces of information. Finally we will end the lesson of learning how to create pivot tables. These tables are another great way of sorting through different data sets.  

Lesson 3: Fancy formulas

In this lesson you will learn the useful formulas of VLOOKUP and HLOOKUP. You will also learn more advanced features of sorting and filtering, how to customize it, and how to get multi-level filters. We also explore the use of Text formulas, when, and how to use them. We will complete practical examples to help you understand when it is best to use these functions. 

Lesson 4: Pretty protected

In this lesson, we will learn about the logical formulas AND, OR, IF, IFERROR, IFNA. We will continue with the example used in lesson 1 and learn how to create basic rules for conditional formatting from this example. We will also learn how to lock cells and ranges, and how to unlock them from a protected worksheet for users to edit.  

Lesson 5: Pivot progression

In this lesson you will learn how to import files from txt and csv to Excel, how to modify and how to export it. We will learn other ways to split data. We advance our skills as we learn more function in Pivot tables, interpretation, visualisation, and how to change the default areas. All of these skills enable us to use the function that best suits the data we are working with or the one we like best.  

Lesson 6: What’s in a name

Named ranges are a fantastic way of understanding what we are working with. Image looking at a sheet with may numbers and symbols, we will not understand what the data is about. When we use a name range we can easily identify what the data is. For example, the number of sales for a given month. The Name Manager is one of the most powerful tools to automate our tasks in Excel. Importing data into excel is much more efficient than rewriting it all, although we need to provide Excel with instructions on how to read the data. After importing data we can use the fixed width command to ensure the data is displayed correctly. In some cases we may have input messages, alerts, and data to validate. So in this lesson we explore all the commands and functions to ensure we can import and analyse our data effectively.  

Lesson 7: Up the ante

Working with a named range allows us to understand where our data comes from. They assist in making formulas easier to read and understand. Named ranges can be used almost everywhere, including pivot tables. In this lesson we will also learn how to protect cells and ranges. Protecting cells and ranges are important when we have sensitive data or data that a selected person can change.  

Lesson 8: Unleash the creativity

There are many creative ways to display a set of data. Charts are a visual aid that may help us present data more effectively. Did you know there are 11 types of charts you can create in excel? In this lesson we will have a discover how we can use charts to display or summaries different pieces of information. 

Module 3- Excel

Lesson 1: Delectable data

When we are analysing data excel provides is one of the best tools. In this lesson we will explore how we can import data from the world wide web. Importing data is a lot faster than rewriting all the data,. Another great benefit excel has a command that allows the data to be updated as it is updated on the web too. We will also discuss how to import data using the power query. Lastly, after we have discovered the exciting ways of importing data, we will use the quick analysis tool to assisting in formatting, creating chars, and other fun ways of discovering exciting things about the data you are working with.  

Lesson 2: Funky formulas

It is time to learn a few more formulas. In this lesson we will discover the ISERROR, ISNA, ISBLANK, ISNUMBER, SHEET, and OFFSET functions. The more comfortable you become with functions, you will notice how they assist in using your time efficiently. Did you know that you can add other microsoft and other files to an excel sheet? When you are doing a presentation it is an effective way to jump to another file you need without going the long way round. In the last topic of this lesson, we will learn about some tricks of the formula auditing, we will explore what is it, why is useful, how to navigate on it, how to trace precedents, how to trace dependents, we will learn about show formulas, error checking, and short out.  

Lesson 3: Nifty nesting

We continue to learn a few more helpful formulas. In this lesson we use the AND, OR, IF, IFERROR, IFNA, and VLOOKUP formulas. The OFFSET function can be used when we are doing data validation. In this lesson we will discover exactly how this works.  

Lesson 4: But what if?

The Scenario Manager is a great feature for comparing multiple sets of data in a worksheet, in this lesson we will show you how this feature can help us to make decisions. We will discover how we can manage data tables of more than one variable. In the last topic of this lesson, we will learn about the consolidation feature to combine data from different worksheets or different workbooks into one.  

Lesson 5: Fun with formatting

So far we have discovered a variety of formulas and how to use conditional formatting. In this lesson we will learn a few new formulas. We will discuss the INDEX, MATCH, WEEKDAY, and MONTH formulas. In the last topic of this lesson, we will see how to make our life easier when we are working with many cells. We will show you how to work with Freeze Panes, Multiple windows, Switch Windows, how to split your data, etc. 

Lesson 6: Perfecting pivots

In the first topic of our lesson, we will have a look back into some previous knowledge acquired, Pivot tables, we will focus on sorting and filtering. But is does not end there Pivot tables may also have multiple levels. We will explore the multiple level in the values area and use multiple report filters too. A great way to really get a grasp of our data is by grouping them. In this lesson we will learn how to group products and dates. Lastly we will end off by creating a histogram to help us visualize numerical values graphically. 

Lesson 7: The road less travelled

Excel can help us to predict the future. Unfortunately not the actual future but it will help us predict future numerical values. We are able to predict things such as sales, inventory, or even population growth. In this lesson we will explore how to use this function and make a few of our own predictions. Predicting the future may leave us thinking what if. In this lesson we will use the what if function to see how values or predictions can change when things are manipulated. Once we have predicted future populations we may want to display this visual. We will finish the lesson off by discovering a 3D map displaying different pieces of information.  

Lesson 8: Mighty macros

Doing the same repetitive task is not only mind numbing but sometimes human error may sneak in. In this lesson we will learn to create a macro. It means that when we run the macro again Excel will automatically copy and apply the same mouse clicks and keystrokes that you did before. All your work gets done for you.  

What you will get
Lifetime access to the courses you purchase
As a Learnt member you have access to courseware you have purchased which is stored in your personal platform for a lifetime of learning.

Learn from anywhere, anytime
With 100% online courseware you can conveniently complete at your own speed. You can learn from anywhere using your choice of device.

Flexible payment options
With affordable weekly payments (afterpay, debit success)

Industry leading courses
You can start learning straight away, designed with the learner in mind. Customers gain access immediately to the courseware they have purchased simply via a link emailed to them.

Dedicated support while you learn
Simply contact us via live chat, phone or email to speak to a Learnt expert.

What our learners have to say


In my role as a salesperson at Rebel Sport Miranda, I have found the information, skills and training on the Learnt Platform has increased my knowledge of the Retail industry and has made my role much more rewarding.
Sara Johnstone

Course sections
  • crimg

    Learn how to use Excel functions and create dynamic formulas to generate datasets and data visualisations in this online certification and excel training course.

Course details


12 month access
  • Financial Analysts
  • Retail Store Managers 
  • Project Managers
  • Business Analysts
  • Data Journalists
  • Accountants
  • Administrative assistant
  • Cost estimator
  • Information clerk
brand-icon Earn 4980 Qantas Points

Payment options

Qantas Points
Use Qantas Points to purchase.
Latitude Pay
Coming Soon…

Got  a question?

Speak to one of our Learnt experts!

"*" indicates required fields

Request to call back*


How do I get started?

You can start right away! Once you have completed the sign-up process and completed your checkout successfully, you can start learning on the spot. You will receive a confirmation email and a receipt for your purchase. This email will contain your course login details, and instructions on how to access and log in to your course. Don’t forget to check your junk/spam folder if you do not receive this email.

A willing attitude and a computer/tablet/phone are all you need to get started! You do not need any pre-requisites to complete any of our online courses. However, if you have any further questions, feel free to contact us at hello@learnt.global

Our online training doesn’t require you to be a tech genius, however basic computer skills are required to complete our courses. Fundamental computer skills such as typing, understanding how to navigate a computer and basic Microsoft office are ideal for getting the most out of your learning.

When undertaking courses with Learnt, you have access to support via our Learnt experts. Simply use our contact us form on the website, call us or request a call back and our team will be in touch!



Game Design and Development (12 month access)



Coding and Technology (12 month access)



Data Analytics (12 month access)



Probability and Statistical Analysis (12 month access)



Python Programming (12 month access)

Make your business better everyday with LEARNT and Qantas Business Rewards. Earn 30 Qantas Points per $1 spent when you purchase any new annual Business in a Box subscription by 31 July. T&C’s apply.
Our Hospitality Business in a Box subscriptions give you training straight away, meaning your team can upskill while you focus on other important areas of your business. PLUS for a limited time only, purchase any new annual subscription and earn 30 Qantas Points per $1 spent. T&C’s apply.
Did you know when you sign up to LEARNT you get exclusive access to our taster courses? Sign up now to start your learning on the spot! Click the link in bio to sign up and don't forget to enter our Valentines Day competition.
#learnandearn #onlinelearning #creativelearning #educationispower #education  #learning  #elearning  #distancelearning  #onlinecourses
| LEADERSHIP IN A BOX | Refresh and challenge yourself as a leader with the help of renown executive coach, Peter Hislop. Presented by Executive Masterclass, Peter coaches you through the essential learnings to develop your leadership skills as he has done for many years with politicians, CEO's and other high end clients. Click the link in our bio to start learning today!
Schools out for good! 🎉  So what now? With LEARNT you can still have fun with your friends but also get a head start on your career. Flexible Travel & Tourism, Pet Care & Veterinary and Fitness courses are ready for you to learn on your time today!

#learnt #onlinelearning #schoolies #schoolleavers #creativelearning #educationispower #education #learning #elearning #distancelearning #onlinecourses
Christmas is in 40 days. Is your small business ready?

Ensure your team thrive, and not just survive during the Christmas mayhem. Let LEARNT train your team with our industry specific course subscriptions!
Style your house effortlessly or kickstart your career in Interior Decorating with LEARNTs online Interior Decorating course!

Available now via the link in our bio.
Did you know you can know learn how to make a Kokedama in the comfort of your own home with @learnt.global ?

With our step by step video course, you’ll be an expert in no time!

Click the link in our bio to find out more 🌱

#kokedama #kokedamaworkshop #plantsofinstagram #plantlove #onlinelearning #learnt
Love organisation? Always the go to party planner among your friends? Maybe a career in Events could be your true calling!

Check out our range of Hospitality courses and you could be planning your next career move sooner than you think!
Considering a career shift as the world opens up? Whether you want to work on the ground as a travel agent or in the air as a flight attendant, kick start your career with LEARNT.
Whether you're passionate about a career with kids, or a parent simply wanting to learn more - our range of courses are ideal for anyone on the go. Nurturing Creativity in Children, Healthy Eating for Kids and Advanced Childcare online courses are all conveniently available for you to start now!
Dreaming of Fashion Design? Maybe you want to start your own fashion label or join a powerhouse brand? Make your dreams a reality with LEARNT's Fashion Design course!
This error message is only visible to WordPress admins
Error: Access Token is not valid or has expired. Feed will not update.

^You must be a Qantas Frequent Flyer member to earn and use points. Membership and points are subject to the Qantas Frequent Flyer program terms and conditions, available at qantas.com/terms. Qantas Frequent Flyer members who link their Frequent Flyer membership number to their Learnt Global account or who provide a valid Qantas Frequent Flyer membership number at the time of purchase will earn up to 20 Qantas Points per $1 spent on Eligible Products. Qantas Points will be credited to the Qantas Frequent Flyer account within 14 days of purchase. Any purchases that are cancelled or refunded will not earn Qantas Points. Qantas Frequent Flyer members can also use Qantas Points to purchase their Eligible Product. Members must have linked their Frequent Flyer membership number to their Learnt Global account and must be validated at the time of purchase in order to use Qantas Points. Qantas Points will not be earned on purchases made using your Qantas Points. An Eligible Product means a learning course or courses purchased under a user licence from the Program Partner in accordance with the Program Partner’s user terms and conditions and not via a referral partner, white label partner or third party or where a discount or promotion or qualification code has been applied in purchasing an Eligible Product. Any claims in relation to Qantas Points under this offer must be made directly to Learnt Global Pty Limited. Click here for full terms and conditions.