How to use Excel data tables

Don't waste time testing different values individually in Excel. Use a data table to show the results for many different possible scenarios at once.

----------------------------------------­----------

----------------------------------------­----------

Business Insider is the fastest growing business news site in the US. Our mission: to tell you all you need to know about the big world around you. The BI Video team focuses on technology, strategy and science with an emphasis on unique storytelling and data that appeals to the next generation of leaders – the digital generation.

[alexandriahatcher]

Beautiful... thanks for the quick and clear explanation!

[JoernSteinzskillday]

thanks, as usual an excellent well digestible piece of advice

[janinekromhout]

I work at Incisive Software, and our product, Xcellerator can also help with data comparisons of large data sets exported from ERP, CRM, or other cloud solutions and demonstrate/highlight what's changed right from within Excel.