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:
Google Plus: http://bit.ly/gplusldc