->
Lynda - Managing Multiple Worksheets and Workbooks with Excel 2007 - 62644
Lynda - Managing Multiple Worksheets and Workbooks with Excel 2007
In Excel 2007: Managing Multiple Worksheets and Workbooks, author Dennis Taylor shows how to move and copy data to multiple worksheets 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 different worksheets, make super-efficient 3-D formulas to calculate summary totals from multiple worksheets, and use pivot tables to summarize data from multiple workbooks. Exercise files accompany the course.


Table of Contents

  • Introduction
  • 1. Mastering Utility Tasks
  • 2. Working with Multiple Worksheets
  • 3. Linking Worksheets with Formulas
  • 4. Working with Multiple Workbooks
  • 5. Linking Formulas Across Workbooks
  • Conclusion
  • Lynda - Managing Multiple Worksheets and Workbooks with Excel 2007


     TO MAC USERS: If RAR password doesn't work, use this archive program: 

    RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


     TO WIN USERS: If RAR password doesn't work, use this archive program: 

    Latest Winrar  and extract password protected files without error.


     Coktum   |  

    Information
    Members of Guests cannot leave comments.




    rss