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
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
Creating Signatures in Outlook 2010
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
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
Word: Using the Navigation Pane in Word
When working on long documents, the Navigation Pane in Word can help you find and move sections easily. Doug Thomas from the Office Casual team shows you how, using Word 2010.
Viewing Side by Side
Someti
mes 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