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 Twitter: http://bit.ly/1oS68Zs
Follow BI Video On Facebook: http://on.fb.me/1bkB8qg
Read more: http://www.businessinsider.com/

—————————————-­———-

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.

Please take the opportunity to connect and share this video with your friends and family if you find it useful.