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.

While you're stuck at home, make the most of your time by learning a new language, skill, or even train for a remote-work job with our new premium online courses.

Check them out >

Our Best Phone Hacks

Gadget Hacks' tips — delivered daily.

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