Complete Guide to Excel 365: Linking, Printing, & Protecting Workbooks

Excel Office 365    |    Intermediate
  • 11 videos | 1h 20m 13s
  • Includes Assessment
  • Earns a Badge
Likes 32 Likes 32
Some of the core benefits of working with data in Excel include connecting data combined from different workbooks and controlling how it's presented and who has access to it. In this course, you'll begin by linking data in different Excel workbooks, before editing, testing, and cleanly breaking those links. Next, you'll work with an often-ignored but powerful aspect of Excel - precise control over how a workbook is laid out and printed. You'll configure headers, footers, page numbers, background, images, and the views used to print only parts of a workbook. Finally, you'll use Excel's 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.


  • discover the key concepts covered in this course
    use the Excel Options menu to customize how workbooks are saved, configure AutoSave and AutoRecover behavior and the default save location, and use the Manage Workbook functionality to recover or delete unsaved workbooks
    use built-in templates, save a commonly-used workbook as an Excel Template (.xltx) file, and recognize the purpose of the Custom Office Templates folder, the names "Book" and "Sheet" for .xltx files, and the XLSTART sub-folder
    use the Data Outline menu item to logically group data based on rows and columns, the Ungroup option to undo grouped data, and list the capabilities and limitations of the Auto Outline feature
    create links to external workbooks, use the Paste Link option from the Paste menu, parse the syntax of external link addresses, and recognize the dynamic nature of data linked from external workbooks
    edit external links using the Data menu, use the Open Source, Check Status, Change Source, and Break Link options, and customize the startup prompt when a workbook with external links is opened
  • combine the Print and Page Layout menu features to control how workbooks are printed and use Page Break Preview to control pagination, specify collation, scaling, paper type, and orientation
    customize headers and footers, display and hide hidden columns, insert images into workbooks, control whether images are printed and whether they appear within the data or in the header/footer, and set and customize a workbook's background image and transparency
    use the Protect Sheet feature from the Review menu to control how a sheet can be edited, customize which operations are possible without a password, and use the Allow Edit Ranges feature to override protection for specific areas on a worksheet
    control cell-level protection and understand the semantics of the locked and hidden checkboxes, apply workbook-level protection options, such as open in read-only mode, use password encryption, add a digital signature, mark as final, and outline the semantics and limitations of opening in read-only mode
    summarize the key concepts covered in this course


  • 2m 1s
  • 6m 35s
  • Locked
    3.  Using Templates and the XLSTART Folder
    7m 19s
  • Locked
    4.  Grouping Data Using Outline and Auto Outline
    9m 10s
  • Locked
    5.  Creating External Links
    9m 42s
  • Locked
    6.  Editing External Links
    10m 5s
  • Locked
    7.  Controlling How Workbooks Are Printed
    10m 1s
  • Locked
    8.  Customizing Headers, Footers, and Background Images
    7m 50s
  • Locked
    9.  Protecting Worksheets
    7m 36s
  • Locked
    10.  Protecting Workbooks
    8m 31s
  • Locked
    11.  Course Summary
    1m 24s


Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.