Summary: this practical, hands-on course gives participants a practical hands-on introduction to using a spreadsheet as well as more advanced functionality such as formulae and charts
No prior knowledge of MS Excel ® or spreadsheets is required |
| |
| Course Content: |
|
| |
|
| Use Safe Work Practices |
- Workspace, furniture and equipment are adjusted to suit the ergonomic requirements of the user
- Work organisation meets organisational and Occupational Health and Safety requirements for computer operation
- Energy and resource conservation techniques are used to minimise wastage in accordance with organisational and statutory requirements
|
| The Basics of Excel |
- Rows, Columns and Cells
- References and Ranges
- Data Entry
- Entering Data
- Formatting: Numbers, Alignment, Font, Border, Patterns
- Introducing Formulae
- Producing a Basic Total
|
| Using Excel |
- Selecting Cells
- Selection
- Replication: single and multiple cells
- Replication: single and multiple cells
- Replicating
- Moving Cells
- The Undo Command
- Inserting Rows and Columns
- Working With Worksheets
|
| Intermediate Excel Features |
- Format Painter
- Conditional Formatting
- Format A Number
|
| Using Formulae |
- What is a formula?
- Simple Functions: Sum, Min, Max, Average and Count
- Insert Functions
- Conditional Statements
- Advanced Functions: VLookup, CountIf, PMT
|
| Graphs and Charts |
- Introduction
- Pie Charts
- Line Charts
- Line-Column Charts
- Modifying Charts
|
