Lynda - Excel 2016: Managing Multiple Worksheets and Workbooks
Categories: Tutorials
Lynda - Excel 2016: Managing Multiple Worksheets and Workbooks - 578059
Lynda - Excel 2016: Managing Multiple Worksheets and Workbooks
In this short, task-focused course, learn how to grapple with a common Excel problem: managing large amounts of data contained in multiple worksheets and workbooks. Follow Dennis Taylor as he takes you through how to move, copy, and link data across multiple worksheets. Dennis shares tips for adding, moving, and navigating worksheets and workbooks efficiently. He covers how to implement global changes, create formulas to connect worksheets and calculate data from multiple worksheets, and use PivotTables to summarize data from multiple workbooks.


Table of Contents

  • Introduction
  • 1. Utility Tasks Associated with Multiple Worksheets
  • 2. Working with Different Worksheets Together
  • 3. Working with Multiple Workbooks
  • 4. Linking Formulas across Multiple Workbooks
  • Conclusion

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


    Categories Sitemap



    rss