This short video shows you how to make sure your headings don’t
disappear when you scroll through your spreadsheet.
Continue reading Excel: Freezing Panes to Keep Headings in View
Category Archives: Excel
Removing Image Backgrounds
You might want to use an image in a document, but only if you can get rid of some of he background. You can do this by editing the image from inside Word, Excel, Outlook or PowerPoint, without having to use any other software.
Continue reading Removing Image Backgrounds
Excel: Splitting Text Across Columns
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
Using Format Painter in Excel
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
Creating Sparklines 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