Ep 6. Managing Workbooks

The episode titled "Managing Workbooks" is the sixth installment of the Microsoft Excel 2016 - Training series. This episode dives into the various methods and techniques to efficiently organize and manage workbooks, while also exploring tools that can help users effectively handle multiple sheets in a workbook.

Throughout the episode, viewers are introduced to the "Backstage View" feature, which provides a centralized location for managing workbooks. This feature allows users to access all workbook-level settings, including permissions, information, and properties, all from one place. The "Backstage View" also enables users to save and share workbooks, set document-level themes, and alter security settings.

In addition to the "Backstage View," the episode discusses how to utilize the different workbook views. Excel offers three main views: Normal view, Page Layout view, and Page Break Preview. The episode explains the differences between these views and how each can be useful in different situations.

Another important aspect of managing workbooks is organization. In Excel, users can group worksheets together, rename individual sheets, and even color code tabs for easy identification. The episode goes over each of these techniques to show viewers how to effectively manage large workbooks with multiple sheets.

The show also explores how to transfer data between workbooks, including copying and pasting information, and using the "Move or Copy" tool. This tool enables users to quickly and easily move or copy entire sheets or selected sheet data to another workbook.

Next, the episode delves into workbook protection. Excel allows users to protect workbooks by setting a password, which can be required to open the workbook or make changes to any of the sheets within the workbook. This can be especially useful in situations where sensitive information is being stored in the workbook.

Finally, the episode addresses printing and sharing workbooks. Excel offers multiple print options, including adjusting print settings and page scaling, so users can print the workbook precisely as needed. The episode also explains how to share workbooks with others, either by email or using cloud-based services like OneDrive.

Overall, "Managing Workbooks" provides Excel users with an in-depth look at the various tools and techniques available for effectively managing workbooks of any size. Viewers will walk away from this episode with a deeper understanding of how Excel functions can be used to streamline their workflow and make managing workbooks an effortless task.