EXCEL / VBA BLOGS
BLOGS BY AUTHOR
BLOGS BY YEAR
Blogs from Wise Owl on What-if analysis in Excel
Showing blogs 1-2 (out of 2)
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!
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!