1. Spreadsheet Structure &
Design
1.1 Applications
1.2 Data identification and description
1.3 Spreadsheet structure
1.4 Data validation and spreadsheet testing
1.5 Future requirements and improvements
2. Spreadsheet Facilities
2.1 Ranges
2.2 Calculations
2.3 Functions
2.4 Operators
2.5 Sorting and searching
2.6 Lookup tables and data tables
3. Spreadsheet Applications
3.1 General
3.2 Financial
3.3 Non-Financial
4. Graphs
4.1 Types of graphs
4.2 Labels and patterns
5. Macros
5.1 Creating Macros
5.2 Documenting, saving & executing macros
5.3 Documentation & printing
|