This Excel trick will save you time and impress your boss

Please enable Javascript to watch this video

Here’s a really easy setup for displaying data in Excel. The key is to create dynamic named ranges. Watch the video to see how to do it in just a few easy steps.

Follow BI Video: On Facebook

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