Get FREE Advanced Excel Exercises with Solutions! Excel can handle much-sophisticated models than the preceding example. To perform a what-if analysis using Excel, you have three basic options: Manual what-if analysis: Plug in new values and observe the effects on formula cells. Data tables: Create a special type of table that displays the results of […]
