IT Skills for Employment - Level 2 (Certificate)

By the end of the course, learners will be able to use:

Microsoft Word to:

• Create a formal document such as a business letter or applying for a job
• File maintenance, printing, saving, opening and closing files
• Insert tables, images and borders
• Insert information from one document into another
• Mail-merge

Microsoft Excel to:

• Create a new spreadsheet
• File maintenance, print, save, open and close files
• Use simple formulae for calculations e.g. SUM, +, -, /, *
• Replicate (copy) formulas across more than one cell range
• Use more advanced formulae such as average and count, and conditional formulae such as if copying formulae across more than one cell range
• Create and format a chart, which can then be used in presentations

Microsoft PowerPoint to:

• Create a short presentation from a template (master) slide
• File maintenance, print, save, open and close files
• Insert pictures, charts, tables, and organisation charts into a presentation
• Add speaker notes and timings to a presentation