Microsoft Excel 2007 - Level 3
Upon completion of the course, participants will be able to accomplish the following:
- 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 and PivotCharts
- Import external data from a variety of sources into Excel
Maintaining Data Lists
Data List 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 Subtotalled Lists; Using Functions to Summarize Data; Working with Tables
PivotTables
PivotTable Concepts; Creating PivotTables; Modifying PivotTable Layouts; Working with PivotTables; PivotCharts
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 have Microsoft Office Excel 2007 level 1 and level 2.
Instructors
