View Brochure REGISTER NOW!

Excel Intermediate Workshop


October 22nd, 2025 / Online
SAVE UP TO $600
Discount ends in 12 days

OVERVIEW

Use Excel more efficiently and effectively to improve productivity

• Understand and use more advanced formulas and functions in Excel
• Tackle complex calculations and utilise time-saving shortcuts
• Optimise your workflow by automating manual tasks
• Analyse, format and manage data using advanced Excel tools and techniques

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
Mandy Vyner Consultancy

AGENDA

Workshop

Module 1: Data Management

- Working with multiple worksheets and workbooks

- Sorting and filtering data

- Data validation and error checking

- Text to Columns


Module 2: 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 reference

- Range Names


Module 3: Data Visualisation 

- Conditional formatting

- Charts and sparklines

- Data Tables

- Pivot tables

  • Mandy Vyner Senior Microsoft Consultant Mandy Vyner Consultancy

GROUP DISCOUNTS

5 - 9 Delegates

15%

Discount

10 - 19 Delegates

25%

Discount

20 + Delegates

35%

Discount

PRICING

ENDS IN 12 DAYS

Rapid Action

Ends June 25

SAVE UP TO $600

PRICING & BOOKINGS >
PRICING & BOOKINGS >

Value Plus

Ends July 18

SAVE UP TO $400

Super Saver

Ends August 15

SAVE UP TO $200

Early Bird

Ends September 12

SAVE UP TO $100





VENUE

Online

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

SHARE AGENDA

Featured Events

NSW Public Sector Women in Leadership Summit 2025
NSW Public Sector Women in Leadership Summit 2025

16th - 20th, June 2025

Sydney, Australia

Book Now
Women in Energy & Resources Leadership Summit 2025
Women in Energy & Resources Leadership Summit 2025

23rd - 27th, June 2025

South Brisbane, Australia

Book Now
Psychological Safety Toolkit for Managers & Leaders
Psychological Safety Toolkit for Managers & Leaders

June 24th, 2025

Online

Book Now
Public Sector Women in Leadership Summit 2025
Public Sector Women in Leadership Summit 2025

June 30th - July 4th, 2025

Canberra, Australia

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

July 3rd, 2025

Online

Book Now
Adaptive Leadership Skills Workshop
Adaptive Leadership Skills Workshop

14th - 28th, July 2025

Online

Book Now
Navigating Difficult Conversations
Navigating Difficult Conversations

July 28th, 2025

Online

Book Now
Data Visualisation Workshop
Data Visualisation Workshop

13th - 15th, August 2025

Online

Book Now

Find Your Next Event

Thank you for joining us!

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