__CONFIG_colors_palette__{"active_palette":0,"config":{"colors":{"62516":{"name":"Main Accent","parent":-1}},"gradients":[]},"palettes":[{"name":"Default Palette","value":{"colors":{"62516":{"val":"var(--tcb-color-1)","hsl":{"h":19,"s":0.7288,"l":0.5373}}},"gradients":[]}}]}__CONFIG_colors_palette__
Login to Online Courses

Questions? Email us at ask@excelatwork.co.nz

JOIN FREE! 'Excel at Work Insiders Group' for free tutorials, mini-courses, videos and blogs!

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

Are you wanting to fast track your way to becoming a more than proficient Level-1 user of Excel?

Maybe you're an absolute beginner...

Or, you may be self taught... or somebody (or many people) have shown you one or two things in Excel, but you know you still have knowledge gaps...

Or maybe you haven't used Excel in a while and you're in need of a quick refresher.

If any of these sound like you... this course is perfect for you!

Hi, I'm Sharyn Baines,

Certified Microsoft® Office Specialist 

for Excel at Work

I've been training Excel for over two decades (I know!)

And it doesn't matter which industry I train for, the size of the business or the job role of the learner, I see the same fundamental tools used in Excel (the ones I cover in this course). Without a doubt, these Excel skills are a MUST to have in your 'tool-box'.

However it can be a little intimidating and majorly time-consuming to try to learn Excel without guidance.

What if you're missing a key understanding? A fundamental step that could have a huge impact on the quality and accuracy of your work?

That's where I can help.

Let me fast-track you to a place where you can confidently work in Excel.

Where you will avoid messing up calculations and having to ask for help from others.

I don’t know about you but asking for help once is normally fine. But when you have to ask multiple times for help it can make you feel embarrassed and like you are imposing on the other person.

But it doesn't need to be like this...

How would you like to CONFIDENTLY work in shared files AND confidently create your own files?


'Excel Essential Skills - Stage 1'

online course...the FIRST-STEP in becoming a proficient user of Excel!

Click the button below to secure your place NOW!

Money back guarantee. 12-months access.

Become a confident, proficient user of Excel!

It’s no secret that improving your Excel skills ultimately saves you time and increases your confidence.

Better Excel skills allow you to add a professional edge to your business documentation, and it improves your output, which is always a bonus right?

Additionally, I want to quickly mention the ripple effect. When you can confidently use Excel you can bless others. We see it all of the time. When you know what you’re doing, you work more efficiently, which always has a positive impact right?  And you can pass on to others those little Excel gems of knowledge that save so much time… the gems that I'll share with you in the training.

AND... I think it goes without saying, having Excel skills listed on your resume makes you a sought-after candidate!

Claim your place today

What You'll Discover in this 8-Part Course:

8+ hours of video learning

Includes 50+ step-by-step video tutorials and hands-on guided exercises, covering only what you need. Not only will you become a proficient level 1 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 during the learning, all you need to do is email and I'll be right there to help.

Content that works!

The questions, feedback and suggestions from the many, many people who have done this course have helped hone this learning so that it really works. I know just what you need to know to have you working confidently in Excel. No waffle and no 'technical-speak'. No wasting your time! And if you complete the training and aren't 100% happy, just let me know and I will happily give you a refund.

Download your support files

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

Gain a Certificate of Completion and a Certificate of Achievement

Not only will you receive a 'Certificate of Completion', you will have the opportunity to take a friendly quiz to test your new knowledge and gain a 'Certificate of Achievement' to display on your wall and in your resume!


Excel can be a little overwhelming and bit intimidating when you first get into the application. In this module you will learn how to start Excel and work with only the areas you need at this stage of your learning journey.

Topics Covered

Introducing Excel

Starting Excel

Excel screen components

The tabs you will need at this level of your learning

Workbooks and worksheets


Entering data is easy when you know how.  Trying to work it out yourself can cause all kinds of problems. In this module you will learn the tips and tricks of entering and updating data, and how to avoid data entry frustrations.

Topics Covered

Entering Data

Selecting and moving around the workbook

Entering data into the worksheet

Deleting and replacing data

Using Undo and Redo

Spell Check

Overlapping data

Working with columns

Adjusting the column width

Making changes to the data

Using AutoComplete


Learn how to be the 'boss' of your files. Master the many ways you can save your work, close and open files, delete and rename them AND how to avoid many 'gotcha' situations that can have your heart racing if you're unaware of them!

Topics Covered

File Operations

Saving a file

Saving your file for the first time

Using Save As to make a copy of an existing file

Closing a file

Starting a new workbook (file)

Opening an existing workbook

Deleting a file you no longer need

Current or active workbook

Using AutoSave


Understanding how to create calculations and read other people's calculations is a fundamental and essential skill to have if you want to be a proficient user of Excel. Learn how to confidently create  formulas and create common math functions that are free from error.

Topics Covered

Performing Calculations

Different data types

Creating calculations

Checking cell content using the Formula bar

Creating a formula - step-by-step

Calculating percentages

Calculating GST

Copying formula

Using functions

SUM function

AVERAGE function

MAX and MIN functions

COUNT function


Using the Status Bar funtion results


You have a worksheet full of data and now you want to make modifications to it. In this module you will learn how to change the layout of the worksheet, copy calculations , move and copy data and link data between worksheets.  This module is NOT TO BE MISSED as it contains so many 'gotcha' and 'ah-ha' moments.

Topics Covered

Modifying the worksheet

Inserting, deleting and hiding rows or columns

Search the workbook using Find

Copying calculations

Creating an absolute reference

Moving and copying information

Moving and copying using the mouse pointer

Copying an entire worksheet

Deleting a worksheet from a workbook

Using Paste Link to link data

Identifying linked cells

Replacing formulas with values


Your data can look very 'black & white', very plain and somewhat boring without formatting. Learn how to make your data pop! Add some pizzazz to your report AND learn why understanding number formatting is essential. You'll also learn what to look out for when working with already formatted cells. 

Topics Covered

Formatting in Excel

Understanding Number formats

Avoid Number format 'gotchas'

Font and Alignment formatting

Merged & Center options

Copying formatting only

Format Painter tool

Removing formatting from a cell


OK... so you have your data laid out beautifully, your calculations are all 'on-point'. Your formatting is outstanding... so how come you can't print it? Learn all of the 'gotcha's' of printing and how to avoid them so that you can print your masterpiece with ease!

Topics Covered

Previewing your work before printing

Setting up the worksheet for printing

Inserting a page break

Selecting what will print

Print column headings at the top of each page

Adjusting preset print settings

Setting a Print Area

Additional print settings


The Sort and Filter features of Excel are powerful in their ability to enable you to manipulate lists of data and keep track of information in an orderly fashion. Learn how awesome these tools are AND what to avoid (so as to avoid a 'train-wreck') when using them.

Topics Covered

Introduction to sorting data

Avoiding BIG sorting errors

Using the Sort buttons

Using the Data Sort command

Introduction to filtering data in a list

Using Filter options

  BONUS  #1 Percentages

Understanding the formulas used to calculate percentages will help you tremendously. This BONUS module is dedicated to teaching you how to calculate percentages like GST, margins, increases and differences.

Topics Covered

(Template download available for each topic)
Calculating GST
Gross Profit Margin
Amount after % increase
Calculate % of Total
Calculate 1 figure as a % of another

  bonus #2

In this BONUS module you will learn the best keyboard and mouse shortcuts to work smarter and SAVE TIME. Download your 'Best Excel Keyboard Shortcut' cheat-sheet' and keep it handy.

Topics Covered

(Cheat Sheet download available)
Navigation shortcuts
Selecting shortcuts
Working quickly shortcuts
Shortcuts using your mouse

Add 'Microsoft Excel' to your resume!

Here's what you WILL experience....

So here’s what you’ll find in your 'Excel Essential Skills' learning.

Guidance on topics that are perfect if you are just starting out with Excel or needing a refresher AND you'll learn how to avoid the many 'gotcha' situations that Excel can deliver. I'm not having you go through that agony!

Here's what you WON'T experience....

Here’s what you won’t get. You won’t find anything that is super advanced or majorly "techie". No fluff, no overwhelm, you will only learn the topics you need to get started without the techie speak. I don’t want that for you. I want to guide you into becoming a confident, super productive user of Microsoft Excel with me offering you practical, straight forward guidance.

"The questions, feedback and suggestions from the many, many people who have done this course have helped me hone this learning so that it really works!"

What others are saying about the course...

"Specific and relevant"

Specific and relevant to my work.

Finally, I don't have to rely on others to do it for me!

Ian Erasmus

Business Development

"Really enjoyed the course"

Thank you – you are such a good teacher and are very clear, concise and practical. A lot of shortcuts that I didn’t know about too so was very helpful.

Vickie Furniss Receptionist

"Awesome teacher"

I knew the basics of Excel but learnt a lot more. Well worth doing. Workbook is great. Glad we can keep this to go back to.

Trudy Piercy 
Administration Manager

"Wonderful opportunity"

I am so appreciative and privileged to have worked through this new beneficial skill that I so needed to learn many many years ago and I have had this wonderful opportunity to have done this.  This is obviously not the end of learning all the wonderful things about Excel, it is the beginning :-) Thank you so much Sharyn.  You have been inspiring to say the least, it has been fun and of course rewarding.  I will endeavour to continue practising this worthwhile and beneficial skill.

Merrin Joseph

"Thank you for the course"

I want to thank you for all your help throughout the course. I already had Excel knowledge but in Spanish version and I was having difficulty in my new Job. With the course I learned all the vocabulary in English and now I'm feeling more confident and happy working in Excel.  Very happy with the course and the way how you taught me. Thanks :)

Alejandra Cardona-Sweney

"This course totally rocks"

Hi Sharyn

This course totally rocks! It is amazing, exactly what I was looking for, learning at my own pace and your videos are so clear and easy to follow, so THANK YOU!! :-)

Lorinda Mochrie

Financial Services Administrator 

Here's what I've put together for you...

Guidance and support from me

Register today and I'll be sending you an email with your login details and instruction on how to get started straight away.  

AND if you need help at any time I'm only an email away. I'm all about relationships, so reach out and let me know where you are at currently with Excel and where you want to be.  I want to deliver to you the BEST guidance I can, hassle free... I'm here to help!

Your Excel Essential Skills Workbook

It's no secret that we often need to refer back to our notes when we're just starting out, right?

When I'm learning I'm a prolific note-taker! 

That's why I've created a step-by-step workbook for you. It's a copy of the online learning in print form, with comprehensive notes, screen-shots, shortcuts and tips already created for you.

Just download and use it to cross-reference as you follow along with the training. Excellent for offline reference too. Keep a copy in your laptop bag or drawer at work. I had one lady tell me she kept a copy in her car, just so that she knew it was always handy!

Bite-sized sessions that fit into your schedule

No having to drive to a course, find parking and then sit in a room for 6 hours (or more). Make this learning fit into your schedule. No having to worry about being late to pick up the kids, sitting in traffic, or losing a full day at work.

Perfect if you're...

  • super busy
  • live out of town and can't get to workshops
  • don't want the hassle of travelling to a workshop
  • are a 'Soloprenuer' and don't have the time to be away from your business for a full day of learning
Excel online course

5 x 'done for you' template calculators

Why spend time recreating when I have created these for you already? Not only that, I've put together BONUS videos to teach you how to use them.

  • 1 x Goods and Services Tax Calculator Template - calculate GST, GST inclusive and figures exclusive of GST in seconds.
  • 4 x Percentages Calculator Templates - calculate gross margins, percentage increases, percentages of set values and percentages of totals.

Your Certifcate of Completion  AND your Certificate of Achievement!

Once you’ve completed the learning you certainly deserve acknowledgement for your hard work so go ahead and print your Certificate of Completion.

But that’s not all! Test your new knowledge using the in-build friendly quiz. And if you answer incorrectly, that’s OK. The quiz will help you find the answer within the learning so that you can do a quick refresher, and then come back and try again. 

You can try as many times as you like and gain an awesome Certificate of Achievement to display on your wall or in your resume, wherever you like!  Oh, and it also prints your score on your certificate. So why not keep trying until you can claim that 100% score!

2 x super-handy 'Cheat Sheets'

Have the answers always on hand with these super-handy Cheat Sheets.

  • The Excel Essentials cheat sheet - a double-sided cheat sheet covering all the steps you need to know to create, save, format, modify and print an Excel workbook, including steps on creating formulas.
  • The Best Excel Shortcuts cheat sheet - 70+ shortcuts that will have you zooming around your workbook. These shortcuts are the kind that have your work colleagues asking, "wow, how did you just do that?"

"Thank you so much"

Hi Sharyn. Thank you so much for a wonderful online Excel session. Your teaching approach was wonderful, encouraging and calm and very clear (tone). You were very encouraging and precise on what is important to remember and learn.   Loved it and I have used my skills already which has made life much much easier. I thought I knew Excel well before this but there were so many new things I learned as well like Filtering. This is really cool. This is just one of the many things I learned. Thank you again.

Mati Itonga

Self Employed

Frequently asked Questions:

QUESTION #1: How  much time will this take?

QUESTION #2: How quickly can I get started?

QUESTION #3: What software and hardware do I need?

QUESTION #4: Is there a guarantee this training will work for me?

QUESTION #5: How long do I have access to the training?

QUESTION #6: Can't you get this type of training for free on YouTube?

QUESTION #7: Is there support as I go through the course?

QUESTION #8: What if I subscribe and find the course isn't for me?

QUESTION #9: Is this training suitable for the Mac version of Excel?

QUESTION #11: What age is this appropriate for?

QUESTION #12: Are the certificates endorsed by Microsoft?

QUESTION #13: I have other questions. How do I reach you?

Sharyn Baines

Meet your 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 and is a member of the Microsoft® Certified Trainer Alumni.

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

"Really helpful"

Sharyn was awesome.

Really helpful and knowledgeable. This is really going to help me with my work!

Samantha Irvine

HR Coordinator

"Invaluable Course" 

This is an invaluable course for anyone new to Excel.

I highly recommend Sharyn.

Candice Murphy Manager

"Your training style is wonderful"
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!

Craig Williams
National Sales Manager

  • New Zealand (NZD)

  • currency Converter

Get Access to 'Excel Essential Skills' Today!

The content in this course is more than I cover in 2 of my workshops...

That's over $700  of value!

Get it now for only $700$497  *$247 

Your subscription gives 12-months access to the learning. During this time you will receive any updates and additional resources added to the learning for free.

All resources supplied within the training are yours to keep forever.

*Price is in New Zealand dollars and is exclusive of Goods and Services tax.

If you are wanting to subscribe multiple people to this course or require a GST invoice to be supplied prior to enrollment, please contact us at ask@excelatwork.co.nz

Please note, this learning is for Windows for PC only and isn't suitable for the Mac version of Excel

SUPER value

Excel Stage 1 & Stage 2 'Bundle' deal


Excel Essential Skills - Stage 1 ($247)  AND 'Excel - Stage 2'  ($347) as a bundle deal.

12-month subscription

17+ hours of learning for just


exc GST (save $197)

Currently available in New Zealand and Australia only

BEST value

Excel Stage 1, 2 & 3 'Bundle' deal

Includes  Excel Stage 1 ($247) , 
Excel Stage 2 ($347) AND Excel Stage 3  ($347) as a bundle. 

12-month subscription

26+ hours of learning for just


exc GST (save $444)

Currently available in New Zealand and Australia only

Thanks for visiting this page! 

If you're still on the fence and still have questions, please email me at ask@excelatwork.co.nz.

I'd love to hear from you!

BUT, if you're ready to save time, work smarter and improve your understanding of Excel, sign-up now and claim your spot inside the learning.

And I look forward to connecting with you real soon!

Our 100% Satisfaction Guarantee

If you complete this course and feel it wasn't worth your investment, I've got you covered. Just let me know why and I will process your refund. Completing the course means you have completed all of the modules.