Master Class Excel Silver Training Course

Our Master Class Excel Silver 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:

 

  • First half of the day is devoted to an introduction to VBA programming
  • Learn and use some lesser known but useful functions. HLOOKUP, SUMIFS, SEARCH, SORT and XLOOKUP will be used
  • Using Pivot Tables as well as using multi sheets in Excel in relation to their use in a Pivot Table
  • Learning about Array Work and using the transpose function
  • Use of advanced Data Validation, Data Validation with names and INDIRECT function
  • Data Validation with VLOOKUP
  • Exercises throughout

Course Objectives

This course is a follow on course from the Master Class Excel Bronze course and continues to build on existing knowledge of Excel. During this course you will learn how to use more functions, create pivot tables using multi sheets, use advanced data validation, array work and have an introduction to VBA programming.

FAQs

Does the training cover the latest Microsoft Office 365 updates?
Definitely. Most of the content of our Excel training courses transfers across and is compatible with any future updates of Microsoft 365. As well as this though, we regularly review all of our Excel 365 training courses to ensure any new features and tools are not missed out.

 

How is the Master Class Silver Excel training course structured?
Our master class silver Excel course is a bit different to our other courses. The first half of the day covers an introduction to vba programming and then the second half covers a selection of more complex topics. There is a mid morning break, lunch break and mid afternoon break planned in ensure that it isn’t too much information for you in one go.

 

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

 

How do I know if this is the right level course for my Excel training needs?
Due to the nature of this course, we have a pre-requisite of attendance on our master class bronze Excel course. This is due to the nature of the complex topics covered. If you use Excel to this high level in your job currently, then we will require a quick chat with you to ensure that you will be able to cope with the high level of difficulty of the topics covered, especially the half day on an introduction to programming.

 

Comments and Testimonials

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

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

Build It International testimonial – helping those that help others

Thanks to @johnlegge for our recent Excel training session helping us to manipulate data quicker and more effectively 📊📈 Lots of really useful hints and tips that we’ve already been putting into practise! #MasterYourData 🤓 #BuildingBrighterFutures

Read Full Testimonial

Harvey and Brockless – working alongside JPL for training needs

We have worked with John for a number of years now in group environments from basic to masterclass levels, and in 121 sessions tailored around our specific requirements. We’ve seen in this time, our staff grow in confidence and ability through John’s tuition, which has in turn benefitted our company and our staffs’ own development.

Read Full Testimonial

United Christian Broadcasters – delivering training courses to staff

The Training that we have received from John and Rachel over the years has been excellent. Everyone who has attended a session is full of praise for their training.
John is very patient as a trainer and each person feels listened to and helped with the Microsoft packages they are using. We look forward to the times that John comes to site to deliver training, helping members of staff move up through the different levels of the courses.
It’s wonderful to hear about how staff will apply the learning to their roles. I highly recommend JPL IT Training Limited as a training provider.

Read Full Testimonial