Microsoft Excel 2003, 2007, XP Databases

Course contents

Customising the Quick Access toolbar
Adding commands not in the ribbons such as forms
Fields and records
Formatting fields
Entering data
The data form
Data Validation
Setting up Data Validation
Validation Options
Sorting and Filtering Lists
Sorting rows and columns
Sorting and formulas
Creating and using custom sort orders
Using AutoFilter and removing filters
Custom AutoFilter
Advanced Filters
Using List Functionality
Designating data as a list and using this
interface to manage and analyse your data
Using Format a Table
Removing duplicates
Automatic Subtotals
Applying and removing subtotals
Counting
Multi-Level subtotals
 
Creating Outlines
Auto Outline
Grouping and ungrouping outlines
Removing outlines
Pivot Tables
Structuring pivot tables
Updating pivot tables
Creating a chart from a pivot table
Using the range of calculations available in Pivot tables including percentages
Formatting pivot tables
Overview of the potential of pivot tables
Advanced Databases
Using Get External Data tab
Importing and exporting data from Access
Creating links to external databases
Creating and using Web queries