EXCEL 2013 – 2016 – 2019 DATA LIST MANAGEMENT

Prerequisites

To ensure your success, we recommend you first take the following course (or have equivalent knowledge): Excel Intermediate Level.

Course overview

After taking this course you will be able to organize your data in tables, use various methods to sort and filter your data, analyze your data with PivotTables as well as use database functions.

Instruction will be personalized by version. Students have the option to progress through the course using Microsoft Excel 2010 Level 3-Data List Management or Microsoft Excel 2013 Level 3- Data List Management.

Excel Data List Management Topics

1. Maintaining Data
2. Data List and Excel Table Concepts
3. Using Data Forms
4. Using Lookup Tables
5. Sorting Lists
6. Sorting Concepts
7. Sorting Lists
8. Custom Sort Orders
9. Filtering Lists
10. Filtering Concepts
11. Using AutoFilter
12. Using Advanced Filter
13. Working with Filtered Data
14. Summarizing Data
15. Automatic Subtotals
16. Working with Subtotaled Lists
17. Using Functions to Summarize Data PivotTables
18. Pivot Table Concepts
19. Creating Pivot Tables
20. Modifying Pivot Table Layouts
21. Working with Pivot Tables
22. Pivot Charts
23. Slicers
24. External Data
25. External Data Concepts
26. Importing Query Data from Access
27. Importing Query Data from Web Pages
28. Importing Query Data from Text Files