Microsoft Excel 2016 Level 3 - Data List Management
Code:
EXC16DLM
Duration:
1 Day
|
$355
USD
|
In this course, you will learn how to manage data lists using Excels most popular features.
This course is available in the following formats:
Virtual Classroom
Duration: 1 Day
Classroom
Duration: 1 Day
Call 800-798-3901 to enroll in this class! |
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 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
Maintaining Data
- Data List and Excel Table Concepts
- Using Data Forms
- Using Lookup Tables
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 Subtotaled Lists
- Using Functions to Summarize Data
PivotTables
- PivotTable Concepts
- Creating PivotTables
- Modifying PivotTable Layouts
- Working with PivotTables
- PivotCharts
- Slicers
External Data
- External Data Concepts
- Importing Query Data from Access
- Importing Query Data from Web Pages
- Importing Query Data from Text Files
Maintaining Data
- Data List and Excel Table Concepts
- Using Data Forms
- Using Lookup Tables
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 Subtotaled Lists
- Using Functions to Summarize Data
PivotTables
- PivotTable Concepts
- Creating PivotTables
- Modifying PivotTable Layouts
- Working with PivotTables
- PivotCharts
- Slicers
External Data
- External Data Concepts
- Importing Query Data from Access
- Importing Query Data from Web Pages
- Importing Query Data from Text Files
This course is intended for participants who are familiar with Microsoft Office Excel 2016.