Digital Skills for the workplace: using Excel (intermediate)

Course Dates: 10/02/22 - 10/03/22
Time: 10:00 - 13:00
Location: Online
Do you want to learn some of Excel more sophisticated functions? Are you an administrator or manager who needs to use it for more complex tasks? With realistic workplace assignments, you will focus on how to use Excel as a tool to complete key work-based tasks such as presenting data in an easily readable form and using functions such as average, minimum and maximum to make quick and accurate calculations. You will work on how to use Excel to solve problems based on certain conditions such as if interests rates go up by 1% what the effect will be on borrowing. You will also work on how to manipulate and work with more complex data through advanced formatting, effective filtering and basic pivot tables as well working across worksheets and other MS programs.
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.
Download
Book your place
In stock
SKU
178037
Full fee £179.00 Senior fee £143.00 Concession £90.00

Course Code: CEX13

Thu, day, 10 Feb - 10 Mar '22

Duration: 5 sessions (over 5 weeks)

Or call to enrol:020 7831 7831

Please note: We offer a wide variety of financial support to make courses affordable. Just visit our online Help Center for more information on a range of topics including fees, online learning and FAQs.

What is the course about?

This course will help you make the most of Excel so that many of your day to day office tasks become easier and you become more efficient in handling and analysing data. You will learn how to use tables, graphs and charts to present information more effectively as well as manipulate data using calculations, conditional formatting and effectively filtering. You will gradually learn how to work with complex data including working across multiple sheets and linking to other Microsoft programs.

This is a live online course. You will need:
- Internet connection. The classes work best with Chrome.
- A computer with microphone and camera.
- Earphones/headphones/speakers.
We will contact you with joining instructions before your course starts.

What will we cover?

• presenting data so it is easy to read and understand such as by changing the font, colour, size and style, working with columns and rows and entering fields into headers and footers.
• making quick and efficient calculations using Sum, Average, Maximum and Count.
•managing and handling more complex data by working on multiple sheets simultaneously.
• using Excel to solve complex problems based on changing situations through conditional formatting
•presenting, manipulating and analysing data using basic pivot tables and effective filtering
•present and analysing data by creating visually appealing charts and graphs
•handling and linking data across different sheets and other applications such as Word
•using spreadsheets in Word documents.

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

•use Excel effectively in the workplace to handle complex data and create fully functioning spreadsheets
• present data so it is easy to read and understand such as by changing the font, colour, size and style, working with columns and rows and entering fields into headers and footers.
• make quick and efficient calculations using Sum, Average, Maximum and Count.
•manage and handle more complex data by working on multiple sheets simultaneously
• use Excel to solve complex problems based on changing situations through conditional formatting
•present, manipulate and analyse data using basic pivot tables and effective filtering
•present and analysing data by creating visually appealing charts and graphs
•handle and linking data across different sheets and other applications such as Word
•use spreadsheets in Word documents.
• save time by using and creating templates.

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 and in general computer use. The course is specifically aimed at people who need to use spreadsheets in the workplace though it will also help you in everyday home use. You can call our administrator on 0207 492 2511 for more advice about your suitability for the course.

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, some lined A4 paper and a folder 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, at the same time or after this course. These include:
• Becoming MORE confident on PowerPoint 365 (intermediate)
• Digital skills for the workplace: analysing, handling and presenting data with Excel (intermediate)
• Digital skills for the workplace: using Word (intermediate)
• Digital skills for the workplace: using Word (advanced)
• Digital Skills for the virtual and face-to-face office (intermediate)
• Digital Skills for the Office: how to work across and combine different MS Office programs (advanced)
• Digital skills for the workplace: increasing efficiency with Power-Automate
• Becoming data literate: making calculations, using percentages, fractions and averages (L2) Becoming data literate: understanding data and how it is presented from pie-charts to bell curves (L2+)
• Becoming data literate: the fundamentals of how to present data for work or study (L2+)
• Level 2 Certificate in IT User Skills (ECDL Extra)
• Level 3 certificate in IT user skills (ECDL Advanced)
• Pathway to ECDL level 3

There also many English, maths and office skills courses you can do. Ask your tutor or contact universal.skills@citylit.ac.uk / 020 7492 2511 for more details.

We’re sorry. We don’t have a bio ready for the tutor of this class at the moment, but we’re working on it! Watch this space.