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 workbooks. The flexibility and ease with which you can harness the power of Excel will have you in demand for your expertise.

Key content

  • Viewing and navigating larger worksheets
  • Advanced printing options, including print areas and print titles
  • Creating and using names in a workbook
  • Absolute and Relative cell references in formulas
  • Review of simple worksheet functions e.g. SUM and AVERAGE
  • Working with multiple sheets and multiple files, and linking data between them
  • Streamline your lists - remove duplicates and separate text into columns
  • Workbook management including duplication of sheets, grouping and hiding

Objectives

  • Advance your understanding of formulae and formatting
  • Print all or part of larger spreadsheets effectively
  • Manage workbooks more efficiently and securely

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 for this workshop, 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 will be used. Also suitable for 2010 users.

Cost

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

Dates, times and venues for 2017

January - March 2017      

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

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

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

April - June 2017

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

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

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

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

July - September 2017

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

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

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

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

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