A general introduction to the basics of using Microsoft Excel. Familiarise yourself with the skills necessary to produce effective spreadsheets
- Duration: 1 x 2 hour session. We work in blocks of no more than 90 minutes with a short 10 minute break for tea/coffee
- Time: 6.30pm – 8.30pm weeknights
- Dates: see the classes calendar on the left
- Cost: $45. Bring a friend and reduce the cost to $40 each
- Provided: manuals, USB memory stick (yours to keep), tea + coffee + nibblies
Topics include:
- What is a spreadsheet
- Columns, rows and cell addressing
- Types of data
- Formatting cells – column width & row height
- Formatting data – various ways of representing values
- Sorting data
- When is a number not a number
- Performing calculations
- Using formulas
- Some basic formulas
- Replicating formulas – making things easier
- Some case studies
[...] Excel Basics [...]