By setting up either a one-variable or two-variable data table, you can analyze the effects of varying inputs without altering your existing spreadsheet structure.

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.