Trainer:Mr Andrew Zammit - IT Systems Engineer Target Audience: Administrative staff Duration of Session: 6 hours
This workshop will be delivered by IT Services and is intended to help all administrative members of staff with performing day-to-day tasks using MS Word. The structure of the programme is designed over three 2-hour sessions.
On completion of this module, candidates will be able to:
Using the Application
Open/Closing/Saving a Document
Inserting Text/Symbols/Special Characters
Table of Contents/Figures
Trainer:Mr Matthew Dalli - IT Specialist Target Audience: Administrative staff Duration of Session: 6 hours
This workshop will be delivered by IT Services and is intended to help all administrative members of staff with performing daily tasks on their computer. The structure of the programme is designed over three 2-hour sessions.
The course will cover the following:
Using Ms Excel (Intermediate level)
On completion candidates will be able to:
Work with multiple workbooks and worksheets.
Select, sort and copy, move and delete data.
Edit and freeze rows and columns in a worksheet.
Create mathematical and logical formulas using standard spreadsheet functions; use good practice in formula creation; recognise error values in formulas.
Use more complex functions; including 3-D sum function and look-up functions.
Using collaboration tools; track changes, compare and merge.
Organise, adjust, check and correct spreadsheet content before printing content.
data referencing - absolute and relative referencing
Sorting data, advanced sorting
Switching between worksheets
Inserting, moving, renaming new worksheets
splitting a window
Functions & Formulae
3-D Sum Function
Vertical Lookup Functions
Title rows for printing
track changes / review
compare & merge
Trainer:Mr Kurt Borg - Senior IT Specialist I Target Audience: Administrative staff Duration of Session: 6 hours
This 6-hour session will enable administrative members of staff to learn more about Google Suite, ask questions, and discuss ways to use Google Suite more effectively.
The session will discuss features in Gmail, Chrome, Calendar and Drive, focusing on ways in which administrative members of staff can utilize them in their work. The session will allow time for questions and discussion. The topics that will be discussed include: