side bar:  IT Training, computer training in Scotland, Edinburgh iTrain Scotland Logo:  Phone us on 07711 341 320. Superior computer training for microsoft word, excel, access, office 97, office 2000, office xp, macromedia dreamweaver, fireworks, web design side bar:  IT Training, computer training in Scotland, Edinburgh
Go Back to courses
   
Excel 2000: Advanced

Overview & Prerequisite

Aimed at sophisticated users who wish to exploit the full capabilities of their spreadsheet software.

Course content

Pivot Tables
Creating
Updating
Adding Fields
Field Options
Manipulating
Consolidation
Charts

Outlining
Creating an Outline
Group/Ungroup
Manipulating
Removing

Scenario Manager
Adding
Updating
Merge
Summary
Printing

Customising Toolbar
Add/Remove Button
Create New Toolbar
Default Toolbars

Introduction to Macros
Recording Macros
Assign to Keyboard
Assign to Toolbar
Save in Personal.xls
Save in Workbook

Functions
Logical
Lookup
Mathematical
Date/Time
Text
Information
Statistical
Database Functions
FinancialNested

General
Formatting Numbers
Goal Seek
Text Joining
Array
Styles
Options
Custom Lists
Auditing
Mixed References

Charts
Adding 2nd Y Axis
Custom Charts
Trend Lines

| home | why choose us | courses | contact us | site map |
2000-2003 iTrain Scotland - Site Last Updated: 9 December, 2003 1:10 PM - Website problems e-mail: Support