Master Class Excel Bronze Training Course

Master Class Excel Bronze Training Course

Our Master Class Excel Bronze training course can be carried out in the following versions: 2010, 2013, 2016 and 365.

All of our 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.

Comments and Testimonials

Redwing Solutions – Training Staff in Microsoft 365

Both John & Rachel have provided 1-2-1 training for our team for several years and each time the training has been excellent and informative.
Both John & Rachel’s training skills and techniques are fantastic, and they are both extremely patient and conscientious throughout the day, ensuring that everyone understands each section before moving on to the next.
We would highly recommend JPL to anyone wishing to get themselves & their team up to date with any IT training!

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

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

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

Snow Business testimonial – working alongside staff in Excel

The session was very well structured with a good combination of theory and practical work. It was very useful to do individual examples of each task and the course notes are thorough without being confusing. John was a great teacher and catered for all knowledge levels. The pace of the day was great, at no point did we feel John was moving on too quickly but the sessions didn’t ‘drag’.

Read Full Testimonial