Excel 
Intermediate Stage 2

Fast track your Microsoft Excel skills to the NEXT LEVEL

DURATION: 3.5 hours delivered live over Microsoft Teams or Zoom

Microsoft Excel Stage 2 tutor-Led Online course

excel Organise and Analyse Data

Are you fed up feeling like you’re just getting by with Excel? You know the basics, but you realise there must be a better, more efficient way of doing things. If you’re ready to take your skills to the next level and stop doing things the long and hard way, this course is perfect for you! Whether you’re looking to improve your productivity or impress your boss, you’ll learn the shortcuts and techniques to master Excel and work smarter, not harder. This Stage 2 course is perfect for you!

What you’ll learn:

  • Master the art of organising and analysing large data tables with efficient data tools, tricks and tips.
  • Organise and Analyse your data using Sort, Filter and Subtotal.
  • Learn how to fix and avoid “rubbish” calculations, and how to copy formulas perfectly.
  • Unlock a powerful set of tools and boost your confidence by mastering the Math, Statistical, and Logical Excel functions that are highly valuable in a business environment.
  • Learn to easily move, copy and update multiple worksheets at once
  • Link content from other cells, worksheets, or workbooks to save time and limit errors. Learn how to read linked formulas.

Working With Tables Of Data

  • Freezing titles so that they are still seen while scrolling
  • Prepare data for sorting and filtering
  • Sort lists of data, including applying sorting levels (a sort within a sort)
  • Instantly insert sub-total and total rows to a table of sorted data
  • AutoFilter -use set criteria to create custom filters
  • Filtering tricks that save you time!

Working With Multiple Worksheets/Workbooks

  • Tips for working with multiple worksheets to save time formatting, updating,
  • copying, moving and printing
  • Link information between worksheets and workbooks
  • Dealing with linked formulas – refreshing, opening the source data, unlinking

Formulas And Functions

  • Quick refresher on creating calculations in Excel
  • Understand why calculations can be displayed incorrectly.
  • Learn quick tips for copying calculations; absolute addressing
  • Learn how to insert, write and get help on functions in Excel
  • Find averages, highest value and lowest value using AVERAGE, MAX and MIN
  • Count how many items are in a range using the COUNT family of functions
  • Perform calculations only if set criteria are met using the IF function
  • Total a range including only values that meet a set criteria using SUMIF
  • Work with ranges that contain errors using the IFERROR and ISERROR
  • functions
  • Utilise today’s date in calculations using the TODAY function

Is this course right for you?

This course is definitely for you if:

  • Improve your output proficiency and accuracy analysing data
  • Master creating calculations and reading other people’s calculations
  • Become a pro at the popular Excel functions used in business
  • Reduce time spent cross-referencing and updating your data
  • You aim to progress to Stage 3, Analysing and Reporting in Excel
Book Now

Private to you and your business

This course is run for you and your business only, ensuring that you and your team will receive individualised instruction and the attention needed to grasp the material and excel in the learning fully.

learn online live

Whether you’re looking to train just you, a few employees or a whole department, I’ve got you covered. With this live online course, you can learn from the comfort of your office or home using Zoom or Microsoft Teams.

Streamline your workflow

Are inefficient methods holding you back? Learn how Excel training on the latest version can streamline your workflow and boost productivity.

Are you tired of googling for help?

Have you ever felt lost or overwhelmed by Googling for help? Discover a straightforward guided approach that ensures complete understanding.

Excel Organise and Analyse Data – Stage 2 Course

  • Duration 3.5 hours
  • Delivered online over Microsoft Teams or Zoom
  • Ask questions, get feedback and work through challenges in real time
  • Choose a day and time that works for you
  • Earn a ‘Certificate of Attendance’ on completion
  • Exclusive step-by-step workbook and accompanying exercise file downloads.

Don’t waste any more time on tedious Excel tasks – book a course today and watch your skills soar!

The course has been absolutely brilliant! Sharyn’s teaching style is amazing as she teaches in a way that ensures the information is understood and the new skills are practised straight away.
Kate li
HR Manager
Within minutes of starting Microsoft Excel Stage 2, I learnt something new that could have saved me so much time previously, and I continued learning throughout each session.
Meagan Walters
Planning Administrator
Sharyn was a great tutor, and the course was really helpful! It was easy to follow along, and I learned a lot. Would recommend if you are using Excel at work or even for your own benefit 🙂
Olivia mcgrifford
Administration Assistant
Easy and in layman’s terms!
Sharyn is an awesome presenter.


Blair Elliot
General Manager, Sales & Marketing
Spicers, Total Supply and Universal Packaging have been working with Sharyn for the past 9 years with great success. Each year when we complete our annual reviews there are always requests for Excel courses and Sharyn is our go-to. I collate all the requests and send them through to Sharyn, and she works her magic in the background, arranging times and courses and emailing participants to book them in. She makes the whole process seamless, from enquiring about the course through to the courses taking place. She is patient and accommodating when business gets in the way and changes have to be made, nothing is ever an issue.
The feedback after the courses is always exceptionally positive about Sharyn as a trainer, our team raves about her!!  She makes the topics easy to understand, remember and integrate into daily work life. Those who have done the courses are definitely more proficient!
If you are looking to do an Excel course yourself, or looking to book your team, we cannot recommend Sharyn enough, she is a brilliant trainer and super easy to deal with.
Kelly Hughes
HR Manager, Spicers NZ

Course Calendar

I offer private, online, live courses tailored specifically for you or your team. I don’t run public group sessions, so you can be assured of a personalised experience. Click the buttons below to view my Booking Calendar and find a time that works best for you.

1-on-1 Session Pricing
(3-hours)

$495

ex GST

  • Personalised training focusing on your unique needs and goals
  • Apply what you’re learning immediately to your work files
  • Share your work files to maximise the effectiveness of your training
  • Learn at your own pace
  • Let’s get started!
book 1-on-1 session
Team Session Pricing
(3.5-hours)

2 to 3 people: $395

ex GST p.p

4 to 10 people: $350

ex GST p.p

  • Relevant and impactful training designed to address your team’s specific needs
  • Bring your team together online from anywhere
  • Dedicated time for your team to ask questions and get real-time answers
Book Session for Your Team

Get Your Course Info Sheet!

  • Discover the full course outline and content at a glance
  • See the specific skills you’ll gain to boost your Excel expertise
  • Learn how expert-led training can transform your productivity
  • Get your free Excel Essential Skills Checklist to guide your learning journey

Contact Me today for a quote or to answer Your questions