Archive | How To Excel

RSS feed for this section

20 Principles for Good Spreadsheet Practices

22 July
spreadsheet analysis

I recently received a link to an article from a fellow Excel fan in the UK that detailed 20 principles for good spreadsheet practices. I read through the article and I have to say they’ve done an excellent job of listing them. I am constantly asked to repair or redesign spreadsheets that adhere to few […]

Creating Pivot Tables In Excel

03 February
Microsoft Excel training

If you asked ten regular Excel users what the most complicated part of Excel was, nine would probably say PivotTables! It was always a source of frustration that Microsoft hid this amazingly powerful tool behind user front-ends that were unintuitive to say the least. They made a straightforward tool appear complex when it really wasn’t. […]