View Brochure REGISTER NOW!

Excel Intermediate Workshop


May 21st, 2026 / Online
SAVE UP TO $600
Discount ends in 39 days

OVERVIEW

Use Excel more efficiently and effectively to improve productivity

• Manage and manipulate data across worksheets and workbooks efficiently
• Apply intermediate formulas and functions to solve real-world problems
• Create clear, actionable visualisations, including pivot tables and charts
• Use Copilot to suggest formulas, summaries, and visualisation ideas

TRAINER

Mandy Vyner

Mandy Vyner is an IT professional with over three decades of experience in transformative technology training services, specialising in Microsoft Office solutions. She led successful change initiatives in various sectors, collaborating closely with clients to design precise training programs. With expertise in instructional design, coaching, mentoring, project and change management, Mandy Vyner excels in facilitating training across diverse industries with a proven track history in achieving outstanding results.

Senior Microsoft Consultant
The University of Sydney

AGENDA

Workshop

Data Management

- Working with multiple worksheets and workbooks

- Sorting and filtering data

- Data validation and error checking

- Text to Columns


Intermediate Formulas and Functions

- Logical Functions (IF, AND, OR)

- Lookup and Reference Functions (VLOOKUP, XLOOKUP)

- Date and Time Functions

- Text Functions

- Dynamic formulas and relative cell references

- Range Names


Data Visualisation

- Conditional formatting

- Charts and sparklines

- Data Tables

- Pivot tables


Prerequisites

Suitable for users comfortable with Excel fundamentals, including formatting, basic formulas, and simple data manipulation.

  • Mandy Vyner Senior Microsoft Consultant The University of Sydney

GROUP DISCOUNTS

5 - 9 Delegates

15%

Discount

10 - 19 Delegates

25%

Discount

20 + Delegates

35%

Discount

PRICING

ENDS IN 39 DAYS

Rapid Action

Ends January 23

SAVE UP TO $600

PRICING & BOOKINGS >
PRICING & BOOKINGS >

Value Plus

Ends February 19

SAVE UP TO $400

Super Saver

Ends March 27

SAVE UP TO $200

Early Bird

Ends May 01

SAVE UP TO $100





VENUE

Online

Join us online, from the comfort of your home or office.

SHARE AGENDA

Featured Events

Data Visualisation Workshop
Data Visualisation Workshop

19th - 21st, January 2026

Online

Book Now
Professional Writing Essentials for Government
Professional Writing Essentials for Government

January 21st, 2026

Online

Book Now
Adaptive Leadership Skills Workshop
Adaptive Leadership Skills Workshop

January 28th - February 11th, 2026

Online

Book Now
Power BI Fundamentals - Powering Up Your Data Insights
Power BI Fundamentals - Powering Up Your Data Insights

11th - 12th, February 2026

Online

Book Now
VIC Public Sector Women in Leadership Summit 2026
VIC Public Sector Women in Leadership Summit 2026

16th - 20th, February 2026

Melbourne, Australia

Book Now
Working Smarter: Planning & Time Management Skills
Working Smarter: Planning & Time Management Skills

February 24th, 2026

Online

Book Now
SharePoint Online Essentials for End Users
SharePoint Online Essentials for End Users

February 26th, 2026

Online

Book Now
Public Sector Microsoft Copilot Pro in Practice
Public Sector Microsoft Copilot Pro in Practice

March 16th, 2026

Sydney, Australia

Book Now
GovAI Summit 2026: AI in Action
GovAI Summit 2026: AI in Action

16th - 19th, March 2026

Sydney, Australia

Book Now
Root Cause Analysis Workshop
Root Cause Analysis Workshop

18th - 19th, March 2026

Online

Book Now
QLD Public Sector Women in Leadership Summit 2026
QLD Public Sector Women in Leadership Summit 2026

23rd - 27th, March 2026

South Brisbane, Australia

Book Now
The Agile Leader
The Agile Leader

26th - 27th, March 2026

Brisbane, AU

Book Now
Government Communication Skills for Impact & Influence Toolkit
Government Communication Skills for Impact & Influence Toolkit

26th - 27th, March 2026

Canberra, Australia

Book Now
Critical Thinking & Problem Solving Workshop
Critical Thinking & Problem Solving Workshop

5th - 6th, May 2026

Online

Book Now
WA Women in Leadership Summit 2026
WA Women in Leadership Summit 2026

9th - 10th, June 2026

Perth, Australia

Book Now
SA Women in Leadership Summit 2026
SA Women in Leadership Summit 2026

16th - 17th, June 2026

Adelaide, AU

Book Now

Find Your Next Event

Thank you for joining us!

Great! Keep an eye out on our updates and newsletters.