This month, James Yoder guides us through Excel’s What-If Analysis tools. With the start of the new fiscal year comes new budget parameters, new spending plans, and the like. Excel’s What-If Analysis tools can be a valuable asset to annual budget planning by allowing you to test both old and new financial data against possible budget options. These tools can also be applied to other facets of your data, empowering you with easy-to-use functions that help you make informed, data driven decisions.
Please see the below attachment to download the Excel Workbook James uses during the session. Feel free to build the tables and scenarios along with him!
What If (Tips and Tricks)