To make good decisions, finance professionals need to use many analytical tools. In this course you will learn how to use analytics to improve decision making in the following areas:
Behavioral Finance – The Intersection of Psychology and Finance (1 Hour 45 Minutes)
In this video, we discuss how knowledge of psychology, and behavioral biases can give you insights into market behavior and investment decisions.
Financial Risk – Financial Risk for Institutions (1 Hour 46 Minutes)
In this lesson we discuss many risks affecting financial institutions including credit risk, liquidity risk, interest rate risk, mortgage-backed securities, interest rate risk, and capital structure
Capital Budgeting – Basic Formulas Part One (1 Hour 42 Minutes)
This video explains how to copy a formula not involving “$” signs.
Finance Optimization Models – Finding Optimization in Corporate Finance (1 Hour 52 Minutes)
In this video, we cover everything from loan and retirement optimization, short term investment strategies, and how to optimize capital budgeting for project selection.
Finance Simulation Models – Monte Carlo Simulation in Finance (1 Hour 42 Minutes)
This video explains how to use Monte Carlo simulation in finance to model uncertainties in certain situations.
Portfolio Optimization – Mathematics of Asset Allocation (1 Hour 43 Minutes)
In this lesson, we explore the mathematics of asset allocation and show you how to navigate the risk return tradeoff in your investment decisions.
Real Estate Part One – Complex Real Estate Formulas Made Easy (1 Hour 46 Minutes)
In this lesson, we show how Excel financial functions make complex real estate calculations a breeze.
Real Estate Part Two – Valuation – Real Estate Valuation (1 Hour 47 Minutes)
In this topic, we discuss various methods for valuing residential and commercial real estate.
Real Estate Part Three – Secondary Mortgage Markets – Understanding Mortgage-Backed Securities (1 Hour 48 Minutes)
In this video, we demystify CMO’s, CDO’s, and mortgage-backed securities.
Rent or Buy Lease or Own – Analyzing Purchasing Methods (1 Hour 46 Minutes)
In this video, we discuss whether you should buy or lease a car or buy or rent a home.
Real Options – How to Price Options (1 Hour 46 Minutes)
In this video, we show how to use Excel and Monte Carlo Simulation to price options. Then we show how option theory can be used to value flexibility in corporate decisions.
Technical Analysis – How to Test Trading Rules (1 Hour 51 Minutes)
In this video, we show you how to develop and test trading rules that are based on the past pattern of an investment’s prices.
Best professor I’ve ever had. I’d take him for anything and think he could teach anything, but Decision modeling in spreadsheets was the best, most relevant (for a finance major like me at least) class I had as an MBA student. Hope you are well Professor Winston!
I’m on day 4 and already feeling more knowledgeable and empowered!
I’ve enjoyed the training very much. I’ve been using excel for many years, but with Wayne’s training, I’ve been able to do things quicker which saves me time and allows me to complete my projects faster. I recommend this training. It’s awesome. Thanks Wayne.
Yes! If you finish at least 50% of the course within the first 60 days and aren't 100% satisfied, we will issue a 100% money back gaurantee, no questions asked.
How does forever sound? All of our courses offer lifetime access. So just invest in yourself once, and have the course forever.
Yes! Once you enroll, you can download any of of the files. The before and after files are included in the course which will help you be able to easily follow along. Please note that the videos can not be downloaded.
Currently we only have lifetime plans.
We add new content regularly. With OFFICE 365, there are new functions being released quarterly. So as they are released, we will make new content covering the functions. These updates are included in the lifetime access.
The Financial Analytics Course is built from Dr. Winston’s more than 40 years of teaching at the most prestigious universities as well as Dr. Winston’s life’s work and covers all things Excel. Dr. Winston has over 40 years of experience teaching at the top universities and Fortune 500 companies in the world as. Take a look above at any of the course outlines to see EXACTLY what you will learn.
There was a problem reporting this post.
Please confirm you want to block this member.
You will no longer be able to:
Please note: This action will also remove this member from your connections and send a report to the site admin. Please allow a few minutes for this process to complete.