 |
||
|
|
Excel 2000 for Windows Level: Advanced
 • 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 |
|
|
|
||
|
|
||
