Microsoft Excel 365 Level 3 Data List Management

This course is intended for participants who are familiar with Excel 365.
Microsoft Excel 365 Level 2
Upon completion of the course, participants will be able to accomplish the following:

• Create tables, add, edit, search for, and delete records in a data list using a form, as well as look up data.
• Sort records in a data list using a variety of methods.
• Filter data in a list 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.
• Import external data from a variety of sources into Excel.