Course Objectives
In the 2-day training, you will gain the essential skills to create, edit, format, use of basic formulas and print worksheet. You will be able to:-
- Create simple formulas and understand the use of Absolute and Relative References
- Use of Autofill option and functions such as Sum, Average, Min, Max & Count
- Find and Replace Content & Formats and add Cell Comments
- Format Text and Values – Decimal place, Currency, Percentage & etc
- Manage worksheets and apply protection to worksheets and workbook.
- View large database effectively by Freeze panes, split and arranging windows.
- Managing Page setup and Printing
- Sorting and Filtering record using Tables.
Course Duration:
2 days (16 hours), 9.00am – 5.00pm
Course Dates:
Course Fee:
$360 ($392.40 incl. of 9% GST) per participant
SDF grant entitled, $2/hr x 14hrs = $28,
Course fee after funding (Inc. 8% GST): $364.40