Selwyn Community Education

  • Home
  • Our Courses
  • About Us
  • News and Blog
  • Selwyn College
  • Contact Us
  •  
  •  

Microsoft Excel Advanced – Formulae and Functions

    Home Microsoft Excel Advanced – Formulae and Functions

    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.

    • Wed 26 Jul
      4 classes, Wednesdays 7:00 PM - 9:00 PM At Selwyn College, Auckland. Jose Entrican
      • TEC-subsidised course fee for qualifying students: $25.00 incl. GST
      • $98.00 incl. GST
      Session information
      Sessions
      Session 1
      Wed 26 Jul 19:00 - Wed 26 Jul 21:00
      At Selwyn College, Auckland.
      Session 2
      Wed 02 Aug 19:00 - Wed 02 Aug 21:00
      At Selwyn College, Auckland.
      Session 3
      Wed 09 Aug 19:00 - Wed 09 Aug 21:00
      At Selwyn College, Auckland.
      Session 4
      Wed 16 Aug 19:00 - Wed 16 Aug 21:00
      At Selwyn College, Auckland.
      Register
    • Wed 18 Oct
      4 classes, Wednesday 7 - 9 PM At Selwyn College, Auckland. Jose Entrican
      • TEC-subsidised course fee for qualifying students: $25.00 incl. GST
      • $98.00 incl. GST
      Session information
      Sessions
      Session 1
      Wed 18 Oct 19:00 - Wed 18 Oct 21:00
      At Selwyn College, Auckland.
      Session 2
      Wed 25 Oct 19:00 - Wed 25 Oct 21:00
      At Selwyn College, Auckland.
      Session 3
      Wed 01 Nov 19:00 - Wed 01 Nov 21:00
      At Selwyn College, Auckland.
      Session 4
      Wed 08 Nov 19:00 - Wed 08 Nov 21:00
      At Selwyn College, Auckland.
      Register
    Share

    Let me know about future course dates

    Description

    Course fees

    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 or visitor visas, and refugees. To qualify, registrants should be over the age of 16 years and 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. The subsidised course fee is $25.

    About Excel Advanced

    Effective formula writing is a must for taking your Excel skills further- this includes knowing when to use different types of cell references in formulas, range names and the Structured References used in Excel Tables. You will also need to go beyond the basic Functions that are used everyday such as SUM, COUNT and AVERAGE. This course aims to introduce you to the logical function IF, the summary functions SUMIF and COUNTIF and the classic VLOOKUP function. We will also cover dealing with text and dates in calculations including the CONCATENATE and WORKDAYS and NETWORKDAYS functions.

    One of the most in demand Excel skills is being able to create effective data summaries so we will also look at ways you manage data; using Tables effectively, Data Validation, conditional formatting, introduce Power Query to edit and transform data, and PivotTable features used to analyse and chart it. Both PowerQuery and PivotTable functions are covered in more detail in other half-day workshops.

    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 a school computer suite running Windows and using Microsoft Excel 2016 (part of Office Professional Plus). Please bring a USB stick with you to class to save your work.

    People who attended this course also attended...

    MS Excel Advanced: Pivot Tables, Excel Advanced: Power Query or Data Transformation, MS Excel Advanced: Data Analysis

    Powered by Arlo training & Event Software
    Share

    new-logo-circle-web

    (09) 521 9623
    info@selwyncomed.school.nz
    203-245 Kohimarama Road, Kohimarama

     

    COVID-19 Information

    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




    Powered by Graphic Detail Ltd
    • Home
    • Our Courses
    • About Us
    • News and Blog
    • Selwyn College
    • Contact Us
    •  
    •  

    Selwyn Community Education