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.

excel training melbourne

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.

Excel Introduction

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

Excel Intermediate

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

Excel 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.
  • 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

Formulas and Functions

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

Databases & Pivot Tables

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

Excel Introduction

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

Excel Intermediate

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

Excel Advanced

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

Formulas and Functions

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

Databases & Pivot Tables

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

Excel Introduction

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.

Excel Intermediate

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.

Excel Advanced

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.

Formulas and Functions

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.

Databases & Pivot Tables

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

MS Office 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.
  • microsoft office training courses melbourne

Project Courses

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

Word Courses

  • Use Microsoft Word to create professional looking documentation including letters, reports, and newsletters. Microsoft Word can also be used to transform documents to webpages.
  • microsoft word training courses melbourne

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