Virtual Advanced Excel Training Course Content

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

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

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.

Comments and Testimonials

Harvey and Brockless – working alongside JPL for training needs

We have worked with John for a number of years now in group environments from basic to masterclass levels, and in 121 sessions tailored around our specific requirements. We’ve seen in this time, our staff grow in confidence and ability through John’s tuition, which has in turn benefitted our company and our staffs’ own development.

Read Full Testimonial

Microsoft training experts for you | JPL IT Training Limited

John and Rachel developed some customised training to meet a particular need (computer awareness). I was impressed with the service we received from start to finish, the training met our needs and we had extremely positive feedback from the delegates, in particular about the trainers’ style and delivery.

Read Full Testimonial

Move With Us testimonial – helping train staff in Excel

I had a workshop session with John on a survey report that was taking a considerable amount of time to complete. John explained to us that if we changed how we were initially setting out the data that the production of reports and pivot tables would be much quicker.

The Excel training we had over the course of the next two days was fantastic. John managed to keep us all focussed, he is a very engaging trainer. We were all eager to get back to our desks and start implementing what we’d learnt to make our report running much more efficient.

Read Full Testimonial

Microsoft Office Access – supporting your business development

John worked closely with the office team at Red Hill Christian Centre… as our needs have grown and changed he has trained us to adapt this at each stage.

Read Full Testimonial

Build It International testimonial – helping those that help others

Thanks to @johnlegge for our recent Excel training session helping us to manipulate data quicker and more effectively 📊📈 Lots of really useful hints and tips that we’ve already been putting into practise! #MasterYourData 🤓 #BuildingBrighterFutures

Read Full Testimonial
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