Ep 1. Working with Multiple Worksheets and Workbooks

Microsoft Excel 2016 - Training season 3 episode 1 titled "Working with Multiple Worksheets and Workbooks" is a must-watch for anyone who wants to learn how to manage and organize large data sets in Excel.

In this episode, the host provides an overview of how to work with multiple worksheets and workbooks within a single Excel file. The episode starts with a quick review of the basics of Excel such as navigating and selecting cells, entering data, formatting cells, and creating formulas. This is followed by an introduction to working with multiple worksheets within a single workbook.

The host explains how to add, rename, move, and copy worksheets within a workbook. Next, the focus shifts to working with data across multiple worksheets. The host demonstrates how to use formulas and functions to consolidate data from multiple worksheets into a single worksheet. He also shows how to use the Group and Ungroup feature to work with data in multiple worksheets simultaneously.

The second half of the episode is devoted to working with multiple workbooks. The host starts with an explanation of how to create a new workbook and how to add, rename, move, and copy worksheets across different workbooks. He then demonstrates how to use the Consolidate feature in Excel to consolidate data across multiple workbooks.

The host then gives tips on how to link data between different workbooks. He shows how to create a link between workbooks and how to update data automatically in one workbook when changes are made in another workbook. He also explains how to update links manually and how to break links between workbooks.

The episode ends with a discussion on how to protect worksheet and workbook data. The host explains how to password-protect worksheets and workbooks and how to restrict the data entry for cells.

Overall, "Working with Multiple Worksheets and Workbooks" is an informative and engaging episode that provides a comprehensive overview of how to manage multiple worksheets and workbooks in Excel. It is a great resource for anyone who wants to improve their Excel skills and increase their productivity when working with large data sets.