We aim to cover the top 15 functions you might need to advance your Excel skills, and the techniques you need to make them work harder; absolute and mixed cell references, nesting, using range names and Table ‘structured references’. Please read below for greater detail and prerequisite skills.
NOTE: This course offers a course fee subsidy through funding from the Tertiary Education Commission (TEC) for NZ citizen and permanent migrant adults, and young people aged 16+ who are not currently enrolled in a NZ secondary school. We need to collect extra information such as age, ethnicity, educational achievement and gender for statistical purposes. You must also provide evidence of NZ citizenship or residency if requested. A condition of accepting this course fee subsidy is that you will attend at least 80% of classes.
We aim to cover the top 15 functions you might need to advance your Excel skills, and the techniques you need to make them work harder; absolute and mixed cell references, nesting, using range names and Table ‘structured references’. These functions include:
We also want to look at ways you manage data; using Tables effectively, Data Validation, conditional formatting, Power Query to edit and transform data, and Pivot Tables to analyse it. If there is demand we can introduce recording and running your own Macros although this is a huge topic in itself so we can likely only touch upon this.
A strong working knowledge of Excel formula writing and list management techniques is a prerequisite for attending this course.
Classes will be held in one of our school PC suites. Please bring a USB stick with you to class.
A strong working knowledge of Excel formula writing and list management techniques is a prerequisite for attending this course. Please contact the office to discuss your situation if you are unsure whether this is the right course to advance your skill level.
Excel Intermediate, Excel Pivot Tables
(09) 521 9623
info@selwyncomed.school.nz
203-245 Kohimarama Road, Kohimarama
Open Hours
Term Time: Monday - Wednesday 9:00am - 9:00pm
Thursday - Friday 9:00am - 3:00pm
School Holidays: When courses are running the office is open 9:00am - 4:00pm