Learn the BEST Excel keyboard shortcuts. Perfect for Beginners and for those who want to save time and work smarter. It doesn’t matter if I’m delivering a Stage 1 or a Stage 3 Excel training course – when I’m demonstrating to the class I whip around the screen, format, select and modify and update using shortcut …
Questions? Email us at ask@excelatwork.co.nz
JOIN FREE! 'Excel at Work Insiders Group' for free tutorials, mini-courses, videos and blogs!
Microsoft® Office Training
Save time. Work smarter!
• No ‘techie’ speak • Polish existing skills or take them to a new level
• Go from absolute beginner to a confident, super proficient user in no time!
Microsoft Excel Training Courses
• Live Workshops • Coaching • Certified MS Office Specialist Instructor

Excel Essential Skills
Fast track to becoming a Confident, Super Productive user of Microsoft ® Excel.

Excel Organise and Analyse Data
Fast-track your Excel skills to the NEXT LEVEL.

Excel Combine, Analyse and Report
Take your skills up MORE than a few notches! Learn Lookup functions, Tables and Pivot Tables.
Microsoft Excel Online Courses
• Self-guided Learning • Available 24/7 • Start Learning Today!
We bring the training to you.
Live Workshops and Self-paced courses
Training that works for you...
Katie Li
HR Manager, Auckland
Put new skills into practice straight away
The course has been absolutely brilliant! Sharyn’s facilitation and teaching style is amazing as she teaches in a way that ensures the information is understood and the new skills are practiced straight away. Our guys were thrilled about the new skills they learnt and put them into practice straight away.
Penny Smith
Village Manager Hillsborough Heights, Metlifecare
Already applying their knowledge
Just want to say a big thank you for the day, the delivery and the content. The referral forms all speak for themselves and the team are already applying their knowledge.
Tony Hayes
General Manager, Auckland
Excellent engagement and training style
Not an easy subject matter to instruct on, but your style is perfect.
Rachael Stevenson
Alexander Dorrington Lawyers, Shortland Street, City
It was invaluable!
Thank you so much. I really meant it when I said it was invaluable. Just the simple tools you gave us, like LEFT and TRIM etc are so useful, let alone the amazing things we’ll be able to do with VLOOKUP and TEXT etc. Very exciting!
Craig Williams
Country Manager, New Zealand
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!
4.8 out of 5 STAR RATING!
We asked our learners to rate the quality and relevance of what they learned.
Here’s what they shared with us…
We’re HAPPY with that!
* these figures are based on feedback received from learners from Jan 2019 to Oct 2019.
5 stars is Excellent, 4 Very good, 3 Good, 2 Satisfied, 1 Fair.
Questions? Contact us today!
5 Reasons why your Excel filter may not be working
Are you are having a few hassles when filtering? Is the filter not working properly or as you would like it to? Here are some reasons why your Excel filter may not be working. Excel has an expectation that you have prepared your data to meet some basic layout standards before you use filter. Get these right and …
Excel – How do I change a Pivot Table back to the classic (version 2003 and earlier) display?
Learn how to change a Pivot Table back to the classic display of version 2003 and earlier. If you were familiar with Pivot tables in Excel versions prior to Excel 2007 you will be very used to the classic display of working with the blue lines of the Pivot Table and the ability to drag and …
Excel – Using VLOOKUP to compare two lists
If you want to save yourself a huge amount of time when reconciling data, learn how to use VLOOKUP to compare two lists or columns of data. Years ago the Training and Development manager of a large organisation invited me to spend some time in their Accounts department in order to observe how the Accounts team …
Excel – How do I merge cells within a range that is formatted as a Table?
PROBLEM: when I use “Format as Table” to format a range the “Merge and Center” button becomes inactive and I can no longer merge cells. Why?SOLUTION: the Table format will stop the merging of cells. However there is a work-around. The Format as Table command can be used to quickly apply a professional format to a …
Excel – How can I create a list of Weekdays only?
This post has been updated and added to by Sharyn, November 2020. Need a list of weekdays only? Let’s look at four different options you that can use to create a list of weekdays only in Excel.Option #1: create a fixed list of weekdays only (no formulas required) The Auto Fill button allows us to quickly create …