Advanced Excel Training Course

Our Advanced Excel training course can be carried out in all versions of Microsoft.

All of our Microsoft Excel training courses are full day courses, typically running from 9:30am to 4pm with two coffee breaks and a lunch break throughout to break up the course. Timings can be slightly flexible though to fit in with your needs. We can also create a bespoke course to tailor the contents of the course to your needs. Just ask, we’d be happy to help.

Key Content

The key content that is covered in the course can be found below:

 

  • More Complex Charts
  • Date and Time functions
  • Using Logical functions
  • Using Text functions
  • Advanced Filtering of a list. Unique Lists
  • Advanced IF function – problem solving
  • VLOOKUP and nested VLOOKUP – ranges
  • Data Validation – Lists and Values
  • Absolute references in Complex Problem Solving
  • Pivot Tables and Charts
  • Simple macros. Editing Macros
  • Exercises throughout

Course Objectives

The objective of this course is to enable the trainee to understand more complex Excel activities used by an experienced Excel professional. These will include the creation of complex charts, advanced filtering, text and logical functions for problems resolution and the analysis of unique lists. We will also cover nested statements, VLOOKUPs, Pivot Tables and Macros.

FAQs

How do I know if this is the right level course for my Excel training needs?
The advanced Excel course is suited for anyone who is a strong user of Excel in lots of areas of the package. The course builds further on the intermediate course, taking those topics and covering more complex examples. We would suggest that you have completed our or an Intermediate Excel course somewhere else before attending this one to make sure you get the most out of the day. Otherwise, if you are a strong user of Excel and know and use at least 80% of the content covered in the Intermediate course, then you will be ok to come straight on to it.

 

How is the Advanced Excel training course structured?
There are a variety of topics covered in our advanced Excel course. The topics are structured to build on throughout the day. To break up the whole day course, a mid morning break, lunch break and mid afternoon break are planned in throughout.

 

How can Microsoft Excel training benefit my business?
Excel is probably the most widely used of all the Microsoft packages and training in it will help strengthen members of staff knowledge greatly. It can develop existing data analysis skills further, strengthen their ability to communicate effectively and increase your team’s productivity, helping your business stand out in any industry.

 

Does the training cover the latest Microsoft Office 365 updates?
Definitely. All the content of our Excel training courses transfers across and is compatible with any future Microsoft 365 updates. As well as this, all of our Excel 365 training courses have regular reviews to ensure any new tools and features are included.

 

Comments and Testimonials

Shrewsbury Food Hub Testimonial – training those helping their community

Thank you John for an engaging session. It has opened our eyes to many shortcuts and features that will make our working days run smoother.
Being a small charity, we do a lot of data collection and evaluation, to show the impact of our work. John showed us useful ways to record, sort and display our data in Excel. This will save us a lot of time! Thanks John.
A clear, well-structured course that catered for every level of computer literacy!

Read Full Testimonial

MonoSol AF Limited – Helping train staff in Microsoft 365 packages

“We would highly recommend JPL IT Training. We have been using JPL IT Training for several years now and would not consider booking with anyone else.
John and Rachel are excellent trainers and the feedback from employees is always great. They have delivered Excel, Word and Access courses at all levels both face to face and remotely.
The sessions are always interactive and informative, and you leave them knowing much more than you did at the start. In group sessions they have the ability to adapt to each learner and ensure everyone gets the level of attention they need which is important as no one gets left behind”

Read Full Testimonial

Move With Us testimonial – helping train staff in Excel

I had a workshop session with John on a survey report that was taking a considerable amount of time to complete. John explained to us that if we changed how we were initially setting out the data that the production of reports and pivot tables would be much quicker.

The Excel training we had over the course of the next two days was fantastic. John managed to keep us all focussed, he is a very engaging trainer. We were all eager to get back to our desks and start implementing what we’d learnt to make our report running much more efficient.

Read Full Testimonial

Lime Marketing – delivering bespoke training courses for staff

John has delivered Excel, Word and Outlook training to us at Lime Marketing over the last few months, he has trained around 20 employees and has created bespoke courses to suit our time, money and skill requirements. I’m pleased to say that the individual feedback from our team has been brilliant, everyone has come away feeling more confident and knowledgeable, from a business point of view it is fantastic to see employees valuing and enjoying Johns sessions and most importantly using new skills in the workplace. We look forward to continuing to work with John.

Read Full Testimonial

LPR – Helping train staff in Excel

John delivered the session in a relaxed manner. He ensured that all abilities were catered for and that people were learning at their own pace.
For the employees that needed a little more time, they did not feel pressured to move on and for the employees that were a little more advanced, John demonstrated some great tips and tricks!!
The day sessions were interesting, enjoyable and well planned. We can totally recommend this course and have booked for future intermediate training and an advanced bespoke course.

Read Full Testimonial