|




Find out if you are eligible for FREE training
|
Excel
2000 for Windows
Level: Advanced
Duration: 12 hours - 2 days
To enable the individual to use many of the more
important and complex features of this powerful spreadsheet package.

Other Microsoft Office applications

Introduction
Introducing Functions - statistical, maximum, minimum,
AutoCalculate, date functions
Conditional Functions - the IF function, comparison operators,
embedded or nested IF's, conditional formats
Goal Seek
Data Tables & What If? Analysis - PMT function, one
variable and two variable examples
Scenarios - adding, editing, deleting, summary report
Subtotals - creating, expanding, AutoComplete, \charting
Pivot Tables - analysing, changing, wizards
Data Mapping
Working with Maps
Workbook Security
Data Forms & Filters
An Introduction to Macros
Audit - precedents and dependants
|
|