Short Courses


Microsoft Excel Advanced

About this Course

This course covers aspects of Microsoft Excel beyond building basic workbooks and deals with workbook automation and productivity features. Instructors teach advanced techniques in areas such as workbook and worksheet consolidation, data validation, lookup and reference functions, PivotTables, linking, Solver and macros.

Who should do this course?

TThis course is intended for experienced Microsoft Excel users who wish to extend their knowledge and skills beyond building and formatting simple workbooks. Upon successful completion of the course, students should be able to use Excel’s advanced data analysis tools and automate workbook operations.


Learners undertaking this course should have foundation computing skills including basic file managment.

BYO Device

Each participants is required to attend sessions with a laptop or suitable device with Microsoft Excel installed and ready to undertake learning. When available a laptop can be supplied for an additional fee.

Additional Learning

If you are jsut starting out with Excel try our these;

Limited Positions Available

Excel Expert


  • Advanced functions and formulas
  • Nesting Functions
  • Work with multiple worksheets and workbooks
  • Forecast data
  • Introduction to Pivot Tables and Pivot Charts
  • Introduction to VBA programming


Build on your Microsoft Excel to become the authority in your worplace. This course aims to expand your Excel skills by exploring some of Excels’ more advanced features to streamline workflows and automation techniques. Participants can build upon skills gained to eventually become an expert in Microsoft Excel and data automation. 

Contact us for more information 

“It was a great course that really helped me. I am much more confident.”
Andrew P
Andrew P.
“I was a real novice and the trainer help me feel very comfortable.”
Sammy A
Sammy A.
“Lovely teacher and course. I'm already planning to do the next one. Thank you."
Mi L.
Mi L.
  • All
  • Short Course

© 2023 AST Digital Pty Ltd – ABN 35653277537 – Contact us