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

Microsoft Office Access – supporting your business development

John worked closely with the office team at Red Hill Christian Centre… as our needs have grown and changed he has trained us to adapt this at each stage.

Read Full Testimonial

UCB – delivering all Microsoft Office courses to staff

My colleagues at UCB have nothing but praise for John and his team. John’s training is excellent and his advice on Microsoft packages has been valuable to us. I highly recommend JPL Computer Services Limited as a training provider and look forward to the next training that we will arrange.

Read Full Testimonial

Chamber of Commerce – Excel Training for Forest Garden Group

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

Carpet & Flooring – Helping train staff in Microsoft 365 packages

JPL created and conducted a bespoke Excel training program based on our requirements, and both John and Rachel exceeded our expectations in the delivery of this. Delegates were from a variety of departments and had varying levels of experience, yet John and Rachel were accommodating and engaging to ensure this training was effective to all. The team found the training informative, useful to their day job, and fun, and look forward to participating in future courses with JPL

Read Full Testimonial

Caldwell UK & Cotswold Architectural Products Ltd – Training Staff in Microsoft 365

We have used JPL training throughout the past year to help improve our teams Excel skills, and we all really enjoyed the training. Both online and on site.
John and Rachel show great patience and can really pin point individual needs. All of our departments have benefited from the training, and we are already looking for our next opportunity to extend our skills with JPL.

Read Full Testimonial