Course curriculum

    1. Welcome to the Course

    1. Course Overview

    1. FMUTS Time-table

    1. Programme Team

    1. Dr Peter Twesigye

    2. Dr Martin Rodriguez Pardina

    3. Haydn Palliser

    1. Pre-Video 01 | UCT Course Introduction

    2. Pre-Video 02 | The Rationale for Regulation

    3. Pre-Video 03 | Incentives for Productive Efficiency

    4. Pre-Video 05 | Estimating Revenue Requirements | (B) Example

    5. Pre-Video 06 | NPV Function

    6. Pre-Video 07 | IRR

    7. Pre-Video 08 | Excel functions - Anchoring

    8. Pre-Video 09 | Excel functions - IF Function

    9. Pre-Video 10 | Excel functions - IF(OR) and IF(AND) statement

    10. Pre-Video 11 | Excel functions - SUMIF Function

    11. Pre-Video 12 | Excel functions - LOOKUP Function

    12. Pre-Video 13 | Best Practice - Principles

    13. Pre-Video 14 | Best Practice - Flags and Conditional Formats

    14. Pre-Video 15 | Best Practice - Styles

    15. Pre-Video 16 | Best Practice - Control Accounts

    16. Pre-Video 17 | Excel shortcuts and Introduction

    17. Pre-Video 18 | Final Model Overview

    18. EXERCISE | Excel Shortcuts download

About this course

  • Free
  • 35 lessons
  • 3 hours of video content