Virtual Intermediate Excel Training Course
Our virtual intermediate Excel training course can be carried out in all versions of Microsoft.
All of our Excel courses are full day courses and they normally run from 9:30am to 4pm. We allow for two coffee breaks and a lunch break throughout the day to break up the course. Although these are our standard timings, we can alter them to fit in with your needs. As well as our standard course agendas we can put together a bespoke agenda to accommodate your training needs. Whichever you require just ask, we’d be happy to help.
Course Objectives
The objective of this course is to equip the trainee with the knowledge of regularly used features in business. Some of the features covered are creating Charts, Sub Totalling, Sorting and Filtering. Trainees will be able to learn and develop skills through the use of problem techniques like relative and absolute referencing and the IF statement. Finally the course will cover the use of multi sheet and workbook summaries.
Key Content
The key content that is covered in the virtual course can be found below:
- Charts – chart sheets, formatting and protection
- Sorting and Custom Lists. Advanced sorting
- Auto, Custom and Advanced Filtering of a list
- Subtotalling using command button
- Absolute References in formulas. Named cells and Ranges
- Complex formulae e.g. IF, Problem Solving
- Miscellaneous features remove duplicates, evaluate formulas
- Formula auditing
- Multi File linking and consolidation
- Group sheet selection
- Locking Cells and password protection
- Using Mathematical and Statistical functions
- Exercises throughout
If you would like more information and for 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 Microsoft Office virtual training needs.
Comments from attendees:
“Very well put together course. Best part of the course: wide range of tools never used before”
“Presented and explained well. Best part of the course: learning formula’s and how they are used. Really good course, well worth doing”
“Training was great, very interactive. Best part of the course: learning shortcuts”
“Excellent training – explaining complex interactions, so useful. Best part of the course: the practical approach, and taking questions”
“Best part of the course: The formulas and graphs shortcuts (F11)”
“Very well delivered. Best part of the course: being self taught I am learning the things I skipped”
“Fantastic teaching and energy. Best part of the course: teaching”
“Very good, enjoyed it and really helpful. Best part of the course: John willing to help with any questions. Loved ‘short-cuts’”