This column shows how to use the Data Table option in Excel’s What-If Analysis tool.

Single-variable equations are among the easiest to construct when using this tool. Use the Equation Editor to insert an equation into any cell in your Excel worksheet.

Excel can solve for unknown variables, either for a single cell with Goal Seek or multiple cells with Solver.

How to Set Up an Ordinal Variable in Excel. An ordinal variable is a number that shows the position of an object within a series of objects with the use of a suffix, for example, "1st" or "453rd ...