When teaching Excel modeling classes, Josh Kahr of Kahr Real Estate says he receives more questions about how to use the “what if” tools than anything else. It’s hard to explain in words how these tools work, so Josh created a couple videos explaining exactly how to use the “what if” tools in Microsoft Excel. Check them out:
Goal Seek
Data Table
Solver
Scenario Manager
What excel functions do you find most difficult?
Similar Posts:
- Microsoft Excel Shortcuts for Real Estate Professionals
- Manual Iterations, IRR Lookback’s, and Other Useful Excel Models
- S&L Redux: How Long Should we Expect to See Distressed Assets?
