Excel for Intermediate Users

About the course

Are you using excel to its full potential? You will be amazed at the potential of Excel. Learn to manage your finances, business data, use as a calculator, display, interpret information, use relative and absolute references and more. Certificate a Attendance awarded after successful completion of the course.

Prerequisite

Before you enrol, you must be able to open and shut down a computer, have experience working on Windows 10 operating system, create files and folders, open Microsoft Excel application, copy, rename, delete files, save, open and print a file.

Resources required

As this course will be delivered in Windows 10, it is expected that you have this operation system already loaded on your computer. Your computer or laptop must be operational. If it has any known fault that may disrupt your learning, it is recommended that you do not enrol into this course.

You are also expected to have Office 2016, a good internet connection, a web camera (essential as the trainer will need to see your screen) and a printer (optional). Once you have enrolled, you will receive instructions on how to join the virtual classroom.

Learning outcomes

Upon successful completion of the course, you should be able to -

Select and prepare resources
1.1. Adhere to ergonomic, work organisation and occupational health and safety requirements
1.2. Use energy and resource conservation techniques to minimise wastage
1.3. Identify spreadsheet task requirements in relation to data entry, storage, output and presentation

Plan spreadsheet design
2.1. Ensure spreadsheet design suits the purpose, audience and information requirements of the task
2.2. Ensure spreadsheet design enhances readability and appearance, and meets organisational and task requirements for style and layout
2.3. Use style sheets and automatic functions to ensure consistency of design and layout

Create spreadsheet
3.1. Ensure data is entered, checked and amended to maintain consistency of design and layout, in accordance with organisational and task requirements
3.2. Format spreadsheet using software functions to adjust page and cell layout to meet information requirements, in accordance with organisational style and presentation requirements
3.3. Ensure formulae are tested and used to confirm output meets task requirements, in consultation with appropriate personnel as required
3.4. Use manuals, user documentation and online help to overcome problems with spreadsheet design and production

Produce simple charts
4.1. Select chart type and design that enables valid representation of numerical data, and meets organisational and task requirements
4.2. Create charts using appropriate data range in the spreadsheet
4.3. Modify chart type and layout using formatting features

Finalise spreadsheets
5.1. Preview, adjust and print spreadsheet and any accompanying charts, in accordance with task requirements
5.2. Ensure data input meets designated time lines and organisational requirements for speed and accuracy
5.3. Name and store spreadsheet in accordance with organisational requirements and exit the application without data loss/damage

Learning strategies

This course will be delivered in in a virtual classroom environment via video conferencing led by a qualified and industry experienced trainer. Learning methods will include face to face lecture via video conferencing, case studies, demonstrations, questions and answers.

Assessment strategies

There is no assessment for this course; however, the trainer may ask the participants to complete some activities to ensure they are gaining the intended skills.

Need further information?

Should you require further information, please contact our enrolment officer on 02 96872072 or send an email to admin@parramattacollege.com.au.

This course has no current classes. Please the waiting list.