Excel Intermediate

The flexibility and ease with which you can harness the power of Excel will have you in demand for your expertise.

Build on the spreadsheet skills you have already gained and learn additional skills for dealing with larger sheets and more complex data.

Key content

  • Viewing and printing larger worksheets, including print areas and print titles
  • Creating and using names in a workbook
  • Using absolute and relative cell references in formulas
  • Summaries using simple worksheet functions e.g. SUMIF and COUNTIF
  • Using conditional formatting to highlight cells and patterns
  • Creating custom lists for sorting
  • Streamlining your lists, remove duplicates and separate text
  • Using Tables to format, calculate and summarise data effectively

Objectives

  • Advance your understanding of formulae and formatting
  • Print all or part of larger spreadsheets effectively
  • Understand the importance of tables for data storage

Prerequisite

Excel Introduction

Suitable for

This is an intermediate 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. If you require a Mac, please contact us so that we can make the necessary arrangements. Excel 2016 is used. Also suitable for 2013 users.

Cost

Free for University of Auckland and UniServices staff

Registration

If you are University of Auckland staff, please visit Career Tools to view workshop availability and register on a session.

For all others, please see our Registration page for more information.

Dates, times and venues for scheduled workshops 2018

Monday 22 January 2018, 1-4pm
Room 305, Level 3, 49 Symonds Street, Auckland

Friday 2 February 2018, 9am-12pm
Room 305, Level 3, 49 Symonds Street, Auckland

Monday 5 March 2018, 1-4pm
Room 305, Level 3, 49 Symonds Street, Auckland

Wednesday 28 March 2018, 9am-12pm
Room 305, Level 3, 49 Symonds Street, Auckland

Tuesday 17 April 2018, 1-4pm
Room 305, Level 3, 49 Symonds Street, Auckland

Friday 18 May 2018, 9am-12pm - FULL
Room 305, Level 3, 49 Symonds Street, Auckland

Monday 28 May 2018, 1-4pm - Limited places available
Room 305, Level 3, 49 Symonds Street, Auckland

Wednesday 13 June 2018, 9am-12pm
Room 305, Level 3, 49 Symonds Street, Auckland

Thursday 28 June 2018, 1-4pm
Room 305, Level 3, 49 Symonds Street, Auckland

Tuesday 10 July 2018, 1-4pm
Room 305, Level 3, 49 Symonds Street, Auckland

Wednesday 8 August 2018, 9am-12pm
Room 305, Level 3, 49 Symonds Street, Auckland

Friday 31 August 2018, 9am-12pm
Room 305, Level 3, 49 Symonds Street, Auckland

Monday 10 September 2018, 1-4pm
Room 305, Level 3, 49 Symonds Street, Auckland

Thursday 27 September 2018, 1-4pm
Room 305, Level 3, 49 Symonds Street, Auckland

Wednesday 24 October 2018, 9am-12pm
Room 305, Level 3, 49 Symonds Street, Auckland

Monday 5 November 2018, 1-4pm
Room 305, Level 3, 49 Symonds Street, Auckland

Thursday 29 November 2018, 1-4pm
Room 305, Level 3, 49 Symonds Street, Auckland