Microsoft Excel: Complex Functions and Automations

Work smarter with powerful Excel tools that save time and boost accuracy.

In this hands-on session, you’ll learn to use advanced Excel functions like IF, SUMIF, and VLOOKUP, along with conditional formatting to automate routine calculations. Ideal for small business operators who want to reduce manual data entry, create efficient workflows, and confidently present accurate figures to accountants, partners, or stakeholders.

Presented by Marianne Tansley.

This session is the third in a three part series:

• Session 1: Microsoft Excel: Beginner

• Session 2: Microsoft Excel: Making your data more accessible

About Marianne

Marianne Tansley founded Thrive Admin Services to help others learn from her experiences as a seasoned corporate administrator and Executive Assistant, and to provide common-sense practical support and solutions to everyday workload problems. Inspired by her own journey, Marianne focuses on Microsoft 365 and general systems and process improvements, aiming to help frustrated business owners to level up and systems-proof themselves to be able to focus on the doing part of their to-do list!

Eligibility Requirements

We encourage potential participants to review eligibility requirements before registering. Eligibility requirements include:

• businesses with under 20 Full-Time Equivalent (FTE) employees

• be a Queensland, Northern Territory or Western Australian-based business

• hold an active Australian Business Number (ABN)

This workshop is presented as part of the Digital Solutions Program.
Please note by continuing the registration process you acknowledge and agree your information will be shared with the Commonwealth Department of the Treasury and the Commonwealth Department of Industry, Science, and Resources for program evaluation and reporting purposes.