MS Excel 2007™ - Level 3 - Databases
Techniques to Manage Information

Program Topics

Working with Data Lists
• Creating a Database
• Using Forms to manipulate Data
• Using Lookup Functions
• Sorting Lists

Filtering Lists
• Filtering Concepts
• Using AutoFilter
• Using Advance Filter
• Working with Filtered Lists

Summarizing Data
• Creating Automatic Subtotals
• Working with Subtotalled Lists
• Using Functions to Summarize Data

Creating and Using Pivot Tables
• Understanding Pivot Table Fields
• Modifying Pivot Table Layouts
• Updating and Formatting Pivot Tables
• Creating Pivot Charts

Importing Data
• Importing a Text File 
• Importing an Access Table
• Importing Data from the Web

Creating Macros
• Create a Basic Macro
• Edit a Macro
• Saving a MS-Excel 07 Workbook with Macros