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

IKON Dental Suite Testimonial – helping train staff in Microsoft Office

We wanted to share a quick note and let you know that you did a really good job on giving us the training that we need for Excel and PowerPoint.

As we all know these both are big topics which suit every company differently. We cannot thank you enough for taking the time to tailor this course to our needs.

John is an excellent trainer and very generous with his tips. We were also very impressed by the excellent and efficient before and after communication in between us.

The whole team benefitted greatly from the day. We are looking forward booking more courses provided by you.

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

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

UCB – delivering all Microsoft Office courses to staff

My colleagues at UCB have nothing but praise for John and his team. John’s training is excellent and his advice on Microsoft packages has been valuable to us. I highly recommend JPL Computer Services Limited as a training provider and look forward to the next training that we will arrange.

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