Learn Microsoft Office

Microsoft WindowsLearn Microsoft Office has been created to help you further your knowledge of Microsoft Excel, Word, PowerPoint, Outlook and other Microsoft applications.

This blog will be constantly updated with useful articles and tips on a wide range of topics. Whether you are using Microsoft Office 2003, 2007 or 2010, there will be heaps of information on hand.

View articles >>

Excel2007

Visually analyse data with Conditional Formatting

ShareApplying conditional formatting allows you to change the format of the cells in your spreadsheet, depending on certain conditions. For example, you could highlight cells in a particular colour when the numbers in those cells match a certain value. This is set using a type of conditional formatting, “Highlight Cells Rules”. Types of conditional formatting …

Read more

Outlook2007

Get control of your mailbox 5: View settings

You can add and remove columns in your mail folder screen (each email folder can be set individually) so that you can view the information that is relevant to you. For example, if you do not categorise or follow up your emails then you would not need to view these columns. Similarly, if you have more than one email address you may need to have a column that shows which email account the email was sent to.

Read more