Sunday, July 3, 2011

Oprah's - I mean the Crabby favorite things: Excel 2010

But still an old hat (as the Hogwarts Sorting Hat) can discover new tricks, who do not know it would be possible. Excel 2010 has some really great new additions, and improvements (I should probably not use this word-improvements-but everything and everyone to some rooms to itself to some squeeze Mode...richtig?).

And then one day the clouds part and Dionysus, the Greek God of wine and partying and fertility-means, in our context here, productivity-smiles be cute, naughty, benevolent smile after below you and y ?d?? * you are anointed! But with what?

Read to find out...

As an example, if you use Excel 2007 have, what was new for you a few years (the Ribbon) and was then although essential, had a boost for the version 2010; a touch up, an improvement (, that, by the way, a good many of you requested). And if you've been with versions earlier than Excel 2007, you something new (the Ribbon always are) and it is been perfected.

But there is more, uh, what was already pretty good additions, that you may be able to Mkae use of.

First up: the band in order to achieve the nonconformist in you:

Here is a function that really wanted to you... and now you get it. The Ribbon in Excel 2007 introduction, although it was possible to add in a quick access toolbar ( QAT) commands you could not add your own tabs or groups on the Ribbon dang it! In Excel 2010, however, can create your own tabs and groups and rename or change the order of the built-in tabs and groups. Sweet!

Learn more about customizing the Ribbon

What better time than now, it's the holiday season, about Sparklines speak. Although the name is so nice and festive, dunk it in your coffee or drape it over your Christmas decorated coat would help this effervescent little guys you, patterns and trends in your data, so that it is more useful for you to discover.

Sparklines are tiny charts - the good nature of the computer gremlins, actually - that fit in a single cell that can visually combine trends in addition to data. They are especially useful if you want to view a snapshot of it all in an easy-to-read format.

You, do not GO pass, our $200 (which, by the way, is it only two dollars in monopoly junior!) to collect and to see Doug's Office casual video of Sparklines. Doug has only a certain... "everyman's" flare to the explanation of things, and I often feel that he and I have the same sensitivity of what Office customers want to learn and how they want to learn...

If you want to only see simple images as examples, in the following example, at a glance you as any (fictional) Department in may carried out:

Example of sparklines

(But I know this image is static, it does not really tell the story particularly useful, so again - and be a boob about you, please - go see Doug's Office casual video about Sparklines .)

AutoFilter buttons now stay visible with table headers in your table, so that you can sort and filter data quickly and without a scroll all back up the way to the top of the table.

(I like this video, the guy who created and it tells this beautiful, soothing, "it's as easy as pie" (what it is) tell and run through it.)

Go find you out for yourself, what's new - and improved (oops...)(I have it again!) in Excel 2010.

Office partner

* y ?d?? means voila in Greek


View the original article here

No comments:

Post a Comment