MS Excel DLM

Course Outlines

Level 3 – Data & List Management

Through your participation in this class, you gain confidence in your ability to perform the following tasks.

Module 1	Create and use Excel tables, as well as add, edit, search for, and delete records in a data list using a form, as well as look up data.
Module 2	Sort records in a data list using a variety of methods.
Module 3	Filter data in a list using a variety of methods, as well as work with filtered data.
Module 4	Create and work with subtotalled lists, as well as use various database functions to summarize data.
Module 5	Create, modify, and work with PivotTables, PivotCharts, and Slicers.
Module 6	Import external data from a variety of sources into Excel.