Which One of The Following BEST Describes YOU?
Choose from the three options below the one that best describes your need
#1 "I want to organise an ONSITE WORKSHOP for our business!"
#2: "I'm looking for GREAT online courses!"
#3: "I'm looking for a PUBLIC workshop that I can enrol on!"
Do you find yourself spending way too much time reformatted data before it can be useful?
Ever had someone tell you, "you should be using VLOOKUP to do that"?
What about Pivot Tables? Have you heard how amazing they are for quickly analysing and reporting on your data?
If you have answered "yes" to any of these questions...this course is perfect for you!
Guided learning, covering only what you need. Not only will you become a proficient level 3 user of Excel, you will also learn how to avoid those scary 'gotcha' moments so that you are fully supported after the training! And if you need assistance after the learning, all you need to do is email and we'll be right there to help.
The questions, feedback and suggestions from the many, many people who have completed this workshop have helped hone this learning so that it really works. We know just what you need to know to have you working confidently in Excel. No waffle and no 'technical-speak'. No wasting your time!
You're fully supported on-line and off-line with your workbook, a print copy of the learning, along with file downloads for every exercise we cover together. Use these to practice during the learning, and to refer to for support after the training.
Need proof of your Continuing Professional Development (CPD)? On completion of the workshop, by request, we will send you a “Certificate of Attendance” confirming your participation and the duration of the training session.
"This was a great course"
I will save 1 to 2 hours a day and additional time for my team as I will be running them through some of the content. Thank you!! This was a great course.
"I learnt lots!"
The accessible language used and explanations was what I liked most about the course. I spend most of my day in Excel so the quick tips will save me hours of time a week. So impressed with how the whole group went at a steady pace despite different levels. Sharyn, you're a star! Very enjoyable and I learnt lots!
National Sales Manager
"Your training style is wonderful
Thank you so much once again for the training yesterday. Feedback from the team is all very positive. Your training style is wonderful, and even the members of the team who probably considered themselves as capable Excel users had their minds blown a number of times.. which is awesome!
The questions, feedback and suggestions from the many, many people who have completed this workshop have helped hone this learning so that it really works
Become a VLOOKUP WHIZ!
In this module, not only will you learn how to create VLOOKUP functions, you will learn how to identify common problems that prevent VLOOKUPS from working.
Data can be quirky! You'll learn how to fix problems by preparing your data so that it will work with a VLOOKUP function. AND you'll learn the tips, tricks, hacks and complementary functions that will have you creating VLOOKUPS that rock!
The Table feature in Excel offers so many time-saving benefits.
Create dynamic, multi-functional lists so that you never have to reset your ranges again.
Learn how to use Tables to name these dynamic ranges and insert them into your formulas. AND how to use Tables and Pivot Tables together to save time resetting ranges. So great!
You may have heard about them...seen them...even attempted to create one .
Pivot Tables aren't that scary when you are shown the best way to create them.
Learn how to consolidate your data quickly into POWERFUL reports.
It changes your life!
AND, learn how to avoid the 'gotchas' that Pivot Tables can offer up (yikes!)
About our trainer
Sharyn has been training Microsoft applications for over two decades. She became the first certified Microsoft® MOUS Authorised Instructor in New Zealand, is endorsed by Microsoft® as a qualified Microsoft® Office Specialist . Sharyn’s unique approach to taking the “techie-speak” out of technology training has placed her as a preferred supplier to many of New Zealand’s leading organisations and Excel facilitator for Excel workshops delivered on behalf of the Auckland Chamber of Commerce.
Q: What is the duration of the workshop?
A: 3.5 hours
Q: Is this training suitable for the Mac version of Excel
No, sorry. Even though you would most likely learn a lot that would be applicable to the Mac version, the training has been created for the Windows version for PC only.
Q: What do I need to know before I attend?
As this is an intermediate level course the prerequisite is proficiency in creating, formatting, editing, saving and printing an Excel workbook. This includes the ability to create formulas and insert functions.
Q: Can you come onsite to deliver the training?
Absolutely! We can bring the training to you. That’s right! We come onsite to your place of work on a day and time that works for you. Avoid traffic and parking hassles and learn at work. And if you don’t have a laptop, we can lend you one. We have 6 to share.
Q: Can you supply training laptops for us to use?
Yes! We have 6 to share. All have Microsoft Office 365 licenses.
Q: Do you have a limit to the number of attendees?
Yes. We have a minimum of 3, maximum of 12. Pricing is adjusted depending on the number of attendees (please see below).
Q: Do you offer 1-on-1 sessions?
No, sorry we don't. If you're looking for training just for you, please check out our public courses through the Auckland Chamber of Commerce and our online version of this workshop.
Q: What age is this appropriate for?
The training is aimed at adults so the minimum age we recommend is 18 years old. We look forward to hearing from you again when you are over 18.
Price is per person ex GST
Price is per person ex GST
Price is per person ex GST
*Sessions are 3.5 hours in duration. All bookings are subject to our Booking Terms and Conditions. Pricing is based on the number of attendees per session. Minimum of three attendees, maximum of 12.
If the dates you require aren't available please contact us at firstname.lastname@example.org