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 […]
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. […]
