Taking your managing, analysing and
reporting skills to the NEXT LEVEL!
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!
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.
'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!
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.
What is a text file?
Controlling csv and txt file imports
Saving text files
Exporting data as a text file
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!
Cross-referencing data using the VLOOKUP function
Functions that are commonly used with Lookup functions
INDEX and MATCH
VLOOKUP vs XLOOKUP
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!
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
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!
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
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!
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
Create Calculated Fields
Format Pivot Tables
Reset and Refresh the Pivot Table
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.
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.
"Saved me a couple of hours a day"
Really useful course. There was not a second I felt like I was wasting my time.
"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!
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!
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
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?
We suggest completing one module per week. There are 6 modules in total. Each module's duration differs. Some take approx 30 minutes. Others nearly 2 hours. I've given you approx timings inside the learning. These timings are an approximate duration for when you're following along with me. Trying the exercises unassisted and reviewing your work will all take additional time.
Obviously, if you have a little experience in the topic you may take a shorter amount of time.
And if the learning is entirely new to you it may take a little longer...
But it's self-paced, so you've got no pressure at all.
Don't forget, you maintain access to the training and on-going updates for a whole year. I understand that having the ability to redo topics and do quick refreshers when required lifts your confidence AND your output. That's why we have made the training accessible for a generous amount of time PLUS you'll be able to download your workbook, and exercise files and keep them FOREVER.
So take as little or as much time as you like, and just know you can go back and review any topic at any time while you have an active subscription.
QUESTION #2: How quickly can I get started?
If you subscribe and pay online your access will arrive in your inbox within 5 to 10 minutes! So as soon as you subscribe you can expect to have your login details extremely quickly. If you have requested a GST invoice be sent prior to enrolment we will let you know when to expect your login details to arrive.
Once you have your login you'll be able to get started as soon as you want!
QUESTION #3: What software and hardware do I need?
Firstly, you'll need a copy of the Windows version of Excel. That's the full desktop application, not the online version that is part of the Microsoft 365 offering. The online version doesn't have the full functionality that the desktop version of Excel has and even though you could try to follow along using the online version, it is quite different in parts and it may be a bit confusing for you.
The training is suitable for Excel 2010, 2013, 2016, 2019 and the latest desktop version of Excel for Microsoft 365 (formerly known as Office 365). In the videos I'm demonstrating using the Excel desktop version of Microsoft 365. If you're unsure of the version you have contact us and we'll see if we can help out.
Obviously you'll need an internet connection, which I'm pretty sure you have since you are reading this right now. If your computer can easily run a YouTube video it should be absolutely fine to run the training.
The training can be watched on your tablet or smartphone too. Great for quick refreshers. However, you will have the best experience using a desktop PC or laptop. Of course you can use a mixture of devices if you want to watch AND do at the same time! Watch on your iPad or phone and follow along with me in Excel on your laptop.
BTW, the training has been created for Windows for PC only and isn't suitable for Mac sorry.
If you would like to create a printed copy of the workbook PDF then access to a printer would be helpful. However, you can easily access printing services at a local printing service provider, for example, Warehouse Stationery offer great printing and binding services. So a printer isn't mandatory.
QUESTION #4: Is there a guarantee this training will work for me?
This learning is designed to give you the best guidance and support I can give. However, I cannot make you do the learning...you'll need to put the work in.
I can guarantee that you will be following the same learning that many, many people have gone through, with fantastic results.
BUT...they completed the entire course.
I totally understand that life gets busy and time just seems to whiz by.
And that's fine, but without putting the work in you will just stay where you are, nothing will change right?
So, if you're ready to make a change, this is definitely the time to invest in becoming a more confident, super productive you!
Our 100% Satisfaction Guarantee*
If you make your way through the training and then decide you didn't learn a thing I want to give you your money back. At Excel at Work we believe our success depends on your success. We want you to become a confident, super productive user of Excel. If this course doesn't meet that objective for you, send me an email explaining your reason and we will refund you! *The only thing we ask is that you have completed all of the modules BEFORE you contact us.
QUESTION #5: How long do I have access to the training?
Your subscription is contract free and will give you access to the learning for 12-months, plus you'll be able to download the workbook, and exercise files and keep them FOREVER.
While you are an active subscriber you will receive any updates to this course for free.
Please note: I don't offer 'life-time' access due to the number of updates and improvements I continually add to the training. Microsoft are making continual improvements to their software which I then put into the learning. To be able to bring you the best and most up-to-date training I need your on-going support.
QUESTION #6: Can't you get this type of training for free on YouTube?
There really are a crazy amount of free videos on this topic which you can easily access online.
The thing is, they are disjointed. It's hard to follow from a starting point to an end point... knowing you have covered all of the topics that will have you working proficiently in Excel. What if you miss a key element? A fundamental step that could have a huge impact on your understanding! And well, there are so many options it can be overwhelming.
AND, a lot the teaching doesn't come from people who have worked closely with many, many businesses and hundreds of learners and who possibly don't have the understanding of what you need to truly become proficient.
Even though the training is free you may find yourself wasting a HUGE amount of your precious time trying to join all of the topics together to make sense of the learning.
Best you join me where I can guide you, helping you improve and progress step-by-step, click-by-click, and where you can be confident you are covering those key topics that fast-track you to becoming a more proficient user of Excel.
QUESTION #7: Is there support as I go through the course?
Absolutely! You can email us any time you have a question. We're here to help!
QUESTION #8: What if I subscribe and find the course isn't for me?
If you make your way through the training and then decide you didn't learn a thing I want to give you your money back. At Excel at Work we believe our success depends on your success. We want you to become a confident, super productive user of Excel. If this course doesn't meet that objective for you, send me an email explaining your reason and we will refund you! The only thing we ask is that you have completed all of the modules BEFORE you contact us.
QUESTION #9: Is this training suitable for the Mac version of Excel?
No, sorry. Even though you would most likely learn a lot that would be applicable to the Mac version, the training has been created for the Windows version for PC only.
QUESTION #11: What age is this appropriate for?
The training is aimed at adults so the minimum age we recommend is 18 years old. We look forward to hearing from you again when you are over 18.
QUESTION #12: Are the certificates endorsed by Microsoft?
No – the certificate isn’t part of the Microsoft® certification stream. If this is what you are looking for please visit the Microsoft® Learning, certifications and exams page
QUESTION #13: I have other questions. How do I reach you?
You can reach me or a member of the Excel at Work team on firstname.lastname@example.org. We look forward to hearing from 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 Business Chamber (Chamber of Commerce).
Sharyn was awesome.
Really helpful and knowledgeable. This is really going to help me with my work!
"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!
"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.
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 email@example.com
Please note, this learning is for Windows for PC only and isn't suitable for the Mac version of Excel
For my friends outside of New Zealand...
Use the Foreign Exchange Calculator to calculate your price today
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.
Please note, this learning is for Windows for PC only and isn't suitable for the Mac version of Excel
Thanks for visiting this page!
If you're still on the fence and still have questions, please email me at firstname.lastname@example.org.
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.