Main Profile

At A Glance

How to use 3D formulas in Excel | lynda.com tutorial

This Excel tutorial shows how to use 3D formulas to select a range of worksheets with identical layouts. Watch more at http://www.lynda.com/Excel-2010-tutorials/managing-multiple-worksheets-and-workbooks/75924-2.html?utm_medium=viral&utm_source=youtube&utm_campaign=videoupload-75924-0302 This specific tutorial is just a single movie from chapter three of the Excel 2010: Managing Multiple Worksheets and Workbooks course presented by lynda.com author Dennis Taylor. The complete Excel 2010: Managing Multiple Worksheets and Workbooks course has a total duration of 1 hour and 29 minutes and 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. Excel 2010: Managing Multiple Worksheets and Workbooks 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
Length: 05:40

Contact

Questions about How to use 3D formulas in Excel | lynda.com tutorial

Want more info about How to use 3D formulas in Excel | lynda.com tutorial? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question