LSEL Excel Basics - Academic Skills Centre - University of Canterbury - New Zealand

Excel Basics

This course will introduce the basics of Excel. Students will learn how to create spreadsheets, manipulate data, use functions, create formulas and charts. No prior knowledge is required.

Session 1 (getting started, simple calculations)

  • Familiarity with Excel (layout, terminology, helpful features)
  • Entering data
  • Simple Excel calculations
  • Introduction to Excel functions
  • Formatting cells
  • Working with rows and columns
  • Copy and paste
  • Printing
  • Saving and retrieving your work

Session 2 (dealing with more data)

  • Sorting data
  • Filtering data
  • Row and column calculations
  • Working efficiently with bigger spreadsheets
  • More Excel functions
  • Introduction to Excel charts
  • Using Excel results in Microsoft Word (if time permits)

Session 3 (a little bit beyond the basics with Excel)

  • More on Excel charts
  • Pivot tables and pivot charts
  • Useful tips and tricks with Excel

Tutor: Jenny Harlow

Dates and times

  • Tuesdays, 26 February to 12 March 2018 between 3.00 pm-3.50 pm (NB: Venue: Erskine Building, Level 4, Room 442): passed
  • Tuesdays, 23 July to 6 August 2019 between 11.00 am-11.50 am (NB: Venue: Erskine Building, Level 4, Room 442): enrolment and venue>>

 

Even if this workshop is fully booked, it is likely there will be space on the day, so feel free to turn up. If you would like to be notified when this workshop is next scheduled, request it at a different time or day, or just find out more, email Angel Nicholson