Spreadsheets: Workshop Series

2 x 2-hour workshops.
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

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