Because Microsoft Excel 2007 has so many differences from Excel 2003, when you or your staff upgrade, you will almost certainly need training. But what kind of training will work best? Do you need an upgrade course that shows you the new features? Do you need a training course that compares Excel 2003 and 2007 and shows you how features have changed and evolved in the new version? Or do you need Excel training to take your skills to a new level, whatever the version?... Well, why not find a course that does all of the above?
One of the first things you should look for in having training on Excel 2007 is a full explanation of how the new interface works. You should be shown the new way of working and learn useful tips and shortcuts which will enable you to become at least as productive in Excel 2007 as you were in 2003.
However, after being trained on 2007, you will want to do more than just get back to where you were with 2003. You will want the training to show you what new features have been added to Excel 2007 and how these new features can benefit you.
One fundamental new feature in Excel 2007 is the dimension of a worksheet which is now about 1000 times bigger (in terms of the number of cells) than previous versions. A good Excel 2007 training course should show you how to fully exploit the space available and how to quickly navigate and manage the larger worksheets that will result.
Your training should also include demonstrations and explanations of pivot tables, a feature which has been revamped and improved in Excel 2007. If you or your colleagues have not used pivot tables to any great extent before, the training should begin by reviewing basic pivot table concepts before moving on to look at what Excel 2007 has to offer.
Charts have been given a big overhaul in version 2007. So be sure your training includes coverage of the special effects available in Excel 2007 charting and graphics. Your training course should cover such features as the format, design and layout ribbons and how to use SmartArt graphics and shapes. If charting is particularly important in your organisation, then make sure your training covers things like trendlines, scatter charts and pivot charts.
Another feature that has been developed in Excel 2007 is conditional formatting. Be sure that any training you have on Excel 2007 includes some insight into the use of Excel 2007's powerful new conditional formatting features especially Data Bars and Color Scale.
Formulas are the lifeblood of Excel. They analyse the raw data entered in other cells and provide most of Excel's awesome power. You should definitely request that your Excel 2007 training shows you the improvements that have been made to the entry of formulas in the formula bar and the key new functions that have been introduced, especially AverageIf, SumIfs, and IfError
One of the first things you should look for in having training on Excel 2007 is a full explanation of how the new interface works. You should be shown the new way of working and learn useful tips and shortcuts which will enable you to become at least as productive in Excel 2007 as you were in 2003.
However, after being trained on 2007, you will want to do more than just get back to where you were with 2003. You will want the training to show you what new features have been added to Excel 2007 and how these new features can benefit you.
One fundamental new feature in Excel 2007 is the dimension of a worksheet which is now about 1000 times bigger (in terms of the number of cells) than previous versions. A good Excel 2007 training course should show you how to fully exploit the space available and how to quickly navigate and manage the larger worksheets that will result.
Your training should also include demonstrations and explanations of pivot tables, a feature which has been revamped and improved in Excel 2007. If you or your colleagues have not used pivot tables to any great extent before, the training should begin by reviewing basic pivot table concepts before moving on to look at what Excel 2007 has to offer.
Charts have been given a big overhaul in version 2007. So be sure your training includes coverage of the special effects available in Excel 2007 charting and graphics. Your training course should cover such features as the format, design and layout ribbons and how to use SmartArt graphics and shapes. If charting is particularly important in your organisation, then make sure your training covers things like trendlines, scatter charts and pivot charts.
Another feature that has been developed in Excel 2007 is conditional formatting. Be sure that any training you have on Excel 2007 includes some insight into the use of Excel 2007's powerful new conditional formatting features especially Data Bars and Color Scale.
Formulas are the lifeblood of Excel. They analyse the raw data entered in other cells and provide most of Excel's awesome power. You should definitely request that your Excel 2007 training shows you the improvements that have been made to the entry of formulas in the formula bar and the key new functions that have been introduced, especially AverageIf, SumIfs, and IfError
About the Author:
The The writer of this article is a trainer and developer with Macresource Computer Solutions, a UK IT training company offering QuarkXPress Classes at their central London training centre.
Posts
No comments:
Post a Comment