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, their partners on work visas, refugees, NZ citizen and permanent resident young people aged 16+ who are not currently enrolled in a 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, residency or refugee status if requested. A condition of accepting a course fee subsidy is that you commit to at least 80% attendance of your course.
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
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