Excel Intermediate Workshop
Overview
• 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
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
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
Venue
Join us online, from the comfort of your home or office.