Latest Courses
About this course
This is a beginner’s course and aims to give the new spreadsheet user a thorough grounding in the basics of creating and working with spreadsheets using Microsoft Excel Office 365 .
Particular emphasis is placed on developing accurate and well-designed spreadsheets employing sound design and documentation principles.
Students have the option to also enrol in the Unit of Competency and complete an assessment as homework leading to a Statement of Attainment.
Why Study Online?
- ZERO travel and flexible course delivery; complete this course online from home or at work.
- Study according to your schedule with 24/7 access to online course content.
- Fully equipped virtual classrooms. Attend real-time virtual classes with a certified trainer.
- Participate in interactive learning experiences.
- Feel supported through your studies with our dedicated Student Support Days to provide one on one guidance.
Rather study face-to-face?
Check out our Microsoft Excel Office 365 – Introductory Course for face-to-face delivery.
Prerequisites
This course assumes little or no knowledge of spreadsheets or Microsoft Excel Office 365. However, it would be beneficial to have a general understanding of personal computers and the operating system environment, especially in regard to working with files and folders.
Learning Outcomes
At the completion of this course you should be able to:
- navigate your way around Microsoft Excel
- create and work with a new workbook
- open and navigate within workbooks and worksheets
- make changes to data in a workbook
- understand and work with ranges in a worksheet
- copy and paste data in Excel
- use the fill operations available to fill a data series
- move the contents of cells and ranges within and between workbooks
- understand, create and work with formulas and functions
- understand and use formula cell referencing
- use font formatting techniques
- align the contents of cells in a number of ways
- understand and use the number formatting features in Excel
- format rows and columns in a worksheet
- work with elements that make up the structure of a worksheet
- sort data in a list in a worksheet
- filter data in a table
- print your workbook data
- create effective charts in Microsoft Excel
- obtain help for Excel whenever you need it
- understand points to consider to avoid problems in your worksheets
Pre-Course Assessment Questions
Not sure what level of course you should complete?
Level 1
If you answer “no” to two of these questions, you should consider doing Excel Level One:
1. Can you create simple formulas in Excel?
2. Can you use the SUM, AVERAGE, MAX, MIN and COUNT functions?
3. Can you create a simple chart?
Level 2
If you answer “no” to two of these questions, you should consider doing Excel Level Two:
1. Can you use the IF and VLOOKUP functions?
2. Can you use Conditional Formatting?
3. Can you sort data and apply complex filters?
Level 3
If you answer “no” to two of these questions, you should consider doing Excel Level Three:
1. Can you create a Pivot Table?
2. Can you record and edit macros?
3. Can you link data across workbooks?
