Microsoft Excel – Advanced
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.
-
Mon 01 Nov
- TEC-subsidised course fee for qualifying students: $30.00 incl. GST
- $105.00 incl. GST
Sessions
Session 1
Mon 01 Nov 19:00 - Mon 01 Nov 21:00Selwyn College, Auckland.Session 2
Mon 08 Nov 19:00 - Mon 08 Nov 21:00Selwyn College, Auckland.Session 3
Mon 15 Nov 19:00 - Mon 15 Nov 21:00Selwyn College, Auckland.Session 4
Mon 22 Nov 19:00 - Mon 22 Nov 21:00Selwyn College, Auckland.Session 5
Mon 29 Nov 19:00 - Mon 29 Nov 21:00Selwyn College, Auckland.
Description
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.
About Excel Beginners
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:
- IF in conjunction with ISBLANK and logical conjunctions such as AND and OR
- Summary functions such as SUBTOTAL, SUMIF, COUNTIF, SUMIFS and COUNTIFS
- Classic reference functions VLOOKUP with ISERROR and MATCH and INDEX
- Understanding dates and date calculations including WORKDAYS and NETWORKDAYS
- Using text in formulas including the CONCATENATE function
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.
Who should attend?
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.
Prerequisites
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.
People who attended this course also attended...
Excel Intermediate, Excel Pivot Tables
