Microsoft Excel 2003/07 - Intermediate
Functions and Formulae
- Basic functions
- AutoSum, AutoAverage, AutoCount, AutoMax, AutoMin
- Relative and absolute formulae
- Naming ranges
- Insert function wizard
- Logical and lookup functions
Workbook Management
- Group editing
- Grouping and ungrouping sheets
- Naming sheets
- Colour sheet tabs
- Splitting and freezing panes
- Customising spreadsheets
Introduction to Charts
- Composition of Charts
- Chart Wizard
- Chart Types
- Editing Charts
- Methods of Displays
Database Features
- Filtering data
- Chart Wizard
- Sorting data
- Automatic subtotals
- Pivot tables
- Pivot charts
|