IT skills for the office: intermediate

Course Dates: 15/07/20 - 23/07/20
Time: 10:00 - 13:00
Location: Online

Are you working or wanting to start work in an office but lacking the confidence and digital skills to perform some of the more advanced office tasks? Are you already working as an administrator and wanting to progress in your profession? This course will help you develop your digital skills to be able to complete more complex office tasks with confidence. You will engage in various projects to learn how to use the internet to research and find informatiion effectively in order to create report documents containing detailed information, spreadsheets, and charts. You will learn how to analyse and visually represent your data as well as send personalised emails and use mail merge.

This course is FREE if one of the following applies:

a) You are employed and earn less than £20,962. You need to have lived in the UK or EU for the last 3 years and be a citizen of the UK or a country within the EU. You may also be eligible for this funding in other circumstances. When you come for assessment or enrolment, bring a pay slip dated within 3 months of the course start date, or a current employment contract that shows your gross salary. OR

b) You are either on Jobseekers' Allowance or Employment & Support Allowance. Please bring proof of income to your assessment or enrolment. OR

c) You receive other state benefits (including Universal Credit), earn less than £338 a month (individual claims) or £541 a month (household claims) and are doing the course to become employed or move into more sustainable employment.

Call 020 7831 7831 for more information.

This course will be delivered online. See the ‘How will I be taught’ section in course details for more information.


What is the course about?

This course will help you learn the more complex computer skills needed to work as a lead administrator, receptionist or secretary. You will learn how to carry out tasks needed to research information and then convert this into well-presented and easy to read documents for example in reports. You will learn how to edit and format information so it looks attractive and eye-catching. You will learn how to embed and insert the right sort of charts and also spreadsheets to make your data stand out. And you will then practise how to distribute your work using mail merge.

What will we cover?

• researching and using relevant information from the Internet.
• creating well-written and well-presented reports using key editing functions in Word
• creating and inserting the right type of chart to use for the type of data you have chosen
• integrating Microsoft Applications into your Word document
• mail merging your report using MS Outlook as a personalised email.

What will I achieve?
By the end of this course you should be able to...

• carry out the key computer skills needed to work as an efficient administrator, receptionist
• or secretary
• research reliable information from the Internet, evaluate its relevance and check for accuracy
• transfer this information into a Word document and edit it effectively
• apply advanced page layout using page breaks and styles
• integrate a number of Microsoft Applications into your document
• create a spreadsheet and different chart types
• import and link data from a workbook into you report
• send your report as a personalised email to members of your class as well as your tutor using mail merge and your outlook contact list.

What level is the course and do I need any particular skills?

This course is aimed at those who have some familiarity with the Microsoft Office package ie. are out intermediate level but want to learn more specific skills needed to work on an office or run a small business. It is an excellent follow on from our Introductory IT Skills for the Office.

How will I be taught, and will there be any work outside the class?

This will be a practical hands-on course. It will be task-based with classroom activities re enacting tasks typically carried out in an office at an advanced level. Each student has their own computer and you will be encouraged to practise as much as possible. An interactive whiteboard will help make demonstrations easy to understand. It will be a relaxed learning environment and step by step learning will help you become more skilled. You will have lots of opportunities to ask questions and address areas you need help in.

This course will be delivered online, and will involve tutor presentation and class discussion. Student preparation and homework outside class times is strongly encouraged. To fully participate in this online class you will need:
- An email address
- A reliable internet connection
- A computer/laptop/tablet with a fully updated browser (preferably google chrome). Your device will need a microphone, and preferably a camera.

Are there any other costs? Is there anything I need to bring?

Please bring a folder, pens and paper. There are no additional costs.

When I've finished, what course can I do next?

There are a variety of other courses you could do either at the same time or after this course. We have a number of courses on Word, Excel and Outlook many of which are specifically geared to developing your skills for the workplace. We also have Digital skills to find a better job, Making sense of Windows 10 and Touch typing and keyboard skills. We have a number of courses with qualifications including ECDL Level 2 and Level 3. You can try Pathway to ECDL if you are unsure if you want to do a qualification course straight away.

You may also be interested in our How to be an Administrator series - How to be an administrator: the essentials,
How to be an administrator: time management skills and How to be an administrator: the paperless office.

Your tutor will advise you on the best courses for you. You can also call our administrator on 0207 492 2511 to arrange an assessment with one of our course advisors.


Customer Reviews 1 item(s)

Write a review

Reviews below are by students who have attended this course, regardless of the course teacher. Please be aware you may not be booking onto a course with the same teacher.

Best. Teaching
Course Rating
Review by Navaratnam Kalanithy / (Posted on 30/07/2019)
Tutor Biographies
Aurica Jalba

Aurica Jalba has been lecturing for over 5 years MS Office at City Lit and providing Bloomberg training to undergraduate and MBA students at the University of East London (UEL). Aurica developed her teaching passion during her studies at university and strongly believes that education is for everyone and she is passionate about long-life learning. Her main priority is to treat everyone inclusive and support in the classroom and outside the classroom. She is well known for her patience, dedication, and clarity in teaching. She has developed some courses at City Lit, bespoke training for an Indian Delegation, and providing training for companies as a freelancer. From September 2019 she has been appointed as a Coordinator for the Business and Technology department. Aurica holds a Diploma in Ecology, BSs Economics, MS Finance and Risk, is an Associate to the Chartered Banker Institute (CBI) and BMC (Bloomberg Market Concepts) among others. In 2016, she was awarded the 3rd Place Winner leading a team at the UK University Trading challenge in trading. In 2015 she was involved in a research project about the feasibility of a 1mln pounds investment in Ghana.

Please note: We reserve the right to change our tutors from those advertised. This happens rarely, but if it does, we are unable to refund fees due to this. Our tutors may have different teaching styles; however we guarantee a consistent quality of teaching in all our courses.

Book your place

Course Code: CMO02

Wed-Thu, day, 15 Jul - 23 Jul '20

Duration: 4 sessions (over 2 weeks)

Full fee: £69.00
Senior fee: £55.00
Concession: £35.00

Or call to enrol: 020 7831 7831

Any questions?
or call 020 7492 2511

Please note: we offer a wide variety of financial support to make courses affordable. For more information visit our online Help Center. You can also visit the Information, Advice and Guidance drop-in service, open from 12 – 6.45, Monday to Friday.