Take your skills up MORE than a few notches!
Become a Confident, Super Productive
'high-end' intermediate user of Microsoft® Excel

~ Learn VLOOKUP, Tables and Pivot Tables ~

Which One of The Following BEST Describes YOU?

Choose from the three options below the one that best describes your need

Workshop

#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!"

Introducing our

'EXCEL COMBINE, ANLAYSE & REPORT - STAGE 3'

workshop...the NEXT-STEP in becoming a proficient user of Excel!

Do you, or your team, find you spend way too much time reformatting 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!

Onsite. We come to you!

  • That’s right … no travel or parking hassles because we come onsite to you on a day that works for you and your team. We travel all over the greater part of Auckland, from Orewa down to Pukekohe delivering group sessions. Need training laptops? Not a problem. We can bring laptops for you to use, no charge. We have 6 to share.

Here’s What You'll Discover in this Workshop:

Expert Guidance

Guided learning, covering only what you need to become a proficient in the topics in this course. Learners will also learn how to avoid those scary 'gotcha' moments so that they are fully supported after the training!  And if they need assistance after the learning, all they need to do is email and we'll be right there to help.

Content that works!

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 learners need to know to have them working confidently in Excel. No waffle and no 'technical-speak'. No wasting your time!

Support resources

Learners are fully supported during and after the workshop with a comprehensive workbook. A print copy of the learning, along with file downloads for every exercise we cover together. We use these to practice during the workshop, and they are super popular as a reference to support the learners after the training.

Certificate of Attendance

Need proof of your Continuing Professional Development (CPD)? On completion of the workshop, by request, we will send learners a “Certificate of Attendance” confirming their participation and the duration of the training session.

Here’s what people are saying about the course

Bridget Armstrong

Logistics

"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.

Rachel Alcorn

Human Resources

"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!

Craig Williams

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!

Booking is easy! Book online today!

Content that works...

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 

1

Module 1: VLOOKUP to cross-reference data

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!

2

Module 2: Using Tables

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!

3

Module 3: Pivot Tables

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!)


Download a copy of the Course Content sheet

About our trainer

SHARYN BAINES

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.

Sharyn Baines

Frequently asked Questions...

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 training laptops, we can lend you some. 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.


Dates GO QUICKLY so book an onsite workshop for you and your team TODAY!

3 to 4 attendees

Price is per person ex GST

NZ$

305.00

/person

8 to 12 attendees

Price is per person ex GST

$

265.00

/person

*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 ask@excelatwork.co.nz

Questions? Contact us today!

© 2019, Excel at Work Limited, All Rights Reserved | Privacy Policy | Terms of Use

Social media & sharing icons powered by UltimatelySocial