|
|
Tips and Techniques For Using Microsoft Excel 2007
In this increasingly busy and stressful world Microsoft Excel is an invaluable tool for anyone trying to get things done. From collating business figures to planning your social diary, its spreadsheets, charts and slick, professional graphics remove hassle and confusion and can make the most tedious tasks fun and engaging.
And one of the most impressive things about Microsoft Excel 2007 is the sheer amount of work you can do on it. While it is hard to imagine a spreadsheet requiring over a million rows and 16,000 columns, this program caters to just that eventuality and other considerations are also taken into account.
For instance, when sending a file saved on Excel 2007 to a user with an older version of the product a compatibility checker will notify you of the size of the workbook and inform you what will be lost in conversion. To cope with the expanded sheets Excel's memory management has also doubled to 2GB.
But it is not just the vastness of the workbook that strikes you, it is the style. Microsoft are undergoing a dramatic aesthetic overhaul with their Office products, ditching the dull grey toolbars and uninspiring menus. The vibrant, colourful Ribbon that first made such an impact in the new version of Microsoft Word is transplanted to Excel with stunning results.
It is also easier to use than the old tabs, with all the basic functions such as alignment and number format falling under the Home tab rather than being spread out elusively amongst half a dozen different tabs.
The style extends to the sheets themselves with colour-coded rows and a variety of text options, although the most exciting new development is undoubtedly SmartArt. The cumbersome, chunky and drab old charts of yore have been given a spectacular makeover and furnished with a number of new features.
There are over a 100 variations on offer in SmartArt and the cleaner, more concise Ribbon toolbar makes it much easier to format, refine and generally control your charts. A particular advantage is the ability to shade whole series of data in one click rather than laboriously creating rules for shading individual ranges one at a time - a major flaw in previous versions of Excel.
Advanced filtering and sorting are now also available. The Ribbon will allow you to filter by a wide range of criteria including date periods and text type all without interfering with the original formatting of the spreadsheet. Highlighting data has become more interesting also, with snazzier icons such as traffic lights and flags, whilst the new live preview option allows you to survey your handiwork and make any necessary adjustments prior to printing.
Microsoft Excel has always been the world's most popular spreadsheet, praised for its efficiency, accuracy and reliability. But in its 2007 incarnation it is also slick, stylish and sexier than ever before. There are so many exciting new features and attractive options within this product that cater to the casual home user as well as the business professional, transforming either the mundane or brain achingly complex into a straightforward yet rewarding activity.
Once you have learned the tricks and techniques for using Excel 2007 to its fullest there is no limit to the quality and dynamism of the work you will produce; spreadsheets and charts that not only inform but look great into the bargain.
|
 |
Please Rate: |
|
Rating: |
 Processing ... |
(Average: Not rated) |
| Views: | 20 | |
|
| More Articles from Software | | |
| Top Articles in Software | | |
|
