Multi variable Excel data table- Excel sensitivities on steroids

Or log in to access your purchased courses

Multi variable Excel data table- Excel sensitivities on steroids

If you build detailed financial models you may wish you could use the Data Tables features to compare more than the 2 allowed by Excel. Perhaps you want to run a sensitivity using a 3 variable data table with 3 options in each?

Excel won’t allow this by default but there is a way you can do this! This course shows you how you can create it for yourself and provides templates which allow you to run the following permutations (# of variable by options in each variable)

  • 3 by 3
  • 3 by 4
  • 3 by 5
  • 4 by 3
  • 4 by 4
  • 4 by 5
  • 5 by 3
  • 5 by 4
  • 5 by 5

If you prefer to attend a live session, visit the MS Excel Advanced Courses Calendar

Modules