Excel Intermediate Workshop

January 21st, 2025 / Online

OVERVIEW

Unlock your productivity with intermediate Excel techniques for faster, more efficient results.

• Understand and use more advanced formulas and functions
• Tackle complex calculations and utilise time-saving shortcuts
• Optimise your workflow by automating manual tasks
• Analyse, format, and manage data using advanced 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

Data Management

- Working with multiple worksheets and workbooks

- Sorting and filtering data

- Data validation and error checking

- Text to Columns

- Data tables

Intermediate Formulas and Functions

- Logical Functions (IF, AND, OR)

- Xlookup and Vlookup functions

- Date and Time Functions

- Text Functions

- Dynamic formulas and relative cell reference

Data Visualisation

- Conditional formatting

- Charts and Sparklines

- Pivot tables

- Slicers and Timelines

Mandy Vyner Senior Microsoft Consultant Mandy Vyner Consultancy

GROUP DISCOUNTS

3 - 4 Delegates

10%

Discount

5 - 7 Delegates

20%

Discount

8 - 9 Delegates

25%

Discount

10 + Delegates

30%

Discount

PRICING

ENDS IN 10 DAYS

Rapid Action

Ends September 26

SAVE UP TO $600

PRICING & BOOKINGS >

Value Plus

Ends October 23

SAVE UP TO $400

Super Saver

Ends November 15

SAVE UP TO $200

Early Bird

Ends December 20

SAVE UP TO $100

VENUE

Online

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

EMAIL ME THIS

17th - 18th, September 2024

Online

Book Now

1st - 2nd, October 2024

Brisbane, Australia

Book Now

October 10th, 2024

Online

Book Now

October 14th, 2024

Brisbane, Australia

Book Now

14th - 18th, October 2024

South Brisbane, Australia

Book Now

October 15th, 2024

Online

Book Now

October 17th, 2024

Online

Book Now

November 7th, 2024

Online

Book Now

12th - 13th, November 2024

Hobart, AU

Book Now

13th - 14th, November 2024

Online

Book Now

26th - 27th, November 2024

Online

Book Now

26th - 27th, November 2024

Newcastle, AU

Book Now

5th - 6th, December 2024

Canberra, Australia

Book Now

5th - 6th, December 2024

Canberra, Australia

Book Now

Excel Intermediate Workshop

OVERVIEW

TRAINER

AGENDA

PRICING

VENUE

EMAIL ME THIS

Featured Events

Policy Officers Workshop

QLD Public Sector Grades AO 3-4 Essential Skills Workshop

Managing Psychological Safety Through Change

Thriving Through Change: Resilience, Performance & Mental Health

QLD Women in Leadership Summit 2024

Communication Skills for Scientists Workshop

Professional Writing Essentials for Government

Managing Workplace Psychosocial Risks for Government

TAS Women in Leadership Workshop

Intermediate Power BI Workshop

Project Managers Leadership & High Performance Workshop

NSW Women in Leadership Workshop

ACT Women in Leadership Workshop

APS6 to EL1: Managing Performance & Difficult Conversations

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.