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?
Introducing
'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!
MODULE #1
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.
Introducing Excel
Starting Excel
Excel screen components
The tabs you will need at this level of your learning
Workbooks and worksheets
MODULE #2
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.
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
MODULE #3
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!
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
MODULE #4
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.
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
COUNTA and COUNTBLANK functions
Using the Status Bar funtion results
MODULE #5
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.
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
MODULE #6
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.
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
MODULE #7
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!
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
MODULE #8
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.
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.
(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
shortcuts
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.
(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
Administration
"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
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?
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
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
LOW PRICE
Single Course Purchase
Purchase Excel Essential Skills - Stage 1 as a single course
12-month subscription
Get started today for just
$247
exc GST
Currently available in New Zealand and Australia only
SUPER value
Excel Stage 1 & Stage 2 'Bundle' deal
Includes
Excel Essential Skills - Stage 1 ($247) AND 'Excel - Stage 2' ($347) as a bundle deal.
12-month subscription
17+ hours of learning for just
$397
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
$497
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.
