BY TOPIC▼
EXCEL / VBA BLOGS▼
EXCEL BLOGS▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
Blogs from Wise Owl on What-if analysis in Excel
Showing blogs 1-2 (out of 2)
Using Scenarios in Microsoft Excel
Posted by Andrew Gould on 27 February 2012
Scenarios are incredibly useful when performing "what-if analysis". They allow you to quickly swap a range of input values to test different possibilities without having to retype any values. Read on to find out how they work!
Goal Seeking in Microsoft Excel
Posted by Andrew Gould on 24 February 2012
Goal seeking in Excel allows you to approach calculations from the "result end" and get Excel to tell you what inputs you need in order to hit a specific target. Read on to find out how it works!