How To: Use a data table for what-if analysis in Excel

Use a data table for what-if analysis in 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 253rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use a data table for what-if analysis. You'll also learn about the PMT and see the formula equivalent to a data table.

Just updated your iPhone to iOS 18? You'll find a ton of hot new features for some of your most-used Apple apps. Dive in and see for yourself:

1 Comment

thank you so much for your help, I did the problem with your help.
this program it is really help full

Share Your Thoughts

  • Hot
  • Latest