Course
Length: One Day
Fees: Training at Client Offices: One delegate: £395 per-day + VAT
Additional delegates attending: £75 each per-day + VATOverview:
Microsoft
Excel 2000 is a software application that can be used as a spreadsheet,
database, or graphing program.
This course introduces the skills necessary to organise Excel
information including working with databases; advanced filtering;
importing and exporting data from different sources; creating and using
pivot tables; templates; using comments; using worksheet/workbook
protection plus assigning a password; sharing workbooks with other users.
Working with Databases
 |
Using,
Creating & Modifying a Database
|
|
Sorting
Records by Multiple Fields
|
|
Using/Removing
Data Validation
|
|
Validating
Data using a List
|
|
Creating
a Custom Error Message
|
|
Creating/Removing
Subtotals in a List
|
Working with the Data
Form
|
Viewing,
Adding & Editing Form Records
|
|
Defining/Clearing
Data Form Criteria
|
|
Deleting
Data Form Records
|
Working with Advanced
Filters
|
Creating
& Using a Criteria Range
|
|
Showing
All Records
|
|
Using
Comparison Criteria
|
|
Using
an Advanced And/Or Condition
|
|
Extracting
Filtered Records
|
|
Using
Database Functions
|
Importing
& Exporting Data
|
Importing
Data from Text Files
|
|
Changing
External Data Range Properties
|
|
Importing
Data from Other Applications
|
|
Removing
the Query Definition
|
|
Exporting
Data to Other Applications
|
Creating/Revising/Formatting
Pivot Tables
|
Creating
a PivotTable Report
|
|
Adding
PivotTable Report Fields
|
|
Selecting
a Page Field Item
|
|
Refreshing
a PivotTable Report
|
|
Adding
New Fields to a PivotTable Report
|
|
Moving
PivotTable Report Fields
|
|
Hiding
and Unhiding Items
|
|
Creating
a Page Field Report
|
| Formatting
a PivotTable Report
|
|
Creating
a PivotChart Report
|
|
Creating
Interactive PivotTables - Web
|
|
Adding
Fields to a PivotTable – Browser
|
Using Data Tables
|
Placing Formulas in Data Tables
|
|
Creating a One-Variable Table
|
|
Creating a Two-Variable Table
|
Using Templates
|
Working
with Templates
|
|
Saving
a Workbook as a Template
|
|
Using/Editing
& Deleting a Template
|
|
Inserting
a New Worksheet
|
|
Creating
Default Templates
|
Working
with Comments
|
Creating
& Viewing Comments
|
|
Viewing
a Comment
|
|
Using
the Reviewing Toolbar
|
|
Printing
Comments
|
Using Worksheet
Protection
|
Unlocking
Cells in a Worksheet
|
|
Protecting/Unprotecting
a Worksheet
|
|
Protecting/Unprotecting
Workbook Windows
|
|
Assigning/Removing
a Password
|
|
Setting
Manual/Automatic Calculation
|
Sharing Workbooks
|
Saving
a Shared Workbook
|
|
Viewing
Users/Shared Workbook Changes
|
|
Displaying
Comment Boxes
|
|
Changing
the Update Frequency
|
|
Highlighting
Changes
|
|
Managing/Resolving
Conflicting Changes
|
|
Setting
Change History Options
|
|
Creating
the History Worksheet
|
|
Reviewing
Tracked Changes
|
|
Merging
Shared Workbook Files |
Using the Report Manager
|
Working with the Report Manager |
|
Using Sheets in a Report |
|
Printing a Report |
|
Using Scenarios and Views in a Report |
|
Reordering Sections in a Report |
If you have other questions, please contact us at
enquiry@it-uk.com or
complete
our response form |
