Excel 2007 In-company Training Checklist

Computers Add comments

Which version of a href=http://www.macresource.co.uk/courses/ms_excel.htm target=_blankExcel/a?br /
br /
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.br /
br /
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!br /
br /
Which topics should be coveredbr /
br /
One of the main benefits offered by on-site training courses is that you can focus on those topics which are most relevant to your organisations. A good technique is to ask the company providing the training for a list of topics they cover on their standard courses then to provide them with a guide as to which features you feel are important, less important or can be omitted all together.br /
br /
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.br /
br /
Who should attendbr /
br /
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 peoples 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 doesnt really benefit anyone.br /
br /
Class sizesbr /
br /
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.br /
br /
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.br /
br /
The author is a trainer and developer with Macresource Computer Training, an independent computer training company offering a href=http://www.macresource.co.uk/excel-vba-training-birmingham.asp target=_blankExcel Classes in Birmingham/a and throughout the UK.br /
br /
Access expert info for a href=http://www.playstationexpert.com/play-station-tips/sony-playstation-advice-hints-and-tips.html target=_blankcheap new playstation 3/a – welcome to your own tips store.

Be Sociable, Share!
Leave a Reply

You must be logged in to post a comment.

Entries RSS Comments RSS Log in