Intermediate Excel Training Course

Our Intermediate Excel 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.

 

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.

 

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
      • Miscellaneous features remove duplicates, evaluate formulas
      • Absolute References in formulas. Named cells and Ranges
      • Complex formulae e.g. IF, Problem Solving
      • Formula auditing
      • Group sheet selection
      • Multi File linking and consolidation
      • Using Mathematical and Statistical functions
      • Locking Cells and password protection
      • Exercises throughout

For more information and for prices, please contact us at johnlegge@jplcomputer.co.uk or by giving us a call on 07903 840105 for a no obligation quote.

We’d be happy to help with your Microsoft Office training needs.

Comments from attendees:

“Training was great, very interactive. Best part of the course: learning shortcuts”

“Fantastic teaching and energy. Best part of the course: teaching”

“Best part of the course: The formulas and graphs shortcuts (F11)”

“Very well delivered. Best part of the course: being self taught I am learning the things I skipped”

“Very well put together course. Best part of the course: wide range of tools never used before”

“Presented and explained well. Best part of the course: learning formula’s and how they are used. Really good course, well worth doing”

“Very good, enjoyed it and really helpful. Best part of the course: John willing to help with any questions. Loved ‘short-cuts’”

“Excellent training – explaining complex interactions, so useful. Best part of the course: the practical approach, and taking questions”

Cookie Control

Cookie control

We have placed cookies on your device to help make this website better.

I'm fine with this

We have placed cookies on your device to help make this website better.

You can use this tool to change your cookie settings. Otherwise, we’ll assume you’re OK to continue.

Some of the cookies we use are essential for the site to work.

We also use some non-essential cookies to collect information for making reports and to help us improve the site. The cookies collect information in an anonymous form.

To control third party cookies, you can also adjust your browser settings.

I'm fine with this
(One cookie will be set to store your preference)
(Ticking this sets a cookie to hide this popup if you then hit close. This will not store any personal information)
Information and Settings Cookie policy