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 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.