Excel Formulae and Functions

Most users are familiar with just the tip of the iceberg in this application. Make this powerful application work for you!  

 Expand your calculation repertoire with advanced formula techniques and functions that deal with a variety of spreadsheet data.

Ideal for all staff involved in student activities, finances or those dealing with research results.

Key content

  • Working with text in formulas - concatenating or adding text, and separating text
  • Date functions including calculating due dates and ages
  • Using logical and error checking functions such as IF and IFERROR
  • Dealing with academic results using VLOOKUP and RANK functions
  • Summarising data with the SUMIF and COUNTIF functions
  • Calculating interest earned or paid using financial functions
  • Rounding and random number generation
  • Array formulas

Objectives

  • Be able to use mixed or absolute cell references and range names in formulas confidently
  • Insert a variety of worksheet functions from most categories
  • Understand how to 'nest' functions

Prerequisite

Excel Intermediate

Suitable for

This is an advanced level workshop which is suitable for those who have completed the prerequisite or who are competent with the topics covered in that workshop. Before registering, it is your responsibility to ensure that you are competent with the topics covered in the prerequisite workshop.

Notes

PC and Mac computers are available on a first-come, first-served basis. Excel 2013 is used. Also suitable for 2010 users.

Cost

Free for University of Auckland and UniServices staff
Free for University of Auckland postgraduate students
$125+GST for others

Registration

Visit our Registration page to learn about registering, withdrawing and our cancellation policy.

Dates, times and venues for 2017

July - September 2017

Monday 17 July 2017, 1-4pm - CANCELLED
Room 305, Level 3, Building 620, 49 Symonds Street, City Campus

Friday 4 August 2017, 9am-12pm - CANCELLED
Room 305, Level 3, Building 620, 49 Symonds Street, City Campus

Wednesday 13 September 2017, 9am-12pm
Room 305, Level 3, Building 620, 49 Symonds Street, City Campus

October - December 2017

Thursday 26 October 2017, 1-4pm
Room 305, Level 3, Building 620, 49 Symonds Street, City Campus

Tuesday 21 November 2017, 9am-12pm
Room 305, Level 3, Building 620, 49 Symonds Street, City Campus