Virtual Advanced Excel Training Course

Virtual advanced Excel training course: Excel iconOur virtual Advanced Excel training course can be carried out in all Microsoft versions.

All of the courses we offer are full day courses which run from 9:30am to 4pm with a lunch break and two coffee breaks to break up the day. Even though these standard timings are used most of the time, we can alter them to fit in with your needs. As well as this we can create a bespoke course for you to be tailored to your training needs. Whether it is a standard or bespoke course you require, just ask us as we’d be happy to help you.

 

Course Objectives

The objective of this course is to equip the attendee with understanding of more complex Excel features. Some features included are the creation of complex charts, text and logical functions, advanced filtering and the analysis of unique lists. As well as all of this VLOOKUPs, nested statements, Macros and Pivot Tables will also be covered.

 

Key Content

All of the key content that is covered in the virtual course can be found below:

      • More Complex Charts
      • Using Text functions
      • Date and Time functions
      • Using Logical functions
      • Advanced Filtering of a list. Unique Lists
      • Absolute references in Complex Problem Solving
      • VLOOKUP and nested VLOOKUP – ranges
      • Advanced IF function – problem solving
      • Data Validation – Lists and Values
      • Simple macros. Editing Macros
      • Pivot Tables and Charts
      • Exercises throughout

If you would like more information and prices, please contact us at johnlegge@jplcomputer.co.uk or call us on 07903 840105 for a no obligation quote.

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

Comments from attendees:

“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”

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

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

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

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

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

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

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

Cookie Control

Cookie control

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

I'm fine with this

We use cookies to give you the best online experience.

Please let us know if you agree to all of these cookies.

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