Get yourself trained on Financial Modeling 101 with this Online Training Financial Modeling 101.
Online Training Financial Modeling 101
Welcome to Financial Modeling 101In these tutorials you will learn the top 5 formulas used in financial modeling:Lecture 1: How to Build Uniform FormulasIn this video, you are going to learn:Essential Excel formulas and basic accounting theories that you will need to know to perform accurate financial modeling in the future!How to do ratio analysis there is much more to it than just comparing The top five most useful formulas in financial modeling plus, what is the most frequently used formula and why!How to easily quick fix broken formulas and much more!This video is a terrific introduction into financialmodeling and will give you a much better understanding of the process andwhether it is something you want to pursue to advance your career.Lecture 2: Building Dynamic Formulas In this tutorial, you are going to learn:Howto evaluate companies and how to perform comparable company analysisHow to build dynamicformulas using VLOOKUPHowto troubleshoot for errors and correct them quickly and easily!2 reasons why using VLOOKUPis so effective in building dynamic formulasAndmuch moreLecture 3: Value Cashflow Outlay In this lecture, you are going to learn:How to value cashflowoutlayHowto use more advanced financial modeling techniques and perform sensitivityanalysis in different scenariosHow to calculate the netpresent value of cash flow outlay using NPV2big reasons why NPV is such a powerful and convenient formula to use to calculatecash flow outlaysAnd much moreLecture 4: Sensitivity AnalysisIn this lecture you will learn:How to perform sensitivityanalysis with a Data Table2reasons why Data Table is so important in sensitivity analysisAnd much more
Udemy helps organizations of all kinds prepare for the ever-evolving future of work. Our curated collection of top-rated business and technical courses gives companies, governments, and nonprofits the power to develop in-house expertise and satisfy employees’ hunger for learning and development.
Learn on your schedule with Udemy
Investing in yourself through Learning
As a society, we spend hundreds of billions of dollars measuring the return on our financial assets. Yet, at the same time, we still haven’t found convincing ways of measuring the return on our investments in developing people.
And I get it: If my bank account pays me 1% a year, I can measure it to the penny. We’ve been collectively trained to expect neat and precise ROI calculations on everything, so when it’s applied to something as seemingly squishy as how effectively people are learning in the workplace, the natural inclination is to throw up our hands and say it can’t be done. But we need to figure this out. In a world where skills beat capital, the winners and losers of the next 30 years will be determined by their ability to attract and develop great talent.
Fortunately, corporate learning & development (L&D), like most business functions, is evolving quickly. We can embrace some level of ambiguity and have rigor when measuring the ROI of learning. It just might look a little different than an M.B.A. would expect to see in an Excel model.