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
You have permission to publish this article for free providing the "About the Author" box is included in its entirety.
Do not post/reprint this article in any site or publication that contains hate, violence, porn, warez, or supports illegal activity.
Do not use this article in violation of the US CAN-SPAM Act. If sent by email, this article must be delivered to opt-in subscribers only.
If you publish this article in a format that supports linking, please ensure that all URLs and email addresses are active links, without the rel='nofollow' tag.
Software Training London Ltd. owns this article. Please respect the author's copyright and above publication guidelines.
If you do not agree to these terms, please do not use this article.
HCA International Ltd Accounts Payable Assistant Ian Tedstone
"Not relying on too much role play or having to act out to others in the group made the course more enjoyable and put you at ease not worrying about it."
FERROVIAL AGROMAN Quantity Surveyor Juan Cerezo
"This is an interesting course in which you can improve your reporting skills by learning different ways of creating spreadsheets such as pivotables or macros."
Dealogic Ltd Research Associate Olga Nikitina
"Great,
I had an advanced one last year with another teacher, this one is so much better, explained everything, did not skip anything, we managed to practice on every topic.
Excel articles
