|
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
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
|
