Duration: 1 day | Classroom price: $297

Pre-requisites:

• Basic computer experience, including keyboard and mouse skills
• Familiarity with the Microsoft Windows
• If you are not familiar with using a computer or Microsoft Windows, a 1 day course, Introduction to computers, will give you the skills to take this course.

1. Spreadsheets explained
2. Planning your spreadsheet
3. Finding your way around Excel
4. Working with workbooks and worksheets
5. Working with data in Excel
6. Formulas and functions
7. Formatting in Excel
8. Printing and page set up
9. Charts and graphs

Detailed course content

Duration: 1 day | Classroom price: $297 (incl. GST)

Pre-requisites:

• Basic experience in using Microsoft Excel spreadsheets
• Knowledge of simple calculations
• Alternatively, completion of Excel Beginners training course

1. Working with workbooks
2. Working with worksheets
3. Adjusting a worksheet
4. Viewing worksheets
5. Formatting cells
6. Absolute referencing
7. Filling Series
8. Labels and names
9. Logical functions
10. Lookup functions
11. Sorting
12. AutoFilter

Detailed course contents

Duration: 1 day | Classroom price: $297

Pre-requisites:

• Sound experience in using worksheets
• Knowledge of more complex functions
• Ability to sort and filter data
• Alternatively, completion of Excel Intermediate training course

1. Nesting Functions
2. Advanced filters
3. Validations
4. Goal Seeking
5. Data Tables
6. Scenarios
7. Pivot Tables
8. Linking Workbooks
9. Consolidation
10. Summarising Data
11. Recorded Macros

Detailed course contents