OVERVIEW IN KEYWORDS

The following summarises the content of each course using key words. More information about each can be seen by clicking the “More details” buttons.

II. 1 Economics and Financial Evaluation

Measuring growth, time period conversions. Present values. Inflating and discounting. Interest compounding methods and formulas. Annuity formulas. Calculation of returns. Internal rate of return (IRR). Net present value (NPV). Comparison of IRR with NPV. Loans and mortgages. Implied interest rates. Time-value of money. Classical risk and return measures. Portfolio effects. Correlation and diversification. Capital Asset Pricing Model. Cost of equity. Weighted cost of capital. Introduction to financial statements. Meaning and interpretation. Core transactions and their effects. Business ratio analysis. Operating, financing and performance ratios. Dupont analysis. Variance analysis.

Modelling exercises and quizzes.

II.2 Data Analysis, Manipulation and Statistics

Databases in Excel. Filters and sorting. Excel Tables. Advanced filters and criteria-based extraction. Pivot Tables. Slicers. Drilldowns. Dynamic ranges and functions. Unique values, filters, and sorting. Variable-sized ranges. Advanced lookup functions. Data Structures for modelling. Statistical analysis and functions. Single- and multi-variable statistics. Confidence intervals. Linear regression. Multiple regression. Array calculations. Statistical analysis. Introduction to probability distributions. Inverse functions. Random sampling. Data manipulation with Excel. Cleaning and correcting. Splitting and joining. Flat tables. Identifying unique items. Creation of keys. Text and Date functions. Using PowerQuery for data analysis and manipulation. Loading data. Generating reports. Grouped queries. Pivoting and unpivoting. Appending and consolidating data sets. Advanced queries and manipulation with the M-language. PowerPivot. DAX measures. The Excel DataModel. Evaluation Contexts and Measures. Functions and iterator functions. Sensitivity analysis. CUBE functions. Time-intelligence.

Modelling exercises and quizzes.

Scroll to Top
error: Alert: Content is protected !!