Intermediate

  -  Use Trace to fix formula errors


Tables

  -  Create and format tables

  -  Sort data in a table

  -  Filter data in a table

  -  Add a Total row to a table

  -  Filter data with slicers


Charts

  -  Add trendlines and drop lines


PivotTables

  -  Create PivotTables

  -  Work with PivotTables

  -  Group data in PivotTables

  -  Filter data with Slicers in PivotTables

                                                                                                                                                                                                                                                                                                                                                                                                                                                           
The above Excel 2016 training materials are provided by LinkedIn Learning.