Virtual Intermediate Excel Training Course

Virtual intermediate Excel training course: Excel iconOur 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’”

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