View Brochure REGISTER NOW!

Excel Intermediate Workshop


July 25th, 2024 / 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

Speakers


Mandy Vyner

Mandy Vyner is a seasoned 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

Partners


MSEW0724A logo
Become a Partner
Group Discounts

Pricing


Rapid Action

DISCOUNT ENDED

SAVE UP TO $600

Value Plus

DISCOUNT ENDED

SAVE UP TO $400

Super Saver

DISCOUNT ENDED

SAVE UP TO $200

Early Bird

DISCOUNT ENDED

SAVE UP TO $100

PRICING & BOOKINGS >
PRICING & BOOKINGS >




Venue


Online

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

Email Me This


Find Your Next Event

Thank you for joining us!

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