• 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
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
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
Rapid Action
DISCOUNT ENDED
SAVE UP TO $600
Value Plus
DISCOUNT ENDED
SAVE UP TO $400
Super Saver
DISCOUNT ENDED
SAVE UP TO $200
Join us online, from the comfort of your home or office.
26th - 27th, November 2024
Newcastle, Australia
26th - 27th, November 2024
Online
5th - 6th, December 2024
Canberra, Australia
5th - 6th, December 2024
Canberra, Australia
