Microsoft Excel Advanced

Non-Award

This workshop will provide participants with an understanding of Microsoft Excel at an advanced level to improve their Microsoft Excel skills. It is anticipated that the participants will be existing workers with range of experiences in diverse workplace contexts to better manage their current role responsibilities or to expand on their Microsoft Excel skill set to access employment or promotion. The program is delivered over a one (1) day workshop via an online platform, facilitator led delivery will provide an overview of platform being utilised and expectations of participation whilst ensuring any participant technology issues are addressed. At completion of the course participants will be able to: Demonstrate and discuss workstation ergonomics while working with Excel Use Microsoft Excel Advanced features Plan and create Advanced / Complex spreadsheets Enter, check and amend data in Excel (Review the use of Excel Ribbon & tasks within each section) Use and apply complex formulas in Excel (Test and check their function) Discuss IF Formula, V-Look up & H-Look up and Nested IF statements Discuss use of MACRO in Excel Move / & Link Excel spreadsheets Use Pivot Tables & Charts.

Key details

Degree Type

Non-Award

Duration

1 year full-time

Course Code

THABW

Study Mode

Online, In person

Domestic Fees

$700 per year

About this course

This workshop will provide participants with an understanding of Microsoft Excel at an advanced level to improve their Microsoft Excel skills. It is anticipated that the participants will be existing workers with range of experiences in diverse workplace contexts to better manage their current role responsibilities or to expand on their Microsoft Excel skill set to access employment or promotion.

The program is delivered over a one (1) day workshop via an online platform, facilitator led delivery will provide an overview of platform being utilised and expectations of participation whilst ensuring any participant technology issues are addressed.

At completion of the course participants will be able to:

Demonstrate and discuss workstation ergonomics while working with Excel
Use Microsoft Excel Advanced features
Plan and create Advanced / Complex spreadsheets
Enter, check and amend data in Excel (Review the use of Excel Ribbon & tasks within each section)
Use and apply complex formulas in Excel (Test and check their function)
Discuss IF Formula, V-Look up & H-Look up and Nested IF statements
Discuss use of MACRO in Excel
Move / & Link Excel spreadsheets
Use Pivot Tables & Charts.

Entry requirements

Meeting the minimum admission requirements does not guarantee you entry into this course. Some courses receive more applications than the number of places available. In this situation we will also assess your education, work and other relevant experience.

Find out more about how to apply for our courses, and our commitment to admissions transparency.

Participants will need access to a computer with an operational version of Microsoft Excel installed on their computer. The program assumes participants will have intermediate Microsoft Excel skills and knowledge.

Study locations

Footscray Nicholson

Industry

Online

What you will learn

This professional-development workshop is suitable for individuals from any industry, job role, community or sporting organisation.

It provides participants with an understanding of Microsoft Excel at an advanced level to improve their Microsoft Excel skills.

At the completion of the workshop, you will be able to:

Demonstrate and discuss workstation ergonomics while working with Excel
Use Microsoft Excel Advanced features
Plan and create Advanced / Complex spreadsheets
Enter, check and amend data in Excel (Review the use of Excel Ribbon & tasks within each section)
Use and apply complex formulas in Excel (Test and check their function)
Discuss IF Formula, V-Look up & H-Look up and Nested IF statements
Discuss use of MACRO in Excel
Move / & Link Excel spreadsheets
Use Pivot Tables & Charts.

Graduate outcomes

Graduate satisfaction and employment outcomes for Teacher Education courses at Victoria University (VU).

72.1%

Overall satisfaction

70.5%

Skill scale

60.2%

Teaching scale

79.8%

Employed full-time

$67k

Average salary

Data source