Lynda - Excel 2010: Managing Multiple Worksheets and Workbooks
Categories: Tutorials
Lynda - Excel 2010: Managing Multiple Worksheets and Workbooks - 75924
Lynda - Excel 2010: Managing Multiple Worksheets and Workbooks
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.


Table of Contents

  • Introduction
  • 1. Mastering the Utility Tasks Associated with Multiple Worksheets
  • 2. Working with Multiple Worksheets
  • 3. Linking Worksheets with Formulas
  • 4. Working with Multiple Workbooks
  • 5. Linking Formulas Across Multiple Workbooks
  • Conclusion

    • Lynda - Excel 2010: Managing Multiple Worksheets and Workbooks
    Information
    Members of Guests cannot leave comments.


    Categories Sitemap



    rss