Data Tables Instead of entering formulas and variables individually, to compare results, you can set up a Data Table, with one or two variables. Data Tables are one of Excel’s “What If Analysis” features With a Data Table in Excel, […]

Goal Seek Goal Seek is a built-in Excel tool that allows you to see how one data item in a formula impacts another. You might look at these as “cause and effect” scenarios. Whenever you create a formula or function […]

Excel includes many powerful tools to perform complex mathematical calculations, including what-if analysis. What-if analysis is a useful way of being able to test out various scenarios in Excel. You can look at these things two different ways. The first […]