Start learning with our library of video tutorials taught by experts. Get started
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.
Hi! I am Dennis Taylor, and welcome to Excel 2010: Managing Multiple Worksheets and Workbooks. Putting a lot of data into just one worksheet is not always the most efficient way to store data. Excel's multi-worksheet capabilities give you many tools and techniques for data management control. In this course, I'll show you the critical tasks associated with multiple sheet workbooks and interrelated workbooks. Included our techniques for navigating across worksheets and workbooks with both speed and confidence, displaying multiple worksheets or different workbooks simultaneously, mastering utility tasks associated with multiple worksheets such as inserting, deleting, moving, and copying sheets, as well as changing the color of sheet tabs and hiding and un- hiding sheets, making global changes to one or more adjacent or non-adjacent worksheets, creating super-efficient 3D formulas to calculate summary totals for multiple worksheets, creating linkage formulas between different workbooks, and moving or copying worksheets or selected data from one workbook to another.
Using these tasks and techniques can make work more efficient and more pleasurable. So let's begin Excel 2010: Managing Multiple Worksheets and Workbooks.
There are currently no FAQs about Excel 2010: Managing Multiple Worksheets and Workbooks.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.