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

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


Find Your Next Event

Thank you for joining us!

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