Microsoft Excel Courses Melbourne | Microsoft Excel Training

Do you need some Microsoft Excel training in Melbourne?

Have you always wanted to know how to manage budgets, create beautiful charts, design functional and visually pleasing pivot tables, or perform an IF or VLOOKUP statement?

Or do you really need to be a data analytics rockstar but don't know where to start?

Do you need Microsoft Excel training in Melbourne?

Have you always wanted to know how to manage budgets, create beautiful charts, design functional and visually pleasing pivot tables, or perform an IF or VLOOKUP statement? Or do you really need to be a data analytics rockstar but don't know where to start?

Microsoft Excel training

We have Excel courses that are suited for all levels, regardless if you are new to Excel, or if you a more advanced user who has been using Excel for years and need to learn some of the more complex functions.

We also offer shorter topic driven Excel courses where you can learn all about formulas and functions and databases and pivot tables.

Our facilitator led courses are delivered in Melbourne and across regional Victoria.

You can save up to 7 hours per week

Just by knowing how to use Excel more effectively. Come along to one of our Excel courses and we’ll show you how!

We can facilitate all Excel courses onsite at your business location and course content and duration are customised to individual and organisational requirements. We also conduct several online 2 hour topic driven workshops on topics such as formulas and functions and pivot tables.

from $ 209 per pax (group of 10)

This excel course is designed for those who need to know how to use Excel to produce simple reports, budgets, lists and perform other similar tasks.
Understand the Excel environment
Enter text, numbers and dates into cells
Calculate using formulas and functions
Format worksheet data
Work with multiple worksheets
Explore printing options

Beginner

from $ 209 per pax (group of 10)

Learn how to use formulas and functions. Participants will be able to edit, group and delete worksheets, use simple formulas and functions and create basic charts.
Work with formulas and functions
Understand and use absolute referencing
Create and format charts
Build formulas to link worksheets and files
Use conditional formatting
Sort and filter lists

Intermediate

from $ 209 per pax (group of 10)

This excel course is designed for those who need to know how to use Excel to produce simple reports, budgets, lists and perform other similar tasks.
Work with advanced Excel functions
Use data analysis tools such as GoalSeek
Sort, filter and add totals to lists
Create pivot tables and pivot charts
Record, edit and assign macros
Setup cell data validation

Advanced

from $ 209 per pax (group of 10)

This course is designed for those who need to know how to use more advanced formulas and functions in Microsoft Excel.
Understand and use absolutel references
Create complex mathematical formulas
Work with text functions
Build formulas to link worksheets and files
Use VLOOKUP, HLOOKUP and XLOOKUP
Create complex conditional functions

Intermediate

from $ 143 per pax (group of 10)

This course is designed for those who need to know how to use Excel as a database to manage and manipulate data.
Create an Excel database
Sort and Filter a database in Excel
Use sub totals to calculate data
Work with conditional formatting
Advanced database functions
Create pivot tables and pivot charts

Advanced

from $ 209 per pax (group of 10)

This excel course is designed for those who need to know how to use Excel to produce simple reports, budgets, lists and perform other similar tasks.
Understand the Excel environment
Enter text, numbers and dates into cells
Calculate using formulas and functions
Format worksheet data
Work with multiple worksheets
Explore printing options

Beginner

from $ 209 per pax (group of 10)

Learn how to use formulas and functions. Participants will be able to edit, group and delete worksheets, use simple formulas and functions and create basic charts.
Work with formulas and functions
Understand and use absolute referencing
Create and format charts
Build formulas to link worksheets and files
Use conditional formatting
Sort and filter lists

Intermediate

from $ 209 per pax (group of 10)

This excel course is designed for those who need to know how to produce simple reports, budgets, lists and perform other similar tasks.
Work with advanced Excel functions
Use data analysis tools such as GoalSeek
Sort, filter and add totals to lists
Create pivot tables and pivot charts
Record, edit and assign macros
Setup cell data validation

Advanced

from $ 209 per pax (group of 10)

This course is designed for those who need to know how to use more advanced formulas and functions in Microsoft Excel.
Understand and use absolutel references
Create complex mathematical formulas
Work with text functions
Build formulas to link worksheets and files
Use VLOOKUP, HLOOKUP and XLOOKUP
Create complex conditional functions

Intermediate

from $ 143 per pax (group of 10)

This course is designed for those who need to know how to use Excel as a database to manage and manipulate data.
Create an Excel database
Sort and Filter a database in Excel
Use sub totals to calculate data
Work with conditional formatting
Advanced database functions
Create pivot tables and pivot charts

Advanced

from $ 209 per pax (group of 10)

This excel course is designed for those who need to know how to use Excel to produce simple reports, budgets, lists and perform other similar tasks.

from $ 209 per pax (group of 10)

Learn how to use formulas and functions. Participants will be able to edit, group and delete worksheets, use simple formulas and functions and create basic charts.

from $ 209 per pax (group of 10)

This excel course is designed for those who need to know how to produce simple reports, budgets, lists and perform other similar tasks.

from $ 209 per pax (group of 10)

This course is designed for those who need to know how to use more advanced formulas and functions in Microsoft Excel.

from $ 143 per pax (group of 10)

This course is designed for those who need to know how to use Excel as a database to manage and manipulate data.

More Courses

You might also be interested in these courses

Improve your skills in Microsoft Office and Office 365. Beginner to advanced Microsoft courses in the full Office suite including: Excel, Word, Outlook, PowerPoint, Project, Access, SharePoint and Teams.

Learn advanced features of Microsoft Project. Create custom tables, views and reports, allocate and manage and share resources and automate project functionality using macros.

Use Microsoft Word to create professional looking documentation including letters, reports, and newsletters. Microsoft Word can also be used to transform documents to webpages.

What people say

4.7 out of 5

 4.6/5

5 out of 5

 5/5

Despite the topic (Excel), Ian kept the course engaging all day. A very satisfying Excel course. Thanks Ian

Stefan

2016

5 out of 5

 5/5

Great course, entertaining plus informative. Thank you, I now have more confidence to practice informative spreadsheets and know how to manipulate and manage data in Excel.

Cindy

2019

5 out of 5

 5/5

Facilitator was very enthusiastic and had an awesome knowledge of Excel. There was no question she couldn't answer. Made the day fun and engaging.

Cass

2019

4.5 out of 5

 4.5/5

Great Excel training. Ian covered all my learning gaps to become proficient in the use of Excel especially with lists and formatting. Very engaging trainer, thanks Ian! Money and time well spent.

Nick

2018

4 out of 5

 4/5

The demonstrations were clear and the Excel examples were practical.

Simon

2017

5 out of 5

 5/5

Ian made the Excel training course quite entertaining and made the learning fun, whereas I have always found it tricky in the past.

Hannah

2019

5 out of 5

 5/5

Good energy and enthusiastic as well as very knowledgeable. Thanks Mark.

Arjun

2018

5 out of 5

 5/5

Ian has a great knowledge of Excel and has taught useful tips to use back in the workplace

Chanae

2019

5 out of 5

 5/5

Great facilities, informative content and knowledgeable trainer with impressive delivery. Great Excel course, highly recommend. A++

Nicole

2019