Excel Advanced: Automation and Power Tools

Master Microsoft Excel online and automate your workflow with advanced Excel tools like INDEX-MATCH, XLOOKUP, Power Query, and Macros!

This online Excel Advanced course is ideal for experienced Excel users looking to develop automation and data analysis expertise. Learn how to build complex formulas, analyse large datasets, and automate repetitive tasks using Excel VBA, Power Query, and advanced functions. Perfect for professionals, analysts, and managers who want to make data-driven decisions efficiently with Microsoft Excel training in Sydney.

Learning outcomes

By the end of this online Microsoft Excel course, you will have enhanced your career prospects by :

• Create and apply advanced formulas using nested functions.
• Use lookup functions such as VLOOKUP and XLOOKUP to extract data efficiently.
• Apply financial functions like PMT to perform loan and payment calculations.
• Use Goal Seek to perform what-if analysis and achieve target results.
• Work with unique and sort functions to clean and organise data.
• Apply advanced filters to extract specific datasets.
• Use subtotals and outlining to summarise large data sets.
• Build and manage data tables and slicers for dynamic reporting.
• Create and analyse PivotTables and PivotCharts for data insights.
• Design dashboards and apply Power Query basics for automated data management.
• Record and edit macros as an introduction to VBA automation.
• Manage workbook templates and apply security measures to protect sheets and files.
• Customise Excel settings and interface for improved productivity.

Course content

What will be covered in this online Microsoft Excel course?

• Advanced formulas and nested functions
• Lookup formulas (vlookup, and xlookup)
• Financial functions (pmt function)
• Goal seek
• Unique functions (unique and sort fx)
• Advanced filters
• Subtotals and outlining
• Data tables and slicers
• PivotTables and PivotCharts
• Dashboards and Power Query basics
• Recording and editing macros (Intro to VBA)
• Templates, security (protecting sheets/books)
• Customisation of Excel

Intended audience

Who is this online Microsoft Excel course for?

This course is designed for experienced Microsoft Excel users who have completed the Excel Intermediate: Functions and Data Analysis course or already possess equivalent skills.

Online Course

This course is now delivered online via Zoom, offering the same high-quality instruction and interactive learning experience as our in-person classes. A Zoom link and instructions will be provided before the course begins.

Course Materials

What You’ll Need for Your Online Class:

• Software required: Microsoft Office 365 or Office 2016 and later
• Your own laptop or computer capable of running Microsoft Excel.
• HDMI cable and an additional screen for a dual monitor setup (recommended).
• Please note: The tutor teaches using Windows, however Mac users are welcome to join. Some shortcuts and functions may differ slightly between operating systems.

Additional Information

This online class is suitable for both Windows and macOS users, as Microsoft Excel functions similarly on both platforms. Make sure your computer meets the system requirements for Microsoft Excel to ensure a smooth experience.