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

Adrian
Course By

Adrian

Miricle Solutions was started in 2003 when Adrian Miric left KPMG to set up a consultancy focused on the safe and efficient use of excel in the corporate world. With this is mind the company has strived to provide the ultimate solution to all excel needs.

Lessons