Advanced Excel Training Course

Our Advanced 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 more complex Excel activities used by an experienced Excel professional. These will include the creation of complex charts, advanced filtering, text and logical functions for problems resolution and the analysis of unique lists. We will also cover nested statements, VLOOKUPs, Pivot Tables and Macros.

 

Key Content

The key content that is covered in the course can be found below:

      • More Complex Charts
      • Date and Time functions
      • Using Logical functions
      • Using Text functions
      • Advanced Filtering of a list. Unique Lists
      • Advanced IF function – problem solving
      • VLOOKUP and nested VLOOKUP – ranges
      • Data Validation – Lists and Values
      • Absolute references in Complex Problem Solving
      • Pivot Tables and Charts
      • Simple macros. Editing Macros
      • 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:

“Very clear and informative. Best part of the course: learning pivot tables and advanced filtering”

“The trainer was very knowledgeable and has provided a pack to take away. Best part of the course: question time at the end and VLOOKUPs reminder”

“Really clear and useful. Trainer was patient and answered all questions”

“Best part of the course: Clear delivery – John’s extensive knowledge”

“Best part of the course: help during exercises/level of exercises”

“Best part of the course: interactive working/team working”

“Best part of the course: learning IF quotes, F11, pivot tables. Time saving”

“Excellent course – in depth and knowledgeable. Best part of the course: interactive participation”

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