100%

# Core Skills: Excel, Economic Modelling, and Data Analysis

### OVERVIEW

The courses in the Core Skills program contain the foundations needed to build and use economic models and conduct data analysis in Excel.

## Essentials of Modelling with Excel

The definition of modelling Â· Purpose, uses, application areas Influence diagrams Â· Links between modelling and data analysis Â· Generic model types. Principles to design and build useful models that support decisions. Decision criteria in business and finance. The skills required to be a well-rounded financial modeller and analyst.Â Excel as a modelling tool Â· Creating formulas Â· Manual and automatic calculation Â· Mapping a model concept into calculations Â· Dependency and precedents tracing. Copy, paste, insert, delete, undo Â· Find/Replace Â· Wildcard characters Â· Named ranges Â· GoTo and GoTo Special Â· Efficient selection of ranges Â· Navigation around a model. Formatting Â· Conditional formatting Â· Custom formatting. Sensitivity analysis Â· DataTables Â· One-way analysis Â· Two-way analysis Â· GoalSeek. Principles of effective visual communication Â· Using graphs and charts. Tips and tricks Â· Short-cuts and KeyTipsÂ Â·Â CoreÂ Excel functions to capture logic, conditionality, comparison and aggregation. 8 Quizzes.

## Economic Modelling: Calculations, Criteria and Functions

Payback periods Â· Scenario modelling Â· Lookup functions Â· Growth formulae and present values. Measuring growth Â· Classical and logarithmic measures Â· Growth calculations Â· Inflating and discounting Â· Time-value-of-money. Risk-free rates. Interest calculations. Compounding methods and formulas Â· Accruals Â· Bootstrapping Â· Yield curves. Time-period conversions Â· Annuities and terminal values. Economic Evaluation. Calculation of returns Â· Internal rate of return Â· Limitations to calculation of returns Â· Discounted cash flow, net present value Â·  Calculations of loan amortisation and mortgages, implied rates and values. 5 Quizzes.

## Introduction to Data Analysis and Statistics

Databases Â· General versus database structures Â· Excel Tables Â· Filters and sorting Â· Advanced filters and criteria-based extraction Â· PivotTables Â· Introduction to PowerPivot and the data Model Â· Excel functions for data analysisÂ· Aggregation functions Â· Database functions Â· Dynamic sorting Â·  Basic aspects of data manipulation, cleaning, splitting and integration Â· Unique values and duplicates  Â·  Statistical functions Â· Single variable statistics (e.g. averages, percentile, standard deviations) Â· Confidence intervals Â· Multi-variable statistics (e.g. correlation, rank correlation, Kendallâ€™s tauÂ· Linear regression Â· Multiple regression Â· Array calculations and bespoke logic. 5 Quizzes.

## Model Planning, Design and Best Practices

Context and objectives. Addressing the right decision Â· Frameworks and tools for analysis and development of business strategy Â· Decision criteria Â· Economic criteria Â· Ratio analysis Â· Dupont analysis Â· Determination of model variables, flow and granularity Â· Horizontal or vertical time axis Â· Links to interest compounding Â· Data sources, structures and model types Â· Database approaches to modelling Â· Historical versus forecasted analysis Â· Logic reversals Â· Updating requirements Â· Structural limitations versus parameter flexibility Â· Allocations, linear and non-linear Â· Time allocation with triangles Â· Corkscrew structures Â· Waterfall allocations Â· Checking consistency and error-elimination. Designing for modularity. Approaches to linking modules Â· Selection and exclusion structures Â· Consolidation and inclusion structuresÂ· Appending data sets together (introduction) Â· Modelling sequences of decisions Â· Best practices in Excel modelling Â· Choices of structure Â· Principles of transparency Â· Dealing with circularities. Complexity reduction and optimisation.

.

## Core Skills: Model Planning, Design and Best Practices Michael Rees Ensure models are planned to be able to address the right decisions and issues, and use structures, layout and formatting that are flexible and transparent. Free

error: Alert: Content is protected !!