courses a z hat  register key   course timetable  google calendar icon

 

Font size

Spreadsheets: Workshop Series

Excel simple budget spreadsheet

2 x 2-hour workshops. $10 per session
For Windows or Mac users with Microsoft Excel
You can register for all of these workshops or just one

Contact Mike Ellis to register: This email address is being protected from spambots. You need JavaScript enabled to view it.

 

Introduction

Learn just how useful for everyday things a spreadsheet can be - everything from shopping lists to holiday plans and budgets.

  • 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

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
  • Polaris Office
  • Microsoft Office online

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

Workshop 1 will include:

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

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

  • Shopping lists
  • Holiday planner

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

Workshop 2 will include:

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

By the end of the session 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)
  • Budget plans and managing money at home or work
  • Quote or Invoice document for work

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

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 contact@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.