Unlock the power of spreadsheets during this 3 hour session. Learn how to use basic formulas to make day-to-day tasks such as keeping a budget or balancing the figures so much easier.
- Duration: 1 x 3 hour session. We work in blocks of no more than 90 minutes with a short 10 minute break for tea/coffee
- Time: 6pm – 9pm weeknights
- Dates: see the classes calendar on the left
- Cost: $65.
- Bring a friend and reduce the cost to $60 each
- Provided: manuals, USB memory stick (yours to keep), tea + coffee + nibblies
Topics covered include:
- Concept of a worksheet and a workbook
- Cells, columns and rows, cell addressing
- Types of data that can be entered into a spreadsheet (worksheet)
- Manipulating data – entering text & numbers and the default settings, editing data, selection options, formatting
- Customising Excel to fit the way you work
- Selecting commands – menu bar & toolbars, keyboard shortcuts, shortcut menus
- Views – when and how to use them
- Moving around a worksheet – using the mouse or the keyboard
- Formatting columns, rows and cells
- Formulas – entering and replicating formulas
- Printing basics
- Now it is your turn