1. Welcome to the Course

    1. Programme Team

    1. Wikus Kruger

    2. Haydn Palliser

    1. 01. Basic Functions | Anchoring

    2. 02. Basic Functions | IF Function

    3. 03. Basic Functions | IF(OR) and IF(AND) statement

    4. 04. Basic Functions | SUMIF Function

    5. 05. Basic Functions | LOOKUP Function

    6. 06. Best Practice | Principles

    7. 07. Best Practice Formulas

    8. 08. Best Practice | Flags and Conditional Formats

    9. 09. Best Practice | Styles

    10. 10. Best Practice | Control Accounts

    11. 11. Data Validation

    12. 12. Named Ranges

    13. 13. Intro to debt and equity

    14. 14. Benefits of Leverage

    15. 15. Benefits of Leverage Extended

    16. 16. Benefits of leverage Old

    17. 17. Present Value Math

    18. 18. NPV Function

    19. 19. IRR

    20. 20. Basic Excel Shortcuts

    21. 21. Renewable Energy Course-Model Familiarization

    22. Microsoft Excel Shortcuts Key

    23. Glossary of Terms

    24. Pre-Course Assessment

    25. Demo File Download

    1. 01. What is Project Finance

    2. 02. Investment Structure

    3. 03. Passthroughs and Blockers

    4. 04. Role of Parties and Contractual Cashflow

    1. 01. Date functions and Model Timeline

    2. 02. Model walk-through (MWT) | Instructions

    3. 03. MWT (S1) | Model timeline

    4. 04. MWT (S2) | Funding sheet timing

About this course

  • Free
  • 65 lessons
  • 53 hours of video content