Viewers: in countries Watching now:
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.
Hi. I'm Dennis Taylor, and welcome to Excel 2013: Managing Multiple Worksheets and Workbooks. In this course I'll show you the critical tasks associated with multiple sheet workbooks and inter-related workbooks. Included are techniques for navigating across worksheets and workbooks with both speed and confidence, displaying multiple worksheets or different workbooks simultaneously, and mastering the many utility tasks associated with multiple worksheets.
I'll show you how to insert, delete, move, and copy sheets. How to change the color of sheet tabs. How to make global changes to one or more adjacent or nonadjacent worksheets. How to create super efficient 3-D formulas. How to create linkage formulas between different work books. And how to use pivot table functionality to analyze and summarize data from different worksheets and workbooks. So let's begin Excel 2013: Managing Multiple Worksheets and Workbooks.
There are currently no FAQs about Excel 2013: 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.