|
||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Home | Computers & Technology | Software | Php 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, 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. Pivot tables have been considerably improved in Excel 2007. However, given that so many users are a bit vague on getting the best out of pivot tables, why not ask that your training on pivot tables begins with a review of fundamental pivot table concepts before moving on to look at how Excel 2007 implements pivot table features. Do you or your organisation use charts and graphics when creating Excel reports? If so, be sure that your Excel 2007 training covers the new and improved charting engine within this new version. You should learn how to fully exploit the new chart ribbons: format, layout and design. You should come away from the training knowing all about SmartArt graphics, adding 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. An Excel spreadsheet without formulas and functions is not much use to anyone. Functions are what Excel is all about. Microsoft have improved the way in which function are entered and edited and added several new functions. When you book training on Excel 2007, make sure that your course will include coverage of new functions like SumIfs, IfError and AverageIf as well as a demonstration of the improvements to the editing of formulas. Article Source: http://www.articlewheel.com
The author is a training consultant with Macresource Computer Solutions, an independent computer training company offering QuarkXPress Classes in London and throughout the UK.
|
 RSS Feeds by Category |
|||||||||||||||||||||||||||||||||||||||||||||||||||||
