Taking your managing, analysing and

reporting skills to the NEXT LEVEL!


Excel Stage 3 Course Online

Do you find yourself spending 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 data? Keen to learn how to use them so that you can confidently create reports, and understand PivotTable reports created by other people?


Are ready to take your skills to the NEXT LEVEL in Excel?


If you have answered “yes” to any of these questions… this course is perfect for you!

Sharyn Baines

Hi, I'm Sharyn Baines,

Certified Microsoft® Office Specialist 

for Excel at Work

This course does a deep-dive into some powerful, time-saving Excel features, covering topics that my clients continuously ask me to cover when I'm delivering workshops.


If you are serious about wanting to improve your skills in Excel you will benefit hugely from knowing how to...

  • confidently import and export data
  • master using Lookup functions to combine and cross-reference data
  • prepare data so that it can easily be used in formulas and reports
  • use Tables to reference dynamic ranges - no more having to reset your ranges
  • quickly consolidate and analyse data into meaningful PivotTable reports and PivotCharts
  • confidently work in existing files that include all the above

These fantastic features are a MUST to have in your Excel 'tool-box'. 


Gaining confidence in how to use these features AND understanding how others have used them to create powerful formulas and reports moves your skills up more than a couple of notches!


If you're already knowledgeable in the topics covered in our Excel Essential Skills course and our Excel Organising and Analysing Data course, and you're ready to fast-track your skills to the NEXT LEVEL, I'd love to help.


Let me guide you through each topic, showing you how to get the best out of each feature AND how to avoid the many 'gotcha' situations that I have seen so many people fall into.


Sign-up today! I can't wait to start you on your journey.

Introducing

'Excel Combine, Analyse and Report - Stage 3'

online course...the NEXT-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 6-Part Course:

9+ hours of video learning

Includes 80+ step-by-step video tutorials and hands-on guided exercises, covering only what you need. Not only will you become a proficient level 3 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

Complete the course and receive a 'Certificate of Completion' to display on your wall and in your resume!

  MODULE #1

Need to import csv or txt files into Excel?

Let me show you some tips and hacks to ensure you import only what you need, formatted how you need it.


Topics Covered

What is a text file?

Controlling csv and txt file imports

Saving text files

Exporting data as a text file

  MODULE #2

Learn how to create formulas using Excel's most popular Lookup functions, e.g. VLOOKUP, along with  a fist-full of tips, hints and complementary functions that will have you creating look-ups that rock!

Topics Covered

Cross-referencing data using the VLOOKUP function

Functions that are commonly used with Lookup functions

HLOOKUP

INDEX and MATCH

XLOOKUP

VLOOKUP vs XLOOKUP

XLOOKUP features

  MODULE #3

Data can be quirky! Prior to using many Functions and Reporting features in Excel your data needs to be 'fit-for-purpose'. Learn how to prepare your data so that it's ready-for-duty!

Topics Covered

Identify and remove duplicate records

Change numbers formatted as text back to numbers

Join the content of several cells into one cell

Split a single column of data into several columns

Pull data using the LEFT, RIGHT, MID and LEN functions

Quickly remove unwanted text and unwanted spaces inside of cells

Work with leading zeros

Use CONCAT, CONCATENATE, TEXTJOIN and string formulas to join cell content

  MODULE #4

The Table feature offers so many time-saving benefits. Create dynamic ranges, and multi-functional lists so that you never have to reset your ranges again. So great!


Topics Covered

Insert Tables

Format and rename Tables

Reset your Table range

Subtotal your Filtered data

Filter using Slicers

Use Table references in calculations

Convert Tables to normal ranges

  MODULE #5

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.

Create powerful reports quickly.  It changes your life!

Topics Covered

Understand Pivot Table components

Insert a Pivot Table

Use Recommended PivotTables

Summarize data using multiple fields

Manage Grand and Subtotals

Create custom named fields

Control how data is summarized

Control number formats

Filter using Slicers and Timelines

Create Report Filters

Group data

Create Calculated Fields

Format Pivot Tables

Reset and Refresh the Pivot Table


  MODULE #6

You've imported the data, prepared it, cross-referenced it, pulled it into a Pivot Table report, now let's display it graphically in a Pivot Chart, ready for your Word report or PowerPoint Presentation - all in a couple of clicks.

Topics Covered

Create a Pivot Chart

Changing the chart design and layout

Adding chart elements

Format a Pivot Chart

Create a Combo chart

Start working smarter and saving time!

Here's what you WILL experience....

So here’s what you’ll find in your 'Excel Combine, Analyse and Report' learning.

Guidance on topics that are perfect if you are wanting to work smarter and save time in 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 at this stage in your learning, 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...

"It was invaluable!"

Thank you so much. I really meant it when I said it was invaluable. Just the simple tools you gave, like LEFT and TRIM etc are so useful, let alone the amazing things I’ll be able to do with VLOOKUP and MATCH and INDEX etc. Very exciting.

Rachael Stevenson

Practice Manager


"Saved me a couple of hours a day" 

Really useful course. There was not a second I felt like I was wasting my time.


Roman Zyuzin

Analyst

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

Craig Williams
National Sales Manager

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!

Sharyn Baines
Excel Stage 3 Online Course

Your Excel Combine, Analyse and Report Workbook

It's no secret that we often need to refer back to our notes when steps are a little more complex, right?

When I'm learning something new 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
Excel Stage 3 Certificate

Your Certifcate of Completion

Once you’ve completed the learning you certainly deserve acknowledgement for your hard work so go ahead and request your Certificate of Completion to pop on your wall or in your resume.


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 Business Chamber (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

"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. Sharyn, you're a star! Very enjoyable and I learnt lots!

Rachel Alcorn

Human Resources

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


Bridget Armstrong
Logistics

  • New Zealand (NZD)

  • All other currency

Get Access to 'Excel Combine, Analyse and Report' Today!

The content in this course is close to the equivalent of 3 of my workshops...

That's over $900+GST  of value!

Get it now for only $900$697  *$347 

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 & Stage 3 Bundle deal

Purchase 'Excel Stage 1' , 
Excel Stage 2' AND Excel Stage 3 as a bundle deal.

12-month subscription 

26+ hours of learning for just

$497 

exc GST (save $444)


Sharyn Baines

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!


Sharyn


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. 

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