1 - day course
Print this page
Course Code: S1M33Den
Who should attend?
This course is intended for users who are familiar with Microsoft Excel desktop.
Excel for Microsoft 365/2021 - Level 2
Course Objectives
Upon completion of the course, participants will be able to accomplish the following:
  • Create and use Excel tables, as well as add, edit, search for, and delete records in tables, and look up data.
  • Sort records in a table using a variety of methods.
  • Filter data in a table using a variety of methods, as well as work with filtered data.
  • Create and work with subtotalled lists, as well as use various database functions to summarize data.
  • Create, modify, and work with PivotTables, PivotCharts, and Slicers.
  • Create dynamic array formulas using the SORT, SORTBY, UNIQUE, and FILTER dynamic array functions.
Course Content  
    Maintaining Data
    Data List and Excel Table Concepts ; Working with Tables ; Using Lookup Tables ; Using Data Forms ;
    Sorting Lists
    Sorting Concepts ; Sorting Lists ; Custom Sort Orders ;
    Filtering Lists
    Filtering Concepts ; Using AutoFilter ; Using Advanced Filter ; Working with Filtered Data ;
    Summarizing Data
    Automatic Subtotals ; Working with Subtotalled Lists ; Using Functions to Summarize Data ;
    Working with PivotTables
    PivotTable Concepts ; Creating PivotTables ; Modifying PivotTable Layouts ; Working with PivotTables ; PivotCharts ; Slicers ;
    Dynamic Array Formulas
    Dynamic Array Formula Concepts ; Creating Unique Dynamic Lists ; Sorting Dynamic Arrays ; Filtering Dynamic Arrays ;