Get qualified in Microsoft 365: Excel, PowerPoint and Word (level 2)
Time: 18:00 - 21:00
Location: Keeley Street
You need to do a pre-course assessment. Contact universal.skills@citylit.ac.uk / 020 8078 0489 for a face-to-face assessment or click the Start Assessment button on this page. Log on with your email address (not name).
This course is FREE if you are employed and on a low wage or you are claiming benefits. For more information Click here
Choose a start date
This course has now started
- Course Code: CDIT01B
- Dates: 21/10/24 - 05/12/24
- Time: 18:00 - 21:00
- Taught: Mon+Thu, Evening
- Duration: 15 sessions (over 7 weeks)
- Location: Keeley Street
Course Code: CDIT01B
Please choose another course date
Duration: 15 sessions (over 7 weeks)
Please note: We offer a wide variety of financial support to make courses affordable. Just visit our online Help Centre for more information on a range of topics including fees, online learning and FAQs.
What is the course about?
This course will help you develop the most essential digital skills needed in the modern workplace. At the same time you will gain a level 2 qualification in digital skills. You will focus on a range of word-processing skills so you can create well-presented and informative documents. You will develop your skills on PowerPoint so you can create attractive, effective and inclusive presentations for a variety of audiences. And you will improve your data manipulation and handling skills by practising key advanced features on Excel including use of formulae and pivot tables as well as learning the basic principles of the Access database.
What will we cover?
A summary of the areas we will cover includes:
WORD
• using appropriate templates to create a variety of documents to meets the specific needs of a workplace
• enhancing document content by using editing tools, appropriate formatting and styles
• organising and arranging information from different sources including mail merge letters and address labels, charts from spreadsheets and images
• saving and retrieving documents using local and cloud-based methods
• using page and section layouts
• inserting and modifying tables and graphics
• proof-reading documents using correct tools
• mail-merging
• using time-saving devices such as macros
POWERPOINT
• identifying how audience and purpose can influence presentation format and content.
• using custom slide layouts, templates and designs appropriate for purpose and audience.
• entering and combining text, graphics and media into a presentation to suit the purpose of the presentation
• inserting tables and charts to communicate information accurately.
• identifying the legal and ethical constraints that need to be considered when creating presentations
• applying inclusive design techniques to make a presentation accessible.
EXCEL
• processing data effectively and increasing productivity by using advanced formulae and functions including conditional formatting and using pivot tables
• editing and formatting data using tools and techniques
• displaying spreadsheet data in a graphical format
ACCESS
• understanding and becoming familiar with basic access functions.
What will I achieve?
By the end of this course you should be able to...
•pass Gateway's Level 2 Award in Digital and IT Skills by achieving in the word-processing and presentation units
By completing the course successfully you will be to:
• use appropriate templates to create a variety of documents to meets the specific needs of a workplace
• enhance document content by using editing tools, appropriate formatting and styles
• organise and arrange information from different sources including mail merge letters and address labels, charts from spreadsheets and images
• save and retrieve documents using local and cloud-based methods
• use page and section layouts
• insert and modify tables and graphics
• proof-read documents using correct tools
• mail-merge effectively
• use time-saving devices such as macros
POWERPOINT
• identify how audience and purpose can influence presentation format and content.
• use custom slide layouts, templates and designs appropriate for purpose and audience.
• enter and combine text, graphics and media into a presentation to suit the purpose of the presentation
• insert tables and charts to communicate information accurately.
• identify the legal and ethical constraints that need to be considered when creating presentations
• apply inclusive design techniques to make a presentation accessible.
EXCEL
• process data effectively and increase productivity by using advanced formulae and functions including conditional formatting and using pivot tables
• edit and format data using tools and techniques
• display spreadsheet data in a graphical format
ACCESS
• understand and use basic Access functions.
What level is the course and do I need any particular skills?
This is a level 2 course, which requires solid foundational skills in Microsoft Office. We recommend completing some or all of the courses below before or at the same time as this accredited course.
• Becoming confident in digital skills: Word, Excel, PowerPoint and Outlook (beginner)
• Essential digital skills for the workplace: Word, Excel and PowerPoint (foundation-level 1)
• Business Administration: using Word, Excel, PowerPoint and Access (intermediate-level 2).
How will I be taught, and will there be any work outside the class?
You will learn in a supportive and welcoming environment with an emphasis on your discovering how to do and complete tasks, with guidance from the tutor. You will work on your own and with other students on different tasks so you are always practising important in-demand life and work skills such as problem-solving, decision-making, prioritising, negotiating, collaborating and independence. You will learn in a step by step manner so you can complete challenging tasks in enjoyable and relaxing ways. Your tutor will also work with you individually so you know how to improve and how to work in a way that improves your learning. You will need to do work outside the classroom and use Google Classroom to help you.
Are there any other costs? Is there anything I need to bring?
You will need a pen, paper and a file to keep your work in. Your tutor will provide handouts and a code for Google classroom so you can communicate with classmates and access materials, videos etc. online.
When I've finished, what course can I do next?
There are many courses you can do before, during or after this course. These include:
• Business Administration: using Word, Excel, PowerPoint and Access (intermediate-level 2)
• Touch typing and keyboard skills
• Business Administration: getting ready for level 3 certificate in IT user skills - ICDL Advanced (intermediate)
• Level 3 certificate in IT user skills (ICDL Advanced)
• Essential digital skills for the workplace: Word, Excel and PowerPoint (foundation-level 1)
• Digital skills for the workplace: working with data - inputting, finding, sorting, filtering with Excel (foundation)
• Digital skills for business: analysing, handling and presenting data with Excel (intermediate)
• Digital skills for business: visualising data with Excel - from column charts to scatter plots (intermediate)
• Digital skills for business: how use Teams and SharePoint for collaboration (intermediate)
• Digital skills for business: how to use SharePoint for collaboration (intermediate)
You can also do classes in the maths and English areas. These include:
• Maths for business: the essential skills to run a company and make a profit (level 1-2)
• Communication skills for business: using drama to communicate with impact (level 2)
• Communication skills for business: how to tell a story with data in your writing and presentations (level 2)
• Communication skills for business: how to be clear, concise and organised in your writing (level 2)
• Core management skills: leading and building teams (introduction)
• Core management skills: organising, delegating, decision-making (introduction)
• Core management skills: developing your coaching skills (introduction)
For more information, talk with your tutor or contact universal.skills@citylit.ac.uk / 020 4582 0423.