Join 2 other subscribers
Monthly Archives: July 2013
Date formats – don’t waste valuable information!
Don’t enter dates with full stops (eg 10.11.13) because Excel doesn’t store them as dates, meaning a lot of useful information is unavailable. Instead, use a slash (eg 10/11/13) or hyphen (10-11-13) when you enter dates. Excel then stores them … Continue reading
Posted in Uncategorized Tagged Data, Dates, formatting Leave a comment
IF statements – very useful, but take care!
IF statements really bring power to your spreadsheets. And multiple IFs, even more so. There are two main problems: Firstly, they can get very difficult to understand, particularly if you are working on someone else’s spreadsheet, or even your own … Continue reading
Posted in Uncategorized Tagged Formulae, Functions, Logic Leave a comment
Adjusting column width in Excel
The column width can be adjusted by going to the top of the column and dragging the cursor left or right. This manual method means you’re only judging by the few rows you can see on the screen. However, double-clicking … Continue reading
Posted in Uncategorized Tagged column width, formatting Leave a comment