Duration: 4 hours
This half-day, high-end intermediate level course has been designed to introduce the features that assist you in combining, analysing and reporting on large data lists.
Topics include super helpful tips on preparing data for use in VLOOKUP formulas, creating dynamic ranges using Tables, and producing Pivot Table reports.
Is this course suitable for you or your team?
This course is suitable for anyone who is already knowledgeable in the topics covered in our Excel Essential Skills course and our Excel Organising and Analysing Data course, and is the next step to becoming a proficient user of Excel. This course is definitely for you if you want to:
This hands-on course takes you through the steps you need to master in order to be a 'lookup' guru, use Tables and Table references to save you time and avoid potential errors and to confidently build meaningful reports using Pivot Tables.
You would benefit from having an understanding of the skills covered in our and our Excel Organising and Analysing Data course. However, this isn't mandatory.
A copy of our super popular step-by-step workbook along with file downloads for every exercise we cover together. Perfect to follow along with during the training, and to refer to after the training.
Capped class size to ensure you have the hands-on time required and your questions answered.
Need proof of your Continuing Professional Development (CPD)? On completion of the workshop, by request, we will send you a “Certificate of Attendance” confirming your participation and the duration of the training session.
The workbook and exercise files used during the onsite session will be emailed to our onsite contact prior to the session. Having a printed copy of the workbook handy during the learning will be extremely beneficial to your learners.
Need training laptops? Not a problem. We can bring laptops for you to use, no charge. We have 6 to share. All are thoroughly sanitised before and after use.
We use Microsoft Teams or Zoom 5.0 to deliver live online sessions. If you would like to follow along with your trainer please ensure you have the desktop version of Microsoft Excel available. Having a webcam and headphones available ensures you can enjoy interacting with your trainer and fellow participants. Please ensure your browser software is up to date too. For the best experience we would recommend using Microsoft Chromium Edge or Google Chrome as your browser.
Details on how to connect to the session, along with your workbook and exercise files will be emailed to you prior to your session. Having a printed copy of the workbook handy during your learning will be extremely beneficial to your learning.
Any questions, please contact us at firstname.lastname@example.org.
Online LIVE instructor led course
30 June 2020, 9:00am - 1pm
4 August 2020, 9:00am - 1pm
Guaranteed to run
Need a quote for a group online session?
Please contact us today.
This training is for the Windows Desktop version of Excel and may not be suitable for Mac users
Need a quote for a workshop for your team?
Please contact us today.
This training is for the Windows version of Excel and may not be suitable for Mac users
Keen to do all 3 Stages of Excel?
Talk to us about booking an
'Excel Combo' and save!
People who booked this course also booked:
"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.
"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. 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!
"Your training style is wonderful"
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 members of the team who probably considered themselves as capable Excel users had their minds blown a number of times.. which is awesome!
Country Manager - New Zealand