courses a z hatregister key smalltimetable-btn calendar4 001

Font size

Spreadsheets: Workshop Series

excel logoexcel spreadsheets2

4 sessions of 2-hour workshops. $10 per session
For Windows or Mac users with Microsoft Excel or equivalent

 
Spreadsheets –
  • what are they ?
  • how useful are they ?
  • how to design spreadsheets for home and/or work
  • how to use formulas for a range of calculations
  • how to use spreadsheets to produce interactive charts
  • how to use Pivot Tables and Pivot Charts
Overview

This series of workshops is presented using Microsoft Excel. However, a number of other free programs are compatible with documents produced in Excel and have similar features. These include:

  • OpenOffice Calc
  • Google Docs - Sheets
  • Libre Office
  • Polaris Office

********************************************

Workshop 1 will include:

  • An introduction to Spreadsheets
  • Creating simple formulas
  • Using common formulas
  • Formatting a spreadsheet

By the end of Session 1 you will learn how to design spreadsheets for the following examples:

  • Shopping lists
  • Holiday planner

********************************************

Workshop 2 will include:

  • Using filters in Spreadsheets
  • Sorting information
  • Connecting several worksheets together
  • Creating more complex formulas including Conditional formulas

By the end of Session 2 you will learn how to design spreadsheets for the following examples:

  • Budget plans and managing money at home or work
  • Travel Budget
  • Quote or Invoice document for work

********************************************

Workshop 3 will include:

  • Producing Interactive Charts from Spreadsheets - Charts (Bar, Column, Pie, others)

By the end of Session 3 you will learn how to design spreadsheets for the following examples:

  • Charts for Book Sales
  • Travel Budget that combines calculations and charts
  • Weekly Timesheet for an organisation (Calculations, Formatting, Charts)

********************************************

Workshop 4 will include:

  • Pivot Tables and Pivot Charts
  • How to use spreadsheets to process and analyse large quantities of information

By the end of Session 4 you will be expert on the use of Spreadsheets and will be able to design your own spreadsheets

********************************************

Please register early to secure your place in our Courses and Workshops:

  • Click here (Timetable) to see if there is currently a course scheduled.
  • You need to supply the name of course or workshop and your membership number.
  • If the course you want is not listed on the Timetable please email learner@seniornetnelson.org.nz
  • NOTE - There is no need to enrol for Interest Groups, Help Sessions or Club Day Meetings, just turn up
  • REMEMBER - You need to be a paid-up member of SeniorNet Nelson to take a course.