Excel 2016 Advanced - Full Day Class Personalize our class outlines. We'll create a class just for you.

Printable Version  |  See Other Class Topics  |  See All Class Outlines


Overview

Upon successful completion of this course, students will be able to:

  • Work with multiple worksheets and workbooks 
  • Use Lookup functions and formula auditing
  • Share and protect workbooks
  • Automate workbook functionality
  • Create sparklines and map data
  • Forecast data

Lesson 1: Working with Multiple Worksheets and Workbooks 

  1. Use Links and External References
  2. Use 3-D References
  3. Consolidate Data

Lesson 2:  Using Lookup Functions and Formula Auditing

  1. Use Lookuo Functions
  2. Trace Cells
  3. Watch and Evaluate Formulas

Lesson 3: Sharing and Protecting Workbooks

  1. Collaborate on a Workbook
  2. Protect Worksheets and Workbooks

Lesson 4:  Automating Workbook Functionality

  1. Apply Data Validation
  2. Search for Invalid Data and Formulas with Errors
  3. Work with Macros

Lesson 5: Creating Sparklines and Mapping Data

  1. Create Sparklines
  2. Map Data

Lesson 6: Forecasting Data

  1. Determine Potential Outcomes Using Data Tables
  2. Determine Potential Outcomes Using Scenarios
  3. Use the Goal Seek Feature
  4. Forecasting Data Trends

Appendix A:  Microsoft Office Excel 2016 Exam 77-727
Appendix B:  Microsoft Office Excel 2016 Expert Exam 77-728
Appendix C:  Microsoft Office Excel 2016 Common Keyboard Shortcuts
Appendix D:  Cube Functions
Appendix E:  Importing and Exporting Data
Appendix F:  Internationalizing Workbooks
Appendix G:  Working with PowerPivot
Appendix H:  Advanced Customization Options
Appendix I:  Working with Forms and Controis 

If you would like to customize this class please call us at (888) 572-1200

 

 

 

Have a Question?

Give us a call at (888) 572-1200 or contact us for fast attention.

Get in touch!