Lynda - Excel 2013: Managing Multiple Worksheets and Workbooks
Categories: Tutorials
Lynda - Excel 2013: Managing Multiple Worksheets and Workbooks - 158663
Lynda - Excel 2013: Managing Multiple Worksheets and Workbooks
Sometimes multiple worksheets or workbooks are the only solution to storing large amounts of data. But how do you analyze data that's spread out that way? In this course, author Dennis Taylor shows you how to move, copy, and analyze large amounts of data stored in multiple worksheets and workbooks in Excel 2013. Learn how to insert, delete, move, and copy data from multiple sheets; hide and un-hide sheets; and make global changes. Plus, discover how to create simple formulas that connect different worksheets, make super-efficient 3D formulas to calculate summary totals from multiple worksheets, and use PivotTables to summarize data from multiple workbooks.


Table of Contents

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

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


    Categories Sitemap



    rss