Archive

Archive for the ‘Software’ Category

Microsoft Excel In-house Training Checklist

November 7th, 2008
by Matthew Fletcher

Which version of Excel?

As to the size of the class, somewhere between five and ten people can usually be accommodating in a training room with reasonable facilities. You will need to ensure that you have a conference or training room equipped with a computer for each delegate and a projector which can be connected to a computer used by the trainer to demonstrate each technique.

One feature that you should almost never omit in an Excel training course is formulas and functions. Functions are the lifeblood of Microsoft Excel. They allow the program to carry out complex calculations and produce useful results in a variety of different areas including statistics, engineering and the financial arena. Be sure to give the training company a good idea of the type of data your people work with and the information they need to obtain. This will enable the trainer to include coverage of functions which can help increase your productivity and get the most out of Excel.

Class sizes

Ideally, training courses should be attended by users with a similar level of experience and with similar requirements. If you have a mixture of skills levels, it is best to split the training into separate sessions to cater for people’s different needs. It is also important to limit attendance to those people who can attend for the entire duration of the training. Having delegates nip in and out of a training session is disruptive and doesn’t really benefit anyone.

Which topics should be covered

Who should attend

One feature that you should almost never omit in an Excel training course is formulas and functions. Functions are the lifeblood of Microsoft Excel. They allow the program to carry out complex calculations and produce useful results in a variety of different areas including statistics, engineering and the financial arena. Be sure to give the training company a good idea of the type of data your people work with and the information they need to obtain. This will enable the trainer to include coverage of functions which can help increase your productivity and get the most out of Excel.

Class sizes

As to the size of the class, somewhere between five and ten people can usually be accommodating in a training room with reasonable facilities. You will need to ensure that you have a conference or training room equipped with a computer for each delegate and a projector which can be connected to a computer used by the trainer to demonstrate each technique.

If your staff are trained on an older version of Excel and then have their software upgraded to 2007, the differences are so significant that many of them will need retraining!

About the Author: