Introduction to Financial Modelling Best Practice
MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 1 Hours | Lec: 9 | 898 MB
Genre: eLearning | Language: English

Gain inside knowledge of the key factors critical to financial modellers - from an expert financial modeller!

Assumptions Documentation

Linking Formulas vs "hard-coded" Values

Gain inside knowledge of the key factors critical to financial modellers - from an expert financial modeller!
If you're new to the modelling process, gain inside knowledge of the key factors critical to expert financial modellers. Each short segment provides an overview of the key principles and best practice for Financial Modelling in Excel on a daily basis.
Assumptions Documentation
Documentation of assumptions is a critical point of best practice. Garbage in and garbage out!
Linking Formulas vs "hard-coded" Values
Every input should have a single source cell in our model, so that any changes that are made flow right throughout the model.
Bad Modelling Habits
It's pretty easy to pick up Bad Habits. We'll look at a few bad modelling habits that are pretty common among Excel users!
Formula Consistency
Consistent formulas within a block of data will make building your model quicker and easier, not to mention more accurate
Clear Formatting and Labelling
Having your model's Formatting and Labelling clearly and correctly laid out makes your model easier to find your way around - both for you and someone else trying to interpret your model!
Tips and Tricks
You'll pick up lot of tips, tricks and shortcuts along the way
In each lecture, I'll take you through one of the key principles, give practical examples of how to apply best practice to your financial models. You'll learn lots of tips and tricks on using Excel for the purpose of financial modelling.
As an added bonus, you'll get an extra webinar recording on "Scenario Tools in Excel" which will teach you how to create scenarios in plain Excel without any add-ins or other software. Reduce uncertainty in decision making using built-in standard Excel tools to reduce volatility in outcomes by performing sensitivity and scenario analysis to mitigate risk.

DOWNLOAD
rapidgator
Kod:
https://rapidgator.net/file/05568b60f61fccc9ec3f7a906fdfeaa8/azIuXeMl_Introduction_to_Financial_Modelling_Best_Practice.part1.rar.html
https://rapidgator.net/file/e8304ff94a611cfca586da908c3d0171/azIuXeMl_Introduction_to_Financial_Modelling_Best_Practice.part2.rar.html
nitroflare
Kod:
http://nitroflare.com/view/3D8CC67D94479EA/azIuXeMl_Introduction_to_Financial_Modelling_Best_Practice.part1.rar
http://nitroflare.com/view/ADDA39D91AF4BDA/azIuXeMl_Introduction_to_Financial_Modelling_Best_Practice.part2.rar
uploadgig
Kod:
https://uploadgig.com/file/download/aB6F99a277C8A10b/azIuXeMl_Introduction_to_Financial_Modelling_Best_Practice.part1.rar
https://uploadgig.com/file/download/f00Cb3fdba18bC15/azIuXeMl_Introduction_to_Financial_Modelling_Best_Practice.part2.rar
turbobit
Kod:
http://turbobit.net/y4f3jbrjdhao/azIuXeMl_Introduction_to_Financial_Modelling_Best_Practice.part1.rar.html
http://turbobit.net/4cy6h1dukgkq/azIuXeMl_Introduction_to_Financial_Modelling_Best_Practice.part2.rar.html