After completing this workshop, you will be able to:

Manage workbooks

  • Save a workbook as a template
  • Copy macros between workbooks
  • Reference data in another workbook
  • Reference data by using structures references
  • Enable macros in a workbook
  • Display hidden ribbon tabs

Manage workbook flow

  • Restrict editing
  • Protect a worksheet
  • Configure formula calculation options
  • Protect workbook structure
  • Manage workbook versions
  • Encrypt a workbook with a password