Complete Guide to Excel 365: Linking Printing & Protecting Workbooks

Some of the core benefits of working with data in Excel include connecting data combined from different workbooks and controlling how its presented and who has access to it. In this course, youll begin by linking data in different Excel workbooks, before editing, testing, and cleanly breaking those links.Next, youll work with an often-ignored but powerful aspect of Excel – precise control over how a workbook is laid out and printed. Youll configure headers, footers, page numbers, background, images, and the views used to print only parts of a workbook.Finally, youll use Excels protection features for individual cells and cell ranges, worksheets, and workbooks. This includes setting roles and passwords, working with read-only workbooks, and utilizing editable cell ranges.