Virtual Advanced Excel Training Course
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.
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”