Spreadsheets: Workshop Series

3 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

Spreadsheets –

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 Session 1 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 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)

• Budget plans and managing money at home or work

•  

  Quote or Invoice document for work

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

Workshop 3 will include:

• Design your own spreadsheet(s) with assistance from the tutor

• Plan and design a spreadsheet: for example - a budget, member list for a club, invoices, calculations or sorting information

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