Courses available in Microsoft Excel

This course in Microsoft Excel aims to provide users with a solid foundation of the essential skills needed to create, modify, format, save and print simple spreadsheets with basic formulas and functions.

Intended Audience

Although this is a beginners level course it is suitable for a wide range of participants including beginners, those transitioning from earlier versions of Excel, self-taught users who are looking to fill in knowledge gaps and those looking to either return to the workforce or those exploring new employment opportunities.

Prerequisites

It is expected that participants will be familiar with using the basic functions of a computer such as navigating the Windows environment, operating a mouse and keyboard, navigating folders and copying and pasting objects. If you don't already have these skills taking a course in Computer Basics first would be recommended.

Delivery Style

Training is delivered as instructor-led computer-based training in a computer lab to individuals or small groups. Participants will have dedicated access to a modern computer with a large monitor and access to various assistive technologies such as sit stand desks, microdesks and a range of input devices to ensure comfort. Course materials are based on real world examples in a New Zealand context

Learning Outcomes

On completion of this training participants should be able to:

• Work with the basic features of Excel
• Create, save, print and retrieve workbooks
• Navigate around Excel
• Select text within a worksheet using a mouse and keyboard
• Enter and modify spreadsheet data
• Work with cells and cell data by using a range of moving and copying techniques
• Use formulas and functions to perform data calculations
• Enhance the appearance of worksheets by using a range of formatting techniques
• Format rows and columns within a worksheet
• Create and modify basic charts
• Display worksheets using various views
• Find information using the Help feature of Excel

Go beyond the basics of Word in this intermediate level course where the knowledge and skills acquired will provide you with the essential skills needed to produce more effective and productive workbooks.

Intended Audience

Suitable for people already using Microsoft Excel who want to learn some of the more advanced functionality of this application. This course will build on the skils learnt in Level 1 to extend knowledge in functions, formulas, formatting and charts.

Prerequisites

It is expected that participants will be familiar with using the basic functions of a computer such as navigating the Windows environment, navigating folders and copying and pasting objects. Additionally you should be confident operating a mouse and keyboard and have either completed Microsoft Excel Level 1 or have equivalent knowledge. If you don't already have these skills taking a course in Computer Basics and Excel Level 1 first would be recommended.

Delivery Style

Training is delivered as instructor-led computer-based training in a computer lab to individuals or small groups. Participants will have dedicated access to a modern computer with a large monitor and access to various assistive technologies such as sit stand desks, microdesks and a range of input devices to ensure comfort. Course materials are based on real world examples in a New Zealand context

Learning Outcomes

On completion of this training participants should be able to:

• Use a range of techniques to manipulate worksheets in a workbook
• Work with logical functions
• Create more complex formulas and functions
• Use absolute, relative and partial cell referencing
• Apply conditional formatting to ranges in a worksheet
• Apply protection to cells, sheets and workbooks
• Use a range of data sorting techniques
• Create and manipulate worksheet tables
• Create and modify charts
• Link to data in other worksheets and workbooks

This course in Microsoft Excel aims to provide users with the essential skills required to work with complex formulas, data analysis using a variety of tools and the ability to create simple macros proficiently.

Intended Audience

Suitable for experienced users of Excel wanting to explore more of the advanced analysis and automation tools found in this application.

Prerequisites

It is expected that participants will be familiar with using the basic functions of a computer such as navigating the Windows environment, navigating folders and copying and pasting objects. Additionally you should be confident operating a mouse and keyboard and have either completed Microsoft Excel Level 2 or have equivalent knowledge. If you don't already have these skills taking a course in Computer Basics and Excel Level 2 first would be recommended.

Delivery Style

Training is delivered as instructor-led computer-based training in a computer lab to individuals or small groups. Participants will have dedicated access to a modern computer with a large monitor and access to various assistive technologies such as sit stand desks, microdesks and a range of input devices to ensure comfort. Course materials are based on real world examples in a New Zealand context

Learning Outcomes

On completion of this training participants should be able to:

• Use the data consolidation feature
• Creat, use and modify data tables
• Create and modify PivotTables
• Create and modify PivotCharts
• Use advanced filters to analyse data
• Create and work with the scenarios feature
• Use a variety of data validation techniques
• Create and use a range of controls in a worksheet
• Group cells and use outline to manipulate the worksheet
• Use the macro recorder to create a variety of macros
• Share workbooks with other users