|
Home | Business | Training
Microsoft Excel 2007 Training Options 
By: Andrew Whiteman
Upgrading to Excel 2007 may be something of a shock to you and your staff. The initial reaction of most people is: "where is everything?" Bearing this in mind, you may well find that a training course on Excel 2007 is a good investment. The training should first of all get you past the initial state of confusion caused by the fact that 2007 looks so different from previous versions. Then it should give you some guidance on the new features in Excel 2007 such as the enhancements to charting and graphics, functions and conditional formatting.
One of the key benefits you should look to derive from any training on Excel 2007 will be to regain the confidence level you achieved when using the previous version. You need to be shown the logic of the new interface, where your favourite features have been moved to, and how you can start working as quickly in Excel 2007 as you did in Excel 2003.
However, naturally, your training should not simply return you to the same level of knowledge that you had in version 2003 or 2003. On the contrary, you should be looking to get some guidance on what else Excel 2007 has to offer: the new features and the enhanced features.
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
Article Source: http://www.uberarticles.com/articles
Author is a developer and trainer with Macresource Computer Solutions, an independent computer training company offering QuarkXPress Classes in London and throughout the UK.
You can get a unique content version of this article.
This article is licensed under a Creative Commons Attribution-No Derivative Works 3.0 Unported License, which means you may freely reprint it, in its entiretly, provided you include the author's resource box along with LIVE links (without "nofollow" tags).
| 
