Spreadsheets: Workshop Series

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

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