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 have probably noticed that emails from businesses usually have a
signature. This will incorporate the details of the sender, including their name and position in the company, together with the company details and often the
company logo. You can create your own signature, whether you are a business or an individual, in Outlook. This step-by-step guide shows you how.
Continue reading Creating Signatures in Outlook 2010
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
When working on long documents, the Navigation Pane in Word 2010 can help you find and move sections easily. Doug Thomas from the Office Casual team shows you how.
Continue reading Word: Using the Navigation Pane in Word 2010
Sometimes you want to be able to look at two documents at the same time. Perhaps you are referring to one document, whilst updating another. In this Blog, we show you how to view documents side by side in both Word and Excel. Continue reading Viewing Side by Side