Course Description

This course will provide you with the confidence to effectively use Excel Application at work for various tasks, such as display and data analysis. It also includes information on Pivot Tables, Charts and Slicers

What Will You Gain?

During the 6 hours course, our kaiako/tutor, Allan will cover the below topics:

• Validation, Protection and Auditing
• SumProduct and Dynamic Arrays
• Logic, Let and Lambda
• Financial Functions and Co-Authoring
• Macros, Add-ins and the QAT
• Templates and the Visio Visualiser
• VBA and Form Controls
• Pivot Tables, Charts and Slicers
• Pivot Table Options. GroupBy
• Relationships and Data Models

Course Materials

The tutor provides soft copies of supportive materials. The cost of materials is included in the course fee.

Course Prerequisites

It is recommended that you bring your laptop to this workshop.

We also recommend that students participating in computer classes bring a USB Flash drive. This will enable you to download information to take home.

Course Fee Subsidy

This course is subsided by Tertiary Education Commission (TEC) for NZ citizens and permanent migrant adults, their partners on work visas or visitor visas, and refugees. To qualify, registrants should be over the age of 16 years and not currently enrolled in a secondary school. You must provide evidence of NZ citizenship, residency, or refugee status to our staff for sighting purposes.

For Non- Resident students, there will be a surcharge of NZD$99.

Please note: All courses need a minimum number to go ahead. If your course does not have enough enrolments, we regret that we will have to cancel and will let you know either by email or text. Courses are usually cancelled, when necessary, 2-3 working days prior to the scheduled start date.