Excel 2016 Expert

Workshop Objectives

Research has consistently demonstrated that when clear goals are associated with learning, it occurs more easily and rapidly. With that in mind, let’s review our goals for today.

At the end of this workshop, participants should be able to:

• Create worksheets and workbooks
• Navigate in worksheets and workbooks
• Format worksheets and workbooks
• Change views and configurations
• Print and distribute worksheets and workbooks
• Manage data cells and ranges
• Create tables, charts and objects
• Perform operations with formulas and functions

Table of Contents

Module One: Getting Started        

Module Two: Manage Workbook Options and Settings    

Module Three: Apply Custom Data Formats and Layouts

Module Four: Create Advanced Formulas     

Module Five: Create Advanced Charts and Tables   

Module Six: Wrapping Up