|
Learning outcomes
Delegates will be equipped to use the database functionality of Microsoft
Excel for analysis and graphical presentation of data.
Who should attend?
Delegates should first attend the Microsoft Excel Introduction or have
gained a similar level of expertise.
Training style
Informal and participative using a combination of trainer input, discussion
and practical exercises. This approach ensures the training meets the
needs of both the group and individual participants.
|
| |
Course contents
Creating a Database
Fields and records
Formatting fields
Entering data
The Data Form
Managing Data in Lists Using
Data Forms
Moving through data records
Adding, editing and deleting records
Finding records
Data Validation
Setting up data validation
Validation options
Sorting and Filtering Lists
Sorting rows and columns
Sorting and formulae
Creating and using custom sort orders AutoFilter
Removing a filter
Custom AutoFilter
Advanced Filters
|
Using List Functionality
Designating data as a list and using this interface to manage and analyse
your data
Automatic Subtotals
Applying and removing subtotals
Counting
Multi-level subtotals
Creating Outlines
AutoOutline
Collapsing and expanding outlines Removing outlines
Pivot Tables
Structuring Pivot tables
Updating Pivot Tables
Creating a chart from a Pivot Table
Advanced Databases
Using Microsoft Query
Importing and exporting data
Creating links to external databases Creating and using web queries
|
|
