Microsoft® Office Excel® 2016 - Advanced Course Schedule

man staring at computer

Lesson 1: Working with Multiple Worksheets and Workbooks

 Topic A: Use Links and External References

 Topic B: Use 3-D References

 Topic C: Consolidate Data


Lesson 2: Using Lookup Functions and Formula Auditing

 Topic A: Use Lookup Functions

 Topic B: Trace Cells

 Topic C: Watch and Evaluate Formulas


Lesson 3: Sharing and Protecting Workbooks

 Topic A: Collaborate on a Workbook

 Topic B: Protect Worksheets and Workbooks


Lesson 4: Automating Workbook Functionality

 Topic A: Apply Data Validation

 Topic B: Search for Invalid Data and Formulas with Errors

 Topic C: Work with Macros


Lesson 5: Creating Sparklines and Mapping Data

 Topic A: Create Sparklines

 Topic B: Map Data


Lesson 6: Forecasting Data

 Topic A: Determine Potential Outcomes Using Data Tables

 Topic B: Determine Potential Outcomes Using Scenarios

 Topic C: Use the Goal Seek Feature

 Topic D: Forecasting Data Trends

Meet Your Instructor

Stephanie Chastain is currently a Training and Development Specialist at a tourist attraction in the Chattanooga area. She has been a Corporate Trainer in some capacity for over 20 years, and has also served in the roles of IT Trainer, Testing and Project Coordinator, Project Manager and Help Desk Coordinator for several organizations. Every day, her focus is on striving for positive interactions with every member of the team and those she interacts with on a professional basis. She brings her love for learning and teaching to every person she works with, and encouraging those around her to succeed is very important to her. Stephanie is well-versed in the methodology behind requirements gathering, test case development, and training, therefore earning a reputation as a strong team member in support of any project. She holds an MSEd in Training and Performance Improvement, and she is a member of the Association for Talent Development.

Refund Policy

See Refund Policy →