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
Document Creation
Document Views
Inserting Text/Symbols/Special Characters
Text Manipulation
Basic Commands
Formatting
Font Type/Size/Edit/Case/Colour
Aligning/Indentation
Spacing
Lists
Borders/Shading
Styles
Text Wrapping
Objects
Tables
Graphics/Images/Shapes
Charts/Graphs
Referencing
Captions
Footnotes/Endnotes
Table of Contents/Figures
Collaborative Editing
Track Changes
Comments
Compare/Merge documents
Mail Merge
Main Document
Source Data
Outputs
Paper Orientation/Size
Margins
Breaks
Header/Footers
Page Numbering
Watermark
Spelling
Preview/Print
Intermediate Excel
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.
Cells
explain Workbooks/worksheets
data referencing - absolute and relative referencing
Sorting data, advanced sorting
Advanced filtering
Managing Worksheets
Switching between worksheets
Inserting, moving, renaming new worksheets
Freezing rows/columns
splitting a window
Functions & Formulae
3-D Sum Function
Vertical Lookup Functions
Preparing outputs
Title rows for printing
comments
track changes / review
compare & merge
printing
Google Workspace
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 Workspace, ask questions, and discuss ways to use Google Workspace more effectively.
The session will discuss features in Gmail, Chrome, Calendar and Drive, focusing on ways in which administrative members of staff can utilise them in their work. The session will allow time for questions and discussion. The topics that will be discussed include:
