This short video shows you how to make sure your headings don’t
disappear when you scroll through your spreadsheet. The video uses Excel 2007, but applies to both Excel 2007 and 2010. If you are using Excel 2003, you can find the Freeze Panes option in the Windows menu.
Continue reading Excel: Freezing Panes to Keep Headings in View
Here’s one of the new features in Office 2010. You might want to use an image in a document, but only if you can get rid of some of he background. Now you can do this by editing the image from inside Word, Excel, Outlook or PowerPoint 2010, without having to use any other software.
Continue reading Removing Image Backgrounds
You may have text in your column that you would like to split across other columns, to make sorting your data and mail merging easier. For example, you may have a contact’s first and last name in one column, but would like to split these into sperate columns. This short video shows you how.
Continue reading Excel: Splitting Text Across Columns
You may have some formatting on your worksheet that you would like to copy into other cells. This video show you how to use Format
Painter to quickly copy the look of one cell to another or others!
Continue reading Using Format Painter in Excel
Sometimes it’s hard to see trends and patterns in your spreadsheet when
dealing with large amounts of data. Sparklines, introduced in Excel 2010, are small charts that fit into a single cell which help you quickly track and highlight
important trends. In this blog, I’m going to show you how to create Sparklines in your spreadsheet.
Continue reading Creating Sparklines in Excel 2010