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

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