Intermediate Excel Training Course
Our intermediate Excel training course can be carried out in the following versions: 2010, 2013, 2016 and 365.
All of our courses are full day courses, typically running from 9:30am to 4pm with two coffee breaks and a lunch break throughout to break up the course. Timings can be slightly flexible though to fit in with your needs. We can also create a bespoke course to tailor the contents of the course to your needs. Just ask, we’d be happy to help.
Course Objectives
The objective of this course is to enable the trainee to understand regularly used features in business including the creation of Charts. Data Analysis functions like Sorting, Sub Totalling and Filtering will be covered. Extensive practices will be given in the use of problem techniques like relative and absolute referencing and the IF statement. We will then cover multi sheet and workbook summaries.
Key Content
The key content that is covered in the course can be found below:
-
-
- Charts – chart sheets, formatting and protection
- Sorting and Custom Lists. Advanced sorting
- Subtotalling using command button
- Auto, Custom and Advanced Filtering of a list
- Miscellaneous features remove duplicates, evaluate formulas
- Absolute References in formulas. Named cells and Ranges
- Complex formulae e.g. IF, Problem Solving
- Formula auditing
- Group sheet selection
- Multi File linking and consolidation
- Using Mathematical and Statistical functions
- Locking Cells and password protection
- Exercises throughout
-
For more information and for prices, please contact us at johnlegge@jplcomputer.co.uk or by giving us a call on 07903 840105 for a no obligation quote.
We’d be happy to help with your Microsoft Office training needs.
Comments from attendees:
“Training was great, very interactive. Best part of the course: learning shortcuts”
“Fantastic teaching and energy. Best part of the course: teaching”
“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”
“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”
“Very good, enjoyed it and really helpful. Best part of the course: John willing to help with any questions. Loved ‘short-cuts’”
“Excellent training – explaining complex interactions, so useful. Best part of the course: the practical approach, and taking questions”