IT Services

Intermediate Word

Trainer: Mr Kurt Borg - Senior IT Specialist I 
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 Suite

Trainer: Mr Roderick Mifsud - 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:

Chrome

  • Sign in
  • Multiple profiles
  • Bookmarks (Bookmarks manager)
  • Custom search engines
  • History deletion
  • Incognito mode

Calendar

  • Create/Cancel/Update events
  • Add/Remove invitees
  • Accept/Decline invitations
  • Multiple calendars
  • Share calendars
  • View/Hide shared calendars

Gmail

  • Gmail interface
  • Send emails
  • Filters/Labels/Categories
  • Advanced search
  • Forwarding
  • Offline access

Hangouts / Hangouts Chat / Hangouts Meet

  • Text chat
  • Video chat

Keep

  • Notes
  • Reminders 

Tasks

  • To-do lists 

Drive

  • Upload and share files
  • Docs
  • Slides
  • Sheets
  • Forms
  • Edit MS documents
  • Team Drives
  • Backup and sync / Drive file stream


 


https://www.um.edu.mt/hrmd/trainingdevelopment/coursesandresources/itservices