Excel Intermediate Workshop

October 22nd, 2025 / Online

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

09:00 - 16:30

Excel Intermediate Workshop

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

Rapid Action

DISCOUNT ENDED

SAVE UP TO $600

ENDS IN 7 DAYS

Value Plus

Ends July 18

SAVE UP TO $400

PRICING & BOOKINGS >

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

14th - 28th, July 2025

Online

Book Now

22nd - 23rd, July 2025

Darwin, Australia

Book Now

July 22nd, 2025

Online

Book Now

July 28th - August 1st, 2025

South Brisbane, Australia

Book Now

July 28th, 2025

Online

Book Now

11th - 15th, August 2025

Sydney, Australia

Book Now

13th - 15th, August 2025

Online

Book Now

25th - 29th, August 2025

South Bank

Book Now

2nd - 3rd, September 2025

Online

Book Now

15th - 19th, September 2025

Melbourne, AU

Book Now

September 25th, 2025

Online

Book Now

Women in Agribusiness Leadership Summit 2025

20th - 24th, October 2025

Melbourne, AU

Book Now

November 18th, 2025

Online

Book Now

2nd - 3rd, December 2025

Online

Book Now

Excel Intermediate Workshop

OVERVIEW

TRAINER

AGENDA

PRICING

VENUE

SHARE AGENDA

Featured Events

Adaptive Leadership Skills Workshop

NT Women in Leadership Workshop

Professional Writing Essentials for Government

Women in Healthcare Leadership Summit 2025

Navigating Difficult Conversations

Women in Leadership Summit 2025: Retail & FMCG

Data Visualisation Workshop

QLD Women in Leadership Summit 2025

Neurodiversity for Managers & Leaders Workshop

Women in Leadership Summit 2025: Banking & Financial Services

Finance for Non-Finance Professionals Workshop

Women in Agribusiness Leadership Summit 2025

Negotiation and Influence Skills Workshop

Critical Thinking & Problem Solving Workshop

Find Your Next Event

Thank you!The event agenda is on its way to your inbox.

Thank you for joining us!

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

Thank you!
The event agenda is on its way to your inbox.