Screenshot of Excel spreadsheet using Power Query and PivotTables with chart visuals

Excel Advanced: Automation & 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.

Learning Outcomes

  • Create and apply advanced formulas using nested functions.
  • Use PivotTables, dashboards, and Power Query for high-level reporting.
  • Record and edit Macros to automate tasks and introduce VBA.

What You’ll Get

  • Live expert instruction via Zoom
  • Practical, real-world exercises and Excel templates
  • Certificate of completion

What to Bring

  • A computer or laptop with Microsoft Excel (Office 365 or 2016+)
  • Reliable internet connection and Zoom installed
  • Additional monitor (recommended)

Course Outline

  • Advanced formulas and nested functions
  • Lookup formulas (VLOOKUP and XLOOKUP)
  • Financial functions, Goal Seek, and data cleanup tools
  • PivotTables, PivotCharts, dashboards, and Power Query essentials
  • Recording/editing macros and intro to VBA

Schedule & Pricing

  • Start date: 25 March 2026 – 27 March 2026, 9:30am–12:45pm (Online)
  • Start date: 24 April 2026, 9:30am–3:30pm (In-person at Rozelle)
  • Price: $399

Details
3 hours 15 minutes

You will learn

  • Create advanced formulas using nested functions
  • Use PivotTables and dashboards for data analysis
  • Automate tasks with Macros and intro to VBA

You will get

  • Live Zoom instruction and Excel resources
  • Real-world exercises with templates
  • Certificate of completion

Appropriate for

Experienced Excel users, professionals, and analysts seeking to automate data workflow and advance spreadsheet skills.


Preparation

What to bring

  • Computer with Excel (Office 365 or 2016+)
  • Zoom installed with internet access
  • Additional monitor recommended

What to wear


Your Teacher
Sydney Community College

Sydney Community College

38 reviews

Sydney Community College is a registered charity with a voluntary Board of Directors

The College has a mission to offer innovative continuing adult education and training programmes that support individual efforts and facilitate sustainable social change.

We do this by:

  • Providing quality continuing adult education opportunities for people to build practical and theoretical skills and develop knowledge;
  • Leveraging from and developing community capacity and inclusivity;
  • Developing innovative affordable and accessible skills training programmes;
  • Partnering with like organisations to deliver learning opportunities for disadvantaged individuals and communities;
  • Partnering with all levels of government to deliver education policy objectives.

Terms

Cancellations & Refunds

If the organiser cancels the class:

You are entitled to a full refund.

If you can't attend the class:

You’re welcome to send someone in your place.

OR

  • A refund can be requested 10 days before class starts. An admin fee of AU$45.00 applies.

Terms & Conditions

At Sydney Community College, we know that plans can change unexpectedly. Whether it’s a shift in your schedule, a family emergency, or just a change of heart, we want to support you in the fairest way possible.  

At the same time, we’re a not-for-profit organisation that commits resources to running each class—so last-minute cancellations can significantly impact our ability to offer quality, affordable programs.

That’s why we’ve created a simple, transparent policy that balances your need for flexibility with our need to plan and deliver courses sustainably.  Our cancellation policy offers two clear options, depending on when you notify us:

Cancel More Than 10 Days Before the Course Starts – You can choose to receive a full refund, minus a $45 administration fee OR a non-refundable credit note valid for 12 months for the full value you paid for the course. This credit can be used towards any future course at the College. 

 Option 2: Cancel Within 10 Days of the Course Starting - You’ll receive a credit note valid for 12 months for 50% of the course fee you paid for the course. This credit can be used towards any future course at the College. 

Please note that both refund and credit options are only available before the course begins. Once the course has started—or if you decide to withdraw after it has commenced—no refunds or credits can be issued.  If you need to cancel your enrolment, just email us and we’ll take care of it based on the timelines above.

Have more questions about this class?

Tags:

Your Next Adventure Starts Here

Join thousands of learners exploring new skills and passions. Whether online or in person, our classes are designed to inspire, connect, and bring joy to learning. Start your journey today!

Explore classes
Your Next Adventure Starts Here