Excel 2016 Intermediate - 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


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

  • Work with functions
  • Work with lists
  • Analyze data
  • Visualize data with charts
  • Use PivotTables and PivotCharts

Course Content

Lesson 1: Working with Functions

  1. Work with Ranges
  2. Use Specialized Functions
  3. Work with Logical Functions
  4. Workwith Date and Time Functions
  5. Work with Text Functions

Lesson 2: Working with Lists

  1. Sort Data
  2. Filter Data
  3. Query Data with Database Functions
  4. Outline and Subtotal Data

Lesson 3: Analyzing Data 

  1. Create and Modify Tables
  2. Apply Intermediate Conditional Formatting
  3. Apply Advanced Conditional Formatting

Lesson 4: Visualizing Data with Charts

  1. Create Charts
  2. Modify and Format Charts
  3. Use Advanced Chart Features

Lesson 5: Using PivotTables and PivotCharts

  1. Create a PivotTable
  2. Analyze PivotTable Data
  3. Present Data with PivotCharts
  4. Filter Data by Using Timelines and Slicers

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:  Financial Functions
Appendix E:  Working with Graphical Objects
Appendix F:  Using Array Formulas 

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!