You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
But even so, an old hat (like the Hogwart's sorting hat) can discover new tricks that it didn't know were possible. Excel 2010 has some really great new additions as well as improvements (I probably shouldn't use that word--improvements--but everything and everybody can fashion some room within themselves in order to to squeeze some in...right?).
And then one day the clouds part and Dionysus, the Greek god of wine and partying AND fertility--which, in our context here, means productivity--smiles his sweet, naughty, benevolent smile down at you and y ιδού* you are anointed! But with what?
Read on to find out...
As an example, if you've been using Excel 2007, what was new to you a few years ago (the Ribbon) and then admittedly became indispensable, has had a boost for the 2010 version; a touch up, an improvement (that, by the way, a good many of you requested). And if you've been using versions prior to Excel 2007, you're getting something new (the Ribbon) AND it's been perfected.
But there are more, um, additions to what was already pretty good that you might be able to mkae use of.
First up: the ribbon reaching out to the nonconformist in you:
Here's a feature you really wanted...and now you get it. When the ribbon was introduced in Excel 2007, although it was possible to add commands to a Quick Access Toolbar (the QAT), you couldn't add your own tabs or groups on the ribbon, dang-it! In Excel 2010, however, you can create your own tabs and groups and rename or change the order of the built-in tabs and groups. Sweet!Read more about customizing the ribbon
What better time could there be than now, the holiday season, to talk about sparklines. Even though the name is so cute and festive that you want to either dunk it in your coffee or drape it over your Christmas-decorated mantel, these effervescent little guys can help you to discover patterns or trends in your data making it more useful for you.
Sparklines are tiny charts—the good kind of computer gremlins, actually—that fit inside a single cell that can visually summarize trends alongside data. They're particularly useful when you need to show a snapshot of something in an easy-to-read format. Run, do not pass GO, do not collect our $200 (which is, by the way, it's only TWO dollars in Monopoly Junior!) and watch Doug's Office Casual video about sparklines. Doug just has a certain..."everyman's" flare for explaining things, and I often feel that he and I have the same sensibility of what Office customers want to learn and how they want to learn it...
If you like just simple images as examples, in the example below, you can see, at a glance how each (fictional) department performed in May:
(But I know, this image is static; it doesn't really tell the story in a particularly meaningful way, so again—and don't be a boob about it, please—go see Doug's Office Casual video about sparklines .
AutoFilter buttons now remain visible along with table headers in your table columns, so you can sort and filter data quickly without having to scroll all the way back up to the top of the table.
(I like this video; the guy who created and narrates it has this nice, soothing, "it's-as-easy-as-pie" (which it is) way of narrating and running you through it.
Go find out for yourself what else is new—and improved—(oops...I did it again!) in Excel 2010.
*y ιδού means voilà in Greek
This is exactyly how I feel on a Friday - drained of all content!!!
Keep up the good work though Crabby, we love your tips.
Oh Lordy! The best intentions. Think of it this way: go find what you live about Excel 2010 and report back...
Content......a real eye opener thank you for this ^.^
Well...I'm glad to see my readerse have a sense of humor!
Sorry gang -- I'm writing now (while eating breakfast and shuffling the kid off to school...) Crabby never rests!
Ok <whew> - I really do love these features; I didn't want them left out in the rain (like I'm about to go into...it's pouring here!!!)
Thanks for your patience, readers. Have a great weekend.
I want to thanks all of you who've written to me at MSFTCrabby@hotmail.com to say that you enjoy my columns (and also call out the "Find of the day" items at the end of each post). It means a ot to know someone is out there reading and *getting* my message.
I'll have a post for this Friday, the 24th (PowerPoint), one for Monday (shortcuts and tricks to figuring out the ribbon), and then on Wednesday I’ll do my yearly (my 9th one and still, ONE resolution has yet to be...resolved). And finally, on Weds., December 31st, I’ll do a yearly wrap up that will be about whatever I’ve been thinking/hearing/writing/musing about—not all Office/Microsoft or even techie stuff—but certainly not political stuff because I value my job and anyway, my job isn’t about expressing my views about that one way or another…. We’re all equal (and connected), in Office’s World…
I hope all of you HAD a Happy Hanukkah, and that your Christmas is merry and bright, and your New Year full of blessings, happiness, good health...with just a soupçon of crabbiness (a little spice never hurt anyone).
Hrmm that was weird, my comment got eaten. Anyway I wanted to say that it's nice to know that someone else also mentioned this as I had trouble finding this same info elsewhere. This was this first place that told me this answer. Thanks.
I really appreciate the effort you have given to this post. I am looking forward for your next post. I found this informative and interesting blog. I just hope you could make another post related to this. This is definitely worth reading.
Interesting article. Were did you got all this information from...
Crabby...can you please help me? I want to create an excel spreadsheet that helps me manage talent progress in my organization. I need to list employees by department, and then have the dept. heads identify each ee's readiness for the next step (Ready Now, Ready in 1 year, etc.) What I'd like to do is have them enter a value (perhaps "x") in the column, have that column change colors to visually indicate readiness, and then have the employee's data roll up to a separate spreadsheet for each readiness level. Ultimately, all Ready Now, Ready in 1 year employees will be presented to our Exec team, so if we can accomplish this, each department's readiness levels should be easy to extract and my HR Coordinator will be able to keep her hair...Is this possible?
@kss91 I'm sure it IS possible but here, in this blog format, is not the place to figure it out. My suggestion to you is that you pose your question at Microsoft Answers (answers.microsoft.com/.../default.aspx) which is a free online discussion group. It's patrolled by experts such as our MVPs (Most Valuable Processionals - experts but not MS employees), some MS employees, and other real "power users." I've never asked a question there that hasn't received an answer.
So: Go to Microsoft Answers, drill down to the application you're needing to ask the question about, and then find the appropriate category. Search for what you think is similar to your problem, and if you don't find any other questions like it, go ahead and ask a question yourself. (Be sure to select the box that indicates you want to be notified by email when someone has responded to your post).
Also: Ask your question of any of our Excel MVPs: mvp.support.microsoft.com/.../mvp.aspx