How To: Create a two-variable data table in Microsoft Excel

Create a two-variable data table in Microsoft Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 255th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a two-variable data table in Excel for what-if analysis. See the PMT function and learn about the formula equivalent to a data table.

Other What If Analysis videos:

Excel Magic Trick 253: Data Table 1 Variable What If Analysis
Excel Magic Trick # 254: Data Table Creates 100 Formulas
Excel Magic Trick 255: Data Table 2 Variable What If Analysis
YTLE#103: Excel Goal Seek
Highline Excel Class 22: Scenarios & Scenarios Report

This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109

Get the Gadget Hacks Daily

Our latest smartphone hacks — straight to your inbox.

1 Comment

please, how to work with 1 variable PMT change apr only

Share Your Thoughts

  • Hot
  • Latest