In Excel 2010: Managing Multiple Worksheets and Workbooks, author Dennis Taylor shows how to share data between multiple worksheets and workbooks and gives tips for adding, moving, and navigating worksheets and workbooks efficiently. This course covers how to make global changes, create simple formulas that connect worksheets, make super-efficient 3D formulas to calculate summary totals from multiple worksheets, and use pivot tables to summarize data from multiple workbooks. Exercise files accompany the course.

Topics include:

So in this video training these main topics are covered:


  • Navigating across worksheets and workbooks
  • Displaying multiple worksheets or workbooks simultaneously
  • Inserting, deleting, moving, and copying sheets
  • Changing sheet names and tab colors
  • Showing and hiding worksheets
  • Creating linkage formulas among workbooks
  • Locating and managing links

Author: Dennis Taylor
level: Intermediate| Duration: 1h 29m | Released date: Jan 07, 2011
Official description here: http://www.lynda.com/Excel-tutorials/Excel-2010-Managing-Multiple-Worksheets-Workbooks/75924-2.html

**COMMENT BELOW IF THE LINKS ARE DEAD**
PASSWORD TO EXTRACT FILES: teampir8

 http://adf.ly/378753/embedupload-2624259




OPEN LINK, WAIT FOR 10 SECONDS AND CLICK 
 ON UPPER RIGHT CORNER