Excel Combine, Analyse
& Report Stage 3

Take your skills up MORE than a few notches! Learn Lookup Functions, Tables And Pivot Tables

DURATION: 3.5 delivered live over Microsoft Teams or Zoom

Microsoft Excel Stage 3 tutor-Led Online course


Excel Combine, Analyse and Report

Spending countless hours on data clean-up and preparation? Improve your workflow with advanced Excel tools like Lookup functions and Pivot Tables. These powerful tools will streamline your data analysis and reporting process. Don’t waste any more time; upgrade your Excel toolbox today!

What you’ll learn:

  • Master Excel’s most popular Lookup functions, VLOOKUP and XLOOKUP, and discover a host of tips, hints, and complementary functions that will have you creating look-ups like a pro.
  • Learn how to clean data and prepare it for optimal performance with various functions and reporting features in Excel.
  • Discover the time-saving benefits of Excel’s Table feature, and learn how to create dynamic ranges and multi-functional lists that will save you from resetting your ranges again.
  • Effortlessly generate impactful Pivot Table reports and provide your team with the crucial data they need.

Lookup And Cross-Reference

  • Combine data from multiple worksheets into one summary sheet using the
  • VLOOKUP and XLOOKUP functions (XLOOKUP is for Microsoft 365 only)
  • Avoid the things that cause a lookup function not to work

Preparing Data For Reporting

  • 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
  • Quickly remove unwanted text and unwanted spaces inside of cells

Using Tables

  • Manage and analyse data ranges using the Table feature
  • Use dynamic Table ranges in formulas and Pivot Tables

Creating Pivot Tables

  • Ensure your data is fit for pivoting
  • Create a new Pivot Table
  • Understand the Pivot Table cache
  • Change the layout and formatting of the report
  • Control how the data, totals and subtotals are displayed and summarised
  • Sort, filter and rank the data
  • Insert Slicers and Timelines
  • Move items into logical groups for ease of summarising and performing data
  • analysis
  • Group dates by month, quarter, and year
  • Create calculations within the Pivot Table area
  • Display values as percentages of totals
  • Work with multiple data cache

Is this course right for you?

If you want to:

  • Turbo-boost your output and the accuracy of your reports
  • Master Excel’s powerful Lookup functions to combine and cross-reference data
  • Improve efficiency using dynamic ranges – no more having to reset your ranges!
  • Become a Pivot Table pro and quickly consolidate and analyse data to create meaningful reports for your team
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 combine, analyse and report – Stage 3 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.

Enhance your data analysis capabilities and elevate your productivity in Excel!

Thank you so much once again for the training yesterday. Feedback from the team is all very positive. Your training style is wonderful, and even the team members who probably considered themselves capable Excel users had their minds blown a number of times, which is awesome!
Craig Williams
Country Manager – New Zealand
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
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. So impressed with how the whole group went at a steady pace despite different levels. Sharyn, you’re a star! Very enjoyable and I learnt lots!
Rachel Alcorn
Human Resources
Very helpful and relates the teachings back to how we work, what we need and how we could make use of our spreadsheets.
Kelly Hogan
Credit Controller
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

Get Your Course Info Pack!

  • 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

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

Contact Me today for a quote or to answer Your questions