This is the Excel trick that will change everything about how you work with data

Please enable Javascript to watch this video

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.

Follow BI Video: On Twitter

 

Read more stories on Business Insider, Malaysian edition of the world’s fastest-growing business and technology news website.