Learn how your Excel 2010 worksheets' data can be understandable at a glance by applying conditional formatting to cells. See how easy it is by reading the quick-start step-by-step instructions or take 3 minutes to watch this tutorial video to learn how you can improve your next spreadsheet:
This keyboard shortcut has saved me lots of time when working with long documents and large spreadsheets:
Instead of scrolling down to hunt for the end of the text or the last spreadsheet cell, just press the Ctrl and End keys to quickly get to the bottom of the document.
When you have a spreadsheet that's chock full of numbers and statistics that's hard for your audience to interpret, you can have Excel create a chart from your data to better convey the meaning behind the numbers.
But what kind of chart should you choose? Which one will work best with the data you've got?
Printing from Excel can be frustrating if your spreadsheet is too wide or too tall to fit on a single page. If those last few columns or rows print on a second page, it makes the info harder to digest.
One option is to use the "Fit Sheet on One Page" command from the scaling drop-down menu to shrink the page — but that can make your spreadsheet way too small to read.
Instead, watch this 3-minute video to see Mary Sanseverino demonstrate a different way to print your large-ish spreadsheet on a single page:
It must be the wintery weather — my mind is on freezing things.
When you freeze a pane on an Excel spreadsheet, you're keeping a row or a column still while the rest of the cells below it can scroll freely. This step lets you view your column and row headings continuously while you scroll your document. This is great when you have a spreadsheet with enough data that you have to do a lot of scrolling to see all the cells, then lose track of the headers that label the columns.
Take 15-minutes to watch this demo to learn...
How to freeze & unfreeze rows and columns
How to print frozen rows or columns
The difference between freezing panes, locking cells, and splitting the window
Other tips that let you see and work with data more easily
When you create a new Excel file, it contains three worksheets — they show as small tabs at the bottom of a worksheet. Each tab has a name, like Sheet1, Sheet2, an so on. You can see the data stored on each worksheet by clicking the tab of the sheet you want to view.
Renaming a worksheet or changing the color of the worksheet's color makes it easier to organize and keep track of the data you've created.
Are you starting work on your 2014 calendar-year budget? When sharing it with your board of trustees or co-workers, you might want to add a "Draft" watermark to it, indicating it's a work in progress.
But Excel 2010 doesn't let you easily insert a watermark, unlike Word 2010. How can you do it?
It's easy to get lost in spreadsheets — if data fills lots of rows or columns, when you scroll down or across you lose sight of column or row headers, and then information loses its meaning.
Freeze Panes can help by letting you view column and row headings continuously, while you scroll your document. It lets you keep a row or column still, while the rest of the cells around it can scroll freely.
This keyboard shortcut has saved me lots of time when working with long documents and large spreadsheets:
When you have a spreadsheet that's chock full of numbers and statistics that's hard for your audience to interpret, you can 
When you need to compare data on two spreadsheets, here's a handy way to do it:
It must be the wintery weather — my mind is on freezing things. 
When you create a new Excel file, it contains three worksheets — they show as small tabs at the bottom of a worksheet. Each tab has a name, like Sheet1, Sheet2, an so on. You can see the data stored on each worksheet by clicking the tab of the sheet you want to view.
Are you starting work on your 2014 calendar-year budget? When sharing it with your board of trustees or co-workers, you might want to add a "Draft" watermark to it, indicating it's a work in progress. 
It's easy to get lost in spreadsheets — if data fills lots of rows or columns, when you scroll down or across you lose sight of column or row headers, and then information loses its meaning.