The list below shows the basic topics covered by the Training program. You can see more details and examples on these topics when you click on them.
Part A - Techniques and procedures to reduce the risk of errors.
1. Data Validation
2. Conditional Formatting
3. Techniques / Tips for Data Entry
4. Using Names
5. Techniques for Creating Formulas
6. Protecting Data
7. Auditing of Spreadsheets
8. Macros
Part B - Techniques for Data Analysis
1. Pivot Table Reports
2. Subtotals and Consolidate
3. Filtering Data
4. Useful Functions
5. Graphs
|