Course Description

This course will give you the confidence to effectively use this application at work or home to store, display, and analyze data. 

What Will You Gain?

Our kaiako/tutor, Allan will cover the below topics:

• Tables. Slicers and Timelines
• Subtotals and Named Ranges
• Date adn Time Functions
• Conditional Formatting
• Counting and Probability
• Sparklines, Sustitute, Choose
• xLookup, vLookup, hLookup
• Index, (x)Match, Indirect, Offset
• Data Import/Export. Excel Options
• Custom Chart Types (separate)

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.