Digital skills for the workplace: analysing, handling and presenting data with Excel (intermediate)
Time: 18:00 - 21:00
This course is FREE if a) you are on a Low Wage or b) you are either on Jobseekers' Allowance (JSA) or Employment & Support Allowance(ESA) or c) you receive other state benefits (including Universal Credit). For more information click here
This course will be delivered online. See the ‘What is the course about?’ section in course details for more information.
Course Code: CEX03
Please choose a course date
Duration: 5 sessions (over 5 weeks)
What is the course about?
This course will help you handle, analyse and present data across a range of different workplace scenarios. You will consider the importance of data; how to think about data; and how Excel can help you use and present it effectively. You will work on how to create automated budgets that take into account different conditions such as changes in price, sales and costs. You will work on how to link different sets of data across worksheets. You will work on how to track and identify trends and present them effectively. You will also learn about pivot charts and what to use them for. Finally you will focus on how to create different types of charts and when to use them.
This is a live online course. You will need:
- Internet connection. The classes work best with Chrome.
- A computer with microphone and camera.
We will contact you with joining instructions before your course starts.
What will we cover?
• the importance of data analysis in the workplace
•identifying key features of well-designed and well-presented data so it is easy to identify and read
•planning and creating automated budget sheets involving profit, loss, total and subtotal expenditures using conditional formatting, functions and formulae
•calculating trends and identifying the best ways of presenting this data
• linking data across worksheets
•summarising data using pivot tables
•presenting data effectively using charts.
What will I achieve?
By the end of this course you should be able to...
• identify the importance of data analysis in the workplace
•identify key features of well-designed and well-presented data
•plan and create automated budget sheets involving profit, loss, total and subtotal expenditures using conditional formatting, functions and formulae
•calculate trends and present them effectively
• link data across worksheets
•summarise data using pivot tables
•present data effectively using charts.
What level is the course and do I need any particular skills?
This is an intermediate level course. You should be confident in the basic functions of Excel. If you need to know the fundamentals of Excel use, do our Foundation course. If you need more advice, please call 0207 492 2511.
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 need access to MS Office to do this course. If you do not have this, you can sign in using your City Lit IT account here www.office.com to download and install it.
Please note: you will not have access to this after the end of the college year and it will override other MS Office applications on your PC. Help with downloading and installing Office is available here: Download and install or reinstall Microsoft 365 or Office 2021 on a PC or Mac.
You will need a pen, some lined A4 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 at the same time or after this course. These include:
• Digital Skills for the Office: how to work across and combine different MS Office programs (advanced)
• Digital Skills for the virtual and face-to-face office (intermediate)
• Digital skills for the workplace: increasing efficiency with Power-Automate
• Digital Skills for the workplace: using Excel (intermediate)
• Digital skills for the workplace: using Word 365 (intermediate)
• Digital skills for the workplace: using Word 365 (advanced)
• Digital Skills to apply for work: CVs, covering letters and use of social media
• Getting job ready: identifying the most in-demand work skills and how you can develop them
• Level 2 certificate in IT user skills (ECDL Extra)
• Level 3 certificate in IT user skills (ECDL Advanced)
• Pathway to ECDL level 3
You may also be interested in our How to be an Administrator series.
• How to be a skilled administrator in the virtual and face-to-face office: the essentials
• How to be administrator in the virtual and face-to-face office: how to be organised, efficient, precise and service-focused
• How to be an administrator: the online paperless office.