Lynda - Excel 2010: Managing Multiple Worksheets and Workbooks

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.

https://www.lynda.com/Excel-tutorials/Excel-2010-Managing-Multiple-Worksheets-Workbooks/75924-2.html

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

Table of Contents

Would you like to be a Author?