Course Details
Course Title and Level
OCN Microsoft Office Skills for the Workplace Level 2
Course Summary
This Level 2 Digital Skills course helps you work more efficiently with Microsoft Office by focusing on automation and professional document creation. You’ll learn how to use macros in Word and Excel to automate everyday tasks, saving time and increasing productivity. You’ll also develop advanced skills in Microsoft Word, including creating live tables of contents, formatting images, adding references, and compiling bibliographies. As part of the course assessment, you will complete a practical project on online safety for children, which allow you to apply these skills in a real-world context.
Who is this course for?
This course is ideal for confident users of IT, looking to further develop their digital abilities for work, further study, or personal development.
What will I learn on this course?
By the end of the course the learners will be able to:
•
Understand how automation can improve productivity in Microsoft Word and Excel.
•
Create and edit macros to automate routine office tasks in Word and Excel.
•
Develop advanced Word skills, including formatting, inserting images, and creating live tables of
contents.
•
Add captions, hyperlinks, references, and compile bibliographies in Word documents.
•
Research a topic (i.e. online safety for children) and design a professional leaflet using your newly
learnt digital skills.
Progression Opportunities
After completing this course, you will be well-prepared to progress to further digital learning opportunities at CALAT, such as Getting Started with Digital Marketing, Introduction to Data Analysis using Microsoft Tools or AI: Practical Applications in the Real World. The skills gained on this course will also support career development in roles that require strong digital and document-handling skills.
Course Entry Requirements
To join this course, you should have completed a non-accredited Level 2 Digital Skills course at CALAT. If you are applying as an external candidate, you will need to demonstrate digital skills at Level 2 through an initial assessment.
Course Location / Delivery Method
CALAT Clock Tower / Classroom-based learning in a small group setting (maximum 12 learners), with personalised support from the tutor.
You will need to complete some homework outside the classroom. The course is 12 weeks, one weekly session of 5 hours. You will be expected to attend all sessions, as skills build progressively each session.
Additional Information (equipment etc.)
You will need to bring a pen, paper and a file to keep your work in.
Exams / Accreditation
This is an accredited course, however there is no formal exam. You’ll need to submit a portfolio of work to show your progress. If you pass the course, you’ll achieve OCNLR Level 2 Award in Skills for Professions in Digital Industries and Technology and receive a certificate from the awarding body.
Joining Instructions
Click the ENROL button below or, for more information email CALAT-ICT@croydon.gov.uk or call 020 8726 6000 (Extension 28230).
Before you enrol, you’ll need to attend a Digital Skills Taster session, where you'll complete a short assessment to help determine your suitability for the course. If needed, we’ll recommend a more appropriate option.
Courses