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.
Do you like to play with your data? Thought so. This Excel-centric Office Show episode plunges into the world of data visualization, and shows you how to get better-looking, more meaningful charts without banging your head against the wall. And we've got some amazing things to show you that some folks have done with Excel, including -- speaking of head-banging -- a music video from AC/DC done entirely within Excel. Strange but true! After the break, guest blogger and Excel expert Anneliese Wirth gives you more info on how to explore the new features of Excel.
I promised you more information about sparklines and slicers- two of my favorite things in Excel 2010!
To recap, sparklines are like baby charts that fit right inside your worksheet cells. You use them to visually interpret a bunch of numbers and detect trends in your data. In the following table of sales figures, the sparklines tell you that with one exception, each category has its low point relatively early in the month. If you were to just stare at the numbers, it would take a lot longer to spot the pattern (and the exception).
Do you want to know more? If so, check out the following articles, videos, and blog posts.
If you use PivotTables, slicers will make your life a lot easier. Slicers are visual controls that allow you to quickly filter your data in an interactive way. By looking at the buttons, you can see exactly what's filtered and what's not. In this case, you're looking at customers with 1 or more children who also hold an undergraduate degree or higher:
Like sparklines, slicers are easy to use and customize. Here are some resources to help you get started:
-- Anneliese Wirth
Note from Doug: We'll have some upcoming posts on AC/DC and some of the other cool things we showed at the end of the episode. In the meantime:
Dude. Excel. Rocks. Literally. The "video" for AC/DC's "Rock and Roll Train" was actually created entirely in Excel. You saw an excerpt of it in "The Office Show: Visualizing Data," and you can see the entire thing here . I saw AC/DC in concert once,
je veux decouvrir le nouveau logiciel