Excel tips and tricks 2021 Sensitivity Analysis Excel mortgage scenari

Excel tips and tricks 2021 Sensitivity analysis in excel is one of the most useful functions for data tables, it'll give you as many outputs as you can program in for a few minutes of work. In this tutorial we'll get 100 items based on two variables, look at quick and basic refinance scenarios (DO YOUR OWN DUE DILLIGENCE THIS IS NOT FINANCIAL ADVICE) and how you can apply this to whatever scenario you'd like to. If you're a Redditor, take a look at the link below, I post some of the more popular videos up there and if you're interested, join the subreddit! excel tutorial for beginners 2021

Chapters:

00:00-00:27 Intro
00:27-01:27 Scenario to Analyze Description: Mortgage Payment
01:27-02:26 - Data Table & Scenario Analysis: What it can do for you
02:26-04:47 Example & How to run Scenario Analysis, optional conditional formatting for pizzazz
04:49-05:57 Basic refinance analysis, do your own due diligence!
05:57-06:40 Wrap up

  / exceldude