Microsoft Excel 2016 (365) Level II


This course builds on the skills and concepts taught in Excel 2016 (365) Level I. Students will learn how to use more advanced functions. They will also learn several sorting and filtration procedures. Basic and advanced conditional formatting will be covered as well as simplifying data presentations with grouping and outlining. Students will create charts from both spreadsheet data and from pivot tables. This course also covers advanced charting techniques, use of trendlines and sparklines, as well as worksheet auditing and protection.


Excel 2016 (365) Level I or equivalent.


Working with Functions

  • Work with Ranges
  • Use Specialized Functions
  • Work with Logical Functions
  • Work with Date & Time Functions
  • Work with Text Functions

Working with Lists

  • Sort Data
  • Filter Data
  • Query Data with Database Functions
  • Outline and Subtotal Data

Analyzing Data

  • Create and Modify Tables
  • Apply Intermediate Conditional Formatting
  • Apply Advanced Conditional Formatting

Visualizing Data with Charts

  • Create Charts
  • Modify and Format Charts
  • Use Advanced Chart Features

Using PivotTables and PivotCharts

  • Create a PivotTable
  • Analyze PivotTable Data
  • Present Data with PivotCharts
  • Filter Data by Using Timelines and Slicers