Intermediate Excel Training Course

Our Intermediate 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:

 

  • Charts – chart sheets, formatting and protection
  • Sorting and Custom Lists. Advanced sorting
  • Subtotalling using command button
  • Auto, Custom and Advanced Filtering of a list
  • Highlighting and removing duplicates
  • Absolute References in formulas. Named cells and Ranges
  • Complex formulae e.g. IF
  • Formula auditing
  • Group sheet selection
  • Multi File linking and consolidation
  • Using SUMIF and COUNTIF functions
  • Locking Cells and password protection
  • Exercises throughout

Course Objectives

The objective of this course is to enable the trainee to understand regularly used features in business including the creation of Charts. Data Analysis functions like Sorting, Sub Totalling and Filtering will be covered. Extensive practices will be given in the use of problem techniques like relative and absolute referencing and the IF statement. We will then cover multi sheet and workbook summaries.

FAQs

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

 

How is the Intermediate Excel training course structured?
Our Intermediate course builds on and covers topics from the basic course in more detail. We do also cover some new topics too. The topics are organised to build on throughout the day. There are 2 short breaks, one mid morning and one mid afternoon, and lunch break planned in to break up the whole day course.

 

How do I know if this is the right level course for my Excel training needs?
As this is the Intermediate level course, you will be a regular user of Excel in your work. To know if this is the right level, have a look at the content on the basic course and if you know at least 80% of it confidently then you are ok to do this level. If you are unsure, we advise it is best to do the basic level first to make sure you are confident enough to benefit from this level.

 

How can Microsoft Excel training benefit my business?
Excel is used by businesses in all sectors and so any training will benefit your members of staff greatly. There are many benefits including increasing your team’s productivity, strengthening abilities for effective communication and developing existing data analysis skills further, all helping your business stand out in any industry.

 

Comments and Testimonials

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

Redwing Solutions Ltd – Training staff in Excel, Word and PowerPoint

JPL’s training courses have been brilliant for us. John delivers the courses in an informative, helpful and extremely friendly manner.
Each element of the courses is explained clearly and makes sure that everyone understands before continuing. Each course is gone through at your own pace, so it never feels rushed or overwhelming.
Furthermore, John is always personable and makes sure the courses are always an enjoyable and friendly experience.

Read Full Testimonial

Microsoft Excel Courses at AFH Wealth Management

John is an excellent trainer and has helped many of our staff members become competent users of Excel, which has ultimately improved efficiencies when performing their job roles. John’s “learn by doing” style of teaching is very effective as it enables the trainees to get hands-on experience while they develop their skills within the system.

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

Direct Air Testimonial – helping train staff in Microsoft 365 packages

JPL IT Training has provided exceptional remote training for members of our Sales & Marketing team. The team had varying levels of Microsoft knowledge, so the training covered Word, Excel and PowerPoint. All of the team found the courses they attended really useful. As a result they have been implementing key takeaways in their day-to-day work such as shortcuts and formatting tools. The training was 1-2-1 and very flexible to each learners’ requirements. This style was a fantastic method of training for our business. Thank you to John & Rachel!

Read Full Testimonial