Certificate in Applied IT and Office Skills

• Layout of keys and correct technique, posture
• Proofreading, editing marks and symbols
• Use of touch typing software

• Understanding toolbars/ribbons/user interface
• Saving and opening documents
• Entering, editing and deleting text
• Home tab - formatting font, paragraph
• Page layout tab – changing margins, page orientation, line breaks
• Insert tab – inserting hyperlinks, page breaks, tables etc
• Managing files, creating folders
• Composing and formatting business letters
• Entering and manipulating tabs and tables
• How to create a mail merge

• Understanding toolbars/ribbons/user interface
• Understanding and inputting rows, columns, cells and cell referencing
• Entering, editing and deleting text and numbers
• Saving and opening spreadsheets
• Aligning data in cells
• Replicating data using Autofill
• Confidence working with the 4 mathematical operators in Excel + - * and /
• Understanding and using the following functions: SUM, MIN, MAX and AVERAGE and COUNT and COUNTA

• Understanding toolbars/ribbons/user interface
• Composing and sending emails
• Receiving, replying and forwarding emails
• Understanding appropriate use of cc and bcc, and how to call up these fields
• Attaching documents
• Organising emails / folders
• Scheduling with the outlook calendar:  setting appointments, business meetings and inviting people to same
• How to create a mail merge

• Understanding toolbars/ribbons/user interface
• Creating a new presentation
• Entering text into placeholders
• Saving and save as
• Inserting, formatting, sorting and deleting slides
• Working with bullets and numbering
• Presentation views and how they work on the monitor
• Use of slide design templates and which templates work best in different contexts

• Understanding toolbars/ribbons/user interface
• Creating a basic database table
• Creating fields and data types
• Saving tables
• Using the primary key
• Populating database tables
• Printing options/layout

• Preparing an effective CV
• Preparing cover letters/letters of application
• Preparing for a successful interview

• Understanding of the functions of an office
• Formatting and composing business correspondence
• Planning and scheduling diaries
• Management and security of files
• Use of telephone and telephone techniques

• Understanding the etiquette of business meetings and format and general composition of related documentation
• Understanding general office systems and procedures
• Agenda setting and minute taking
• Setting up mobile phone functions
• Use of a scanner
• Use of a franking machine
• Operating a petty cash system (Imprest system)
• Understanding of basic accounting terminology
• Understanding of basic payroll procedures

• Setting up a LinkedIn profile
• Building a network, how and when to search/add people
• Understanding LinkedIn etiquette
• Groups – how to join and contribute
• Setting business meetings and issuing invitations to same

General Fee Information 

The fee for this course is EUR1,250.  This may be made in one payment or divided into four payments.