Questions? Email us at ask@excelatwork.co.nz
JOIN FREE! 'Excel at Work Insiders Group' for free tutorials, mini-courses, videos and blogs!
• Live Workshops delivered Online and Onsite • Coaching • Certified MS Office Specialist Instructor
Fast track to becoming a Confident, Super Productive user of Microsoft ® Excel.
Fast-track your Excel skills to the NEXT LEVEL.
Take your skills up MORE than a few notches! Learn Lookup functions, Tables and Pivot Tables.
• Self-guided Learning • Available 24/7 • Start Learning Today!
Stage 1. Fast track from Beginner to a Confident, Super Productive user of Microsoft® Excel. Stage 1 & 2 'Bundle' offer available.
Stage 2. Fast-track your Excel skills to the NEXT LEVEL. Stage 1 & 2 'Bundle' offer available. Get started TODAY!
Stage 3. Take your skills up MORE than a few notches! Learn Lookup functions, Tables, Pivot Tables and Pivot Charts, and much, much more!
Fast-track your way to becoming a MORE than proficient user of Microsoft Excel with this Stage 1, 2 & 3 Bundle Offer. Sign-up and SAVE!
Katie Li
HR Manager
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, 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
Excellent engagement and training style
Not an easy subject matter to instruct on, but your style is perfect.
Rachael Stevenson
Practice Manager
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!
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 …
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 …
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 …
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 …
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 …
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 …