What makes a good data table?
A good data table has a clear header and description, so users know what they're viewing. Designers must also use legible typography and adequate spacing between columns and rows to make it easy for users to read and absorb content. Lastly (and most importantly), your data table must be user-friendly.
How to do a data table?
Go to the Data tab > Data Tools group, click the What-If Analysis button, and then click Data Tableā¦ In the Data Table dialog window, click in the Column Input cell box (because our Investment values are in a column), and select the variable cell referenced in your formula.