Microsoft Excel Training 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?

Let us Help!

Microsoft Excel Training 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?

Let us Help!

Microsoft Excel Training Melbourne

We have Microsoft Excel training 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. 

All of our facilitators are accredited certified Microsoft Excel training experts and courses are delivered either face to face in Melbourne and regional Victoria or online via Zoom or Microsoft Teams.

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

Half day: $1,870 / Full day: $2,530 Price per workshop, not per participant
  • 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
Course Outline
Beginner

Excel Intermediate

Half day: $1,870 / Full day: $2,530 Price per workshop, not per participant
  • 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
Course Outline
Intermediate

Excel Advanced

Half day: $1,870 / Full day: $2,530 Price per workshop, not per participant
  • 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
Course Outline
Advanced

Formulas and Functions

Half day: $1,870 / Full day: $2,530 Price per workshop, not per participant
  • 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
Course Outline
Intermediate

Databases & Pivot Tables

Half day: $1,870 / Full day: $2,530 Price per workshop, not per participant
  • 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
Course Outline
Advanced

Excel Introduction

Half day: $1,870 / Full day: $2,530 Price per workshop, not per participant
  • 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.
Course Outline

Excel Intermediate

Half day: $1,870 / Full day: $2,530 Price per workshop, not per participant
  • 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.
Course Outline

Excel Advanced

Half day: $1,870 / Full day: $2,530 Price per workshop, not per participant
  • This excel course is designed for those who need to know how to produce simple reports, budgets, lists and perform other similar tasks.
Course Outline

Formulas and Functions

Half day: $1,870 / Full day: $2,530 Price per workshop, not per participant
  • This course is designed for those who need to know how to use more advanced formulas and functions in Microsoft Excel.
Course Outline

Databases & Pivot Tables

Half day: $1,870 / Full day: $2,530 Price per workshop, not per participant
  • This course is designed for those who need to know how to use Excel as a database to manage and manipulate data.
Course Outline

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
Course Outline

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
Course Outline

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
Course Outline

What people say

4.7 out of 5
Rated 4.6 out of 5
5 out of 5
Rated 5 out of 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
Rated 5 out of 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
Rated 5 out of 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
Rated 4.5 out of 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
Rated 4 out of 5
The demonstrations were clear and the Excel examples were practical.
Simon
2017
5 out of 5
Rated 5 out of 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
Rated 5 out of 5
Good energy and enthusiastic as well as very knowledgeable. Thanks Mark.
Arjun
2018
5 out of 5
Rated 5 out of 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
Rated 5 out of 5
Great facilities, informative content and knowledgeable trainer with impressive delivery. Great Excel course, highly recommend. A++
Nicole
2019