all tutorials

• Excel - Advanced
  • Calculate NPV without Excel formulae
  • LOOKUP instead of VLOOKUP and HLOOKUP
  • Custom formats in Excel
  • Data Validation in Excel
  • Goal Seek function in Excel
  • Range names in Excel
  • Excel Data Tables in any sheet
  • An iterative approach to calculating the Internal Rate of Return (IRR)
  • How to use SUMPRODUCT
  • Custom number formats - Formatting decimals
  • Cashflow Available for Debt Service (CFADS)
  • Benefits of using Excel shortcuts: get your shortcut sheet
  • Cash Sweep Analysis in Project Finance
  • Circular Interest – Interest on average balances
  • Project Life Cover Ratio
• Excel - Basic
  • Array formulas in Excel
  • ICAA Conference: Get Corality’s presentation and excel files
  • Excel 2007 Styles Shortcut Tool
  • Using trend lines to analyse patterns in historical data
  • Excel offset function increases modelling risk
  • Custom number formats - Formatting text
  • Debt Sculpting to Target DSCR without VBA
  • Calculate IRR in Excel
  • Debt Service Reserve Account
  • Organisational benefits of implementing best practice financial modelling
• Visual Basic for Applications (VBA)
  • Dynamic map using Excel and VBA