2. Financial Modelling with Excel (II)

Typical logic and building blocks · Growth calculations · Ratio-based calculations · Linear allocations · Non-linear allocations · Corkscrew structures Conditional calculations · Aggregation calculations · Waterfall structures · Flag fields · Look-up processes · Error-checking · Model planning · Mapping objectives to models · Influence diagrams · Decision trees · Further topics in best practices

See more...

1. Financial Modelling with Excel (I) Note: Completed Structure

Models as decision tools · The meaning of decision quality · Excel essentials · Excel functions · Short-cuts · Auditing · Mapping objective to formula · Sensitivity analysis · Scenario analysis · Data Tables · GoalSeek · Variance analysis · Modelling best practices · Optimising model layout · Principles of effective visual communication · Results presentation · Graphs and charts

See more...

Free

FINAL CERTIFICATION BASED ON QUIZ AND EXERCISES. ALL COURSES AS PREREQUISTE

TBD

See more...