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
********************************************************************************************************************