Category: Management

June 19, 2016 david.taylor No comments exist

“What-if analysis” goes visual using Power BI Financial models in Excel are usually limited to calculating results for a single scenario at a time.  “What-if analysis” allows financial models to also calculate results for other scenarios; varying the underlying drivers and assumptions. Visually compare many scenarios As a decision maker, why not look at the results for several…

March 22, 2016 David Taylor No comments exist

Spreadsheet models can become error prone, labour intensive and unable to scale if they are allowed to grow un-checked.  A culprit is the VLOOKUP formula. LOOKUP allows authors to connect and cross-reference between tables of values from one area or document to another. Workbooks that are reliant upon VLOOKUP formulae can be re-structured to more cleanly combine…