Make Excel tables look more interesting
How can you quickly spruce up a spreadsheet and make it easier on the eye? Excel 2007 and 2010 have a great table design feature. Here’s a boring set of figures that we’re going to liven up: Set up a table First of all we need to tell Excel what data to format. Position your [...]
10 Outlook Tips
1. Auto-date Outlook’s auto-date feature can work out dates from words and phrases you type in. E.g. create a new appointment and, in a date field, type in “next week” then Enter. The date will automatically move on 7 days. “Next month” and “next year” work in the same way, as do “30 days” and [...]
10 Excel Tips
1. Go To Special dialog box You can use the Go To Special dialog box to select only the constants in a range of cells or select just the formulae or select all blank cells. Press F5 for the Go To box then press the Special button and select an option. 2. Paste Special As [...]
10 Word Tips
1. Layout tables Tables are much easier to use than tabs for positioning text and images on a document. You can remove the borders so it does not look like a table when the document is printed. You may see grid lines on the screen but they will not print out. Resize the columns and [...]
