In this Short Take to Microsoft Excel 2016 training class, learn to collaborate with colleagues by protecting and sharing workbooks, combine data and troubleshoot errors in formulas.

Prerequisites: To get the most from the training, we highly recommend you take the Short Take sessions in order (i.e. Short Take 1, Short Take 2, etc.) or have previous experience as outlined in the class objectives.

Course Length:  3 hours

Course Objectives

Upon successful completion of this course, you will learn to:

• Work with multiple worksheets and workbooks.
• Use Lookup functions and formula auditing
• Share and protect workbooks.

Working with Multiple Worksheets and Workbooks

• Use Links and External References
• Use 3-D References
• Consolidate Data

Using Lookup Functions and Formula Auditing

• Use Lookup Functions
• Trace Cells
• Watch and Evaluate Formulas

Sharing and Protecting Workbooks

• Collaborate on a Workbook
• Protect Worksheets and Workbooks