Master Class Excel Bronze Training Course

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

 

  • Create nested functions of a complex nature. IF, ISERROR, VLOOKUP will be used
  • Using Data Tables
  • Using INDEX, MATCH and INDIRECT functions
  • Manage multiple workbooks and resolve errors
  • Use macros to produce forms
  • Use basic VBA code in macros
  • Deepen your understanding of Pivot Tables, Slicers, Sorting and Filtering
  • Solve problems using a variety of complex functions
  • Use Scenario Manager to work out different “What If” scenarios
  • Exercises throughout

 

Course Objectives

During this course you will learn how to build on your existing advanced knowledge to resolve a number of problems using nested statement, produce macro enabled forms and deepen your understanding on Pivot Tables and Charts. You will also look at Data Tables, managing multiple workbooks resolving errors and how to use formulas in conditional formatting.

FAQs

How is the Master Class Bronze Excel training course structured?
We cover a selection of topics in our master class bronze Excel course. The topics are structured to build on throughout the day. There are also many breaks throughout the day including a mid morning break, lunch break and mid afternoon break.

 

How do I know if this is the right level course for my Excel training needs?
With this level of course, we would strongly suggest that you have attended our advanced Excel course previously. The content on this course covers much more complex examples of topics from the advanced course as well as other complex topics. If you wanted to come straight onto this course, then we ideally would like to have a quick chat to assess your level of Excel use to make sure that you will benefit from going straight onto it.

 

Does the training cover the latest Microsoft Office 365 updates?
Yes it does. The majority of the content of all our Excel training courses transfers across and is compatible with any future Microsoft 365 updates. However, all of our Excel 365 training courses are also regularly reviewed to ensure any new tools and features are not missed out.

 

How can Microsoft Excel training benefit my business?
Excel is one of the most widely used Microsoft packages by businesses and so any training will benefit members of staff greatly. IT has many benefits including increasing your team’s productivity, developing existing data analysis skills further and strengthening their ability to communicate effectively, helping your business stand out in any industry.

 

Comments and Testimonials

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

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

Ashorne Hill – Training staff in Excel, Word and PowerPoint

Excellent training delivery, courses being small in numbers worked very well for our staff, giving them time for any additional questions/content.
Smooth process from start to finish and excellent that trainers could provide individual laptops for staff that didn’t have their own.
Very informative training – we like the fact we can keep notes to refer back to while at work

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

Chamber of Commerce – Excel Training for Baylis & Harding

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