The MS Excel - Data Management training course provides the knowledge and skills to become familiar with advanced data-management features and functionality of Microsoft Excel 2013.
By attending MS Excel - Data Management workshop, delegates will learn to:
- 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
- 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 subtotaled 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
- This MS Excel - Data Management class is suitable for Anyone who needs to use Microsoft Office Excel 2013 proficiently