Get data from other worksheets and other workbooks using references and formulas like INDIRECT. Watch more Excel tutorials at http://www.lynda.com/Excel-tutorials/Excel-Tips/363001-2.html?utm_campaign=jPyDmHlIc5I&utm_medium=social&utm_source=youtube-earned

This tutorial is from the Excel Tips Weekly series presented by lynda.com author Dennis Taylor. The complete course is presented as a weekly lynda.com series and offers a new Excel tip every Tuesday on topics such as productivity-boosting tips, cool features and functions, and even advanced subjects such as using PivotTables for data analysis.

Connect with lynda.com:
Facebook: http://bit.ly/fbldc
Twitter: http://bit.ly/ldctw
Google Plus: http://bit.ly/gplusldc
LinkedIn: http://bit.ly/linkldc