Monthly Archives: July 2013

Date formats – don’t waste valuable information!

Posted on 28 July 2013 by spreadsheetexpertblog

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 , , | Leave a comment

IF statements – very useful, but take care!

Posted on 28 July 2013 by spreadsheetexpertblog

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 , , | Leave a comment

Adjusting column width in Excel

Posted on 28 July 2013 by spreadsheetexpertblog

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 , | Leave a comment