Excel Introduction

Build a basic spreadsheet including selection and formatting options and other basic features of excel.

A spreadsheet allows us to easily record and manipulate large amounts of numerical 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

  • Entering and editing data, moving and copying data
  • AutoFill features
  • Navigation and selection techniques
  • Adjust column widths
  • Use text controls
  • Building simple formulae
  • Using the SUM function
  • Formatting your spreadsheet
  • Managing lists stored on a spreadsheet
  • Preview and print a spreadsheet

Objectives

  • Build a basic spreadsheet including selection and formatting 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. 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

Dates, times and venues for 2017

January - March 2017      

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

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

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

April - June 2017

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

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

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

July - September 2017

Registration is now open for all University of Auckland and UniServices staff.

Registration for all others opens in early June 2017. Please contact us from this date to request registration. Please note registrations will be processed on a first come first served basis.

Friday 7 July 2017, 9am-12pm 
Room 305, Level 3, Building 620, 49 Symonds Street, City Campus

Tuesday 1 August 2017, 1-4pm 
Room 305, Level 3, Building 620, 49 Symonds Street, City Campus

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