fbpx

Excel Online Courses

Learn Excel Online

Microsoft Excel is the world’s most popular data analysis program. Without a doubt, we conduct more Excel courses than any other program across any year. With changes to our working environments and more people now working remotely from home, we need to adapt our learning styles to accommodate this changing landscape. This is where our Excel online courses become crucial to ensure staff continue to thrive and utilise the technology they have available to them whilst working remotely.

With 20 years of experience in the training industry, we now offer Excel training online to clients across Australia. These Excel short courses are designed to be a targeted approach to learning. Take out the part of the training you already know and focus solely on the areas which you wish to improve or explore for the first time.

By undertaking one of our online courses you still have the advantage of working with a live trainer. We do not prerecorded our online courses so you get the same experience of speaking and interacting with your trainer, that you would have had in a face to face Excel class.

Excel Online Short Course
Excel Online Short Courses

Choose your course duration

Choose between a 1, 2, 3 hour or a full day online session with a live trainer. No pre-recorded content.

One-on-one or Group Sessions

Learn one on one or include other staff for group training sessions.

Effective Targeted Training

Undertake targeted training in the areas your staff need help.

Customer Testimonials

Carol D.
Carol D.Microsoft Excel Training
Read More
"Belinda was great! The pace was just right for me. I have learnt so much. Belinda is very organised, which improves the learning experience."
Belinda F.
Belinda F.Microsoft Excel Training
Read More
"Brilliantly simplified and explained information with a very practical focus."
Name Withheld.
Name Withheld.Microsoft Excel Training
Read More
"Extremely well communicated. Clear and concise instructions."
Julie M.
Julie M.Microsoft Excel Training
Read More
"Belinda was very clear in her presentation. The pace of the training was helpful."
Name Withheld.
Name Withheld.Microsoft Excel Training
Read More
"Today has been a wonderful day learning more in a fun, interactive & personal way. Thank you so much."
Name Withheld.
Name Withheld.Microsoft Excel Training
Read More
"Clear info, wonderful to have everything explained so well. Belinda took her time and was patient when we needed things explained again."
Name Withheld.
Name Withheld.Microsoft Excel Training
Read More
"Absolutely amazing, Belinda explains everything & if you don't understand, she will go back through it."
Belinda R.
Belinda R.Microsoft Excel Training
Read More
"Really enjoyed it. Explained so much that will help me in my job."
Andrew H.
Andrew H.Microsoft Excel Training
Read More
"Belinda breaks everything down so it's easy to understand."
Nicole O.
Nicole O.Microsoft Excel Training
Read More
"Very helpful and explanatory. Belinda is very thorough and patient."
Name Withheld.
Name Withheld.Microsoft Excel Training
Read More
"Professional, thorough, easy to understand. Very well presented."
Sarah V.
Sarah V.Microsoft Excel Training
Read More
"Belinda was great. Everything was covered in detail and explained so we could understand."
Tom G.
Tom G.Microsoft Excel Training
Read More
"It was great to expand on previous knowledge and pick up a wide variety of new skills."
Name Withheld.
Name Withheld.Microsoft Excel Training
Read More
"Very informative. Learnt a lot of new things and shortcuts."
Mitch H.
Mitch H.Microsoft Excel Training
Read More
"Belinda was very knowledgable of the subject and was good at tailoring the training to suit the way we use the software."
Previous
Next

Microsoft Excel Online Courses

Browse through some options for Excel online courses or create your own based on staff skills and requirements.

Excel Introduction

Explore the range of Excel functions which will enable you to perform basic calculations using best practice methods. Learn how a formulas is structured along with using built-in fomrulas to allow division, multiplication, addition and subtraction. Learn how to calculate averages, find highest and lowest values, count values and solve common error messages.

In this session we explore the ways in which you can format your worksheets to give more meaning to your data. Explore the font and paragraph formatting features along with number formatting techniques and how to resize your worksheet to fit your data. 

Once we have the worksheet looking visually appealing, let’s look at techniques to enable you to print your data in the format you want. We look at print setup techniques and how to make our data fit into a specific page configuration.

In this session we will explore the time-saving techniques we can use in Excel to deal with a series of data and patterns. Learn how Excel can recreate number and text based patterns to save you time and effort when creating content. Explore the AutoFill tool and Flash Fill and see these amazing tools in action.

Once we have finished with patterns we will move into the ability to sort & filter data. By far a huge benefit of Excel we will explore how to sort data alphabetically and by values plus how to we can filter our specific information from a larger data set. We will explore the the number, date and text filters available along with lots of real-world tips on using these features.

In this session we will explore the world of Excel charts. Charts provide amazing ways to give a visual display of our data. Explore the different chart types available and how we can customise the look and feel to differentiate charts from others. 

We will then explore the mini chart world of Sparklines and we can seemlessly incorporate them into our worksheets.

Excel Intermediate

Explore the next level of formulas available in Excel to to help you analyse your data. Explore absolute and relative cell references, named ranges, lookups, IF statements, date functions, sumif, and additional count functions.

In this session we will explore two amazing features of Excel. Explore how to use Conditional formatting to highlight important information based on criteria you have set. 

We will also explore how to create your own custom number formats so that infromation is displayed in the exact way you require. 

In this session we will further extend our knowledge with the use and functionality of Excel charts. We will then jump into the world of Excel Dashboards and learn how to create these amazing visual representations of our data.

Excel Advanced

In this session we explore the data protection functionality available in Excel. From password protection our worksheets or entire workbook, to allowing access to specific cell ranges only. 

We will then explore how to can link information from one location to allow to avoid entering the same information in multiple files or worksheets. Streamline your spreadsheets and ensure you are using the most accurate version of data using data linking.

In this session we will explore to use the Subtotals feature of Excel to quickly create subtotals, count, and highlight lowest or highest within a dataset. 

We will then explore the Scenarion Manager feature to allow us to switch our data values in the click of a button.

In this session we will explore the dynamic use of PivotTables. We will learn how to use Excels most powerful feature to extract specific information from large data sets. Explore trends based on your data all with a versatile user interface.

Learn how to format a PivotTable specific to your needs, how to create multiple PivotTables on the same worksheet, number formatting, use componded fields, group data, create your own calculated field and more.

We will also explore how to use the PivotChart function to provide a visual represetation of your data set.

1 Hour Session

For up to 3 people

$ 125 00
1 hour online course
  • 1-3 participants
  • Live training with expert trainers
  • Any Microsoft program
  • Combine topics to create your own course

2 Hour Session

For up to 3 people

$ 190 00
2 hour online course
  • 1-3 participants
  • Live training with expert trainers
  • Any Microsoft program
  • Combine topics to create your own course

3 Hour Session

For up to 3 people

$ 285 00
3 hour online course
  • 1-3 participants
  • Live training with expert trainers
  • Any Microsoft program
  • Combine topics to create your own course

Full Day Course

For up to 3 people

$ 570 00
9am till 4pm
  • 1-3 participants
  • Live training with expert trainers
  • Any Microsoft program
  • Combine topics to create your own course

Send an enquiry

    0418 820 572

    available Monday to Friday
    9:00am till 5:00pm

    Email: info@beltan.com.au

    Call Now Button