Pages
Posts
- Excel’s best feature hidden in plain sight – Using Styles
- Index and match versus lookups – when to use them
- Net Present Value and Internal Rate of Return
- Even Microsoft makes Excel mistakes
- Offset and Choose
- Dealing with Circular References
- Melbourne cup sweep
- The perils of data analysis – speeding fines and the road toll
- Nothing to hide, everything to fear – why metadata retention is bad for everyone
- Net Present Value by first principles
- Dynamic Charts
- Sensitivities and Scenarios
- Financial covenants series
- The pension asset test and taper rates
- Revenue, spending or entitlement – what’s the country’s problem?
Archives
- May 2016 (1)
- June 2015 (1)
- May 2015 (18)
- March 2015 (3)
- November 2014 (1)
- January 2014 (1)
- November 2013 (3)
- October 2013 (2)