Excel Introduction

Build a basic spreadsheet including selection, formatting and printing options as well as creating formulas to calculate values.

A spreadsheet allows us to easily record and manipulate large amounts of data. Having a grounding in the basics enables us to easily get more from our spreadsheets.

Learn how to save time with your data entry, improve your efficiency and produce a more readable and professional output.

Key content

  • Setting up a basic spreadsheet including formatting 
  • Page Setup options for printing
  • AutoFill and Flash Fill features
  • Building simple formulae
  • Using the AutoSUM functions
  • Sorting and filtering lists stored on a spreadsheet
  • Utilising tables to manage data
  • Understanding workbooks and moving and copying sheets

Objectives

  • Build a basic spreadsheet including formatting and printing options
  • Understand design concepts, including basic formulas to perform calculations
  • Deal with lists of data, often downloaded, to find and print what you need

Suitable for

New and existing users

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.

All others, please see our Registration page for more information.

Dates, times and venues for scheduled workshops 2018

Wednesday 17 January 2018, 9am-12pm
Room 305, Level 3, 49 Symonds Street, Auckland 0900

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

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

Monday 9 April 2018, 1-4pm
Room 305, Level 3, 49 Symonds Street, Auckland

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

Monday 11 June 2018, 1-4pm
Room 305, Level 3, 49 Symonds Street, Auckland

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

Monday 6 August 2018, 1-4pm
Room 305, Level 3, 49 Symonds Street, Auckland

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

Wednesday 3 October 2018, 1-4pm
Room 305, Level 3, 49 Symonds Street, Auckland