Course Objectives
- Learn basic formulas and functions to improve office productivity
- Perform calculations, work with different types of charts and summarise data
Course Structure
- Shortcut keys
- Multiple worksheets
- Data entry
- The use of relative, absolute and mixed references in formulae
- Functions: SUM, AVERAGE, MIN, MAX, COUNT(A), ROUND, IF, AND, OR, NOT
- Formatting, custom number formats, conditional formatting & format painter
- Comments
- Freeze panes
- Manipulating dates
- Names
- Data validation
- Charting
- Data tables
- Protecting cells and worksheets
- Templates
- Form controls
- Basic macros
- Printing
- Solutions