Excel Online Courses
Instructor-Led Excel Online Courses
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. The landscape of learning has changed and being able to undertake training from the comfort of your own desk now provides greater flexibility for staff to attend professional development. We will help staff to utilise the technology they have available to them in the most effective way.
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 prerecord 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.
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
Microsoft Excel Online Courses
Browse through some options for learning new Excel skills online or create your own course based on staff skills and requirements. Our online training is 100% customisable.
Courses can be conducted in any Excel version including Excel 2010, Excel 2013, Excel 2016, Excel 2019 and Excel 365.
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 Pivot Tables. 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 Pivot Table specific to your needs, how to create multiple Pivot Tables on the same worksheet, number formatting, use compounded fields, group data, create your own calculated field and more.
We will also explore how to use the PivotChart function to provide a visual representation of your data set.
1 Hour Session
For up to 3 people
-
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
-
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
-
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
-
1-3 participants
-
Live training with expert trainers
-
Any Microsoft program
-
Combine topics to create your own course
Course Includes
Skills Analysis
Take advantage of our free online skills analysis prior to your training to ensure you’re enrolled in the right course.
Certificate
After completing the course you’ll receive a certificate to show off your new-found Microsoft Excel knowledge.
Online Learning Platform
Online learning available via Microsoft Teams or Zoom platforms.
Hands-on training
We’re big believers in hands-on learning so you’ll be building your skills in real-time with live demos and practice exercises.
Email Support
Access unlimited support following your training course to build on your learning and ask any burning questions.
Real-world examples
There’s nothing better than working through real-world examples to reinforce learning and increase your confidence.
Send an enquiry
0418 820 572
available Monday to Friday
9:00am till 5:00pm
Email: info@beltan.com.au