Tuesday, January 4, 2011

Getting The Most Out of Microsoft Excel In-house Training

By David Robertson


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!

Who should attend

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.

A general rule of thumb is that the bigger the leap you are asking people to make, the smaller the class needs to be. For example, if you decide to get your staff trained on the use of Excel macros and none of them have ever done any programming, then you should restrict the size of the group to between three and six people. By contrast, if you have a group of people who have been using the program for some time, but have never been formally trained and need to be given a better idea of what the program can do, you could probably have a larger group of, say, between seven and ten people.

Who should attend

The obvious answer to this question may seem to be "the version that we are currently using". However, because of the significant difference between Excel 2007 and previous versions, if you are currently using Excel 2003 but plan to upgrade within the next year or so, it is definitely worth making sure you upgrade before getting your staff trained.

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.

A general rule of thumb is that the bigger the leap you are asking people to make, the smaller the class needs to be. For example, if you decide to get your staff trained on the use of Excel macros and none of them have ever done any programming, then you should restrict the size of the group to between three and six people. By contrast, if you have a group of people who have been using the program for some time, but have never been formally trained and need to be given a better idea of what the program can do, you could probably have a larger group of, say, between seven and ten people.




About the Author:



No comments:

Post a Comment