Microsoft Excel Advanced | Melbourne | Fri 4 Dec 2026
$360 (excl. GST)
Microsoft Excel Advanced — Advanced level, 1 Day, Melbourne. Starts Fri 4 Dec 2026.
Please Note: All of our in-person public courses are hosted at wheelchair-accessible venues. If you require any specific assistance, please contact learn@3grow.net to discuss this prior to booking and we will do our utmost to help.
Course Code: EXLADV
Duration: 1 Day
Overview
This one-day course covers aspects of Microsoft Excel that goes well beyond building basic workbooks, including workbook automation and productivity features. Participants will learn advanced Excel techniques in a range of areas such as worksheet and workbook consolidation, data validation, PivotTables and Pivot Charts, Lookup and Reference Functions, Linking Data, Financial Functions, Recorded Macros and much more.
Audience
This course is intended for experienced Microsoft Excel users who wish to extend their knowledge and skills beyond building and formatting simple workbooks. Upon completion of the course, students will have learned the skills to able work with Excel’s advanced data analysis tools, automate workbook operations and effectively use complex functions.
Prerequisites
Participants should have already completed both the Excel for Beginners course and Excel Intermediate course before attending this course, or have Excel skills up to the intermediate level course.
Module List
-
Module 1: Setting Excel Options
-
Module 2: Lookup Functions in Excel
-
Module 3: Text Functions in Excel
-
Module 4: Financial Functions
-
Module 5: Information Functions
-
Module 6: Complex Formulas
-
Module 7: Goal Seeking
-
Module 8: Data Linking in Excel
-
Module 9: Data Consolidation
-
Module 10: Protecting Data
-
Module 11: Summarising and Subtotalling
-
Module 12: Grouping and Outlining
-
Module 13: Pivot Tables
-
Module 14: Pivot Charts
-
Module 15: Pivot Table Features
-
Module 16: Recorded Macros
Combined with some well built labs, and it makes it easy to navigate the mess that can be SharePoint
I give 3grow a solid 5/7, would recommend!
I've tried 3 of the popular google results for Microsoft Training courses. All of these felt like a very rote course. so much so that the instructors couldn't answer questions outside of the scripted exercises.
Attending 3Grow was the diamond in the rough for this market. Russ had the most knowledge and human-interface of M365, particularly sharepoint.
3Grow is the only M365 training provider in will recommend.
I will definitely be attending more training and have recommend other from the company to attend relevant training sessions.
As Australia’s only Microsoft 365-specialist training provider, at 3grow we take great pride in delivering quality Microsoft 365 training courses and workshops.
Our courses are designed to meet the needs of all involved in the full Microsoft 365 spectrum, from end users to developers and IT administrators, offering course across SharePoint, Power Apps, Power Automate, Microsoft Teams, Power BI, and more.
The public courses listed on Humanitix are ideal for organisations looking to upskill up-to 4 attendees; for larger groups or to find out how we can deliver a customised training program, get in touch via learn@3grow.net