Digital skills for the workplace: analysing, handling and presenting data with Excel (intermediate)

Course Dates: 09/11/22 - 07/12/22
Time: 18:00 - 21:00
Location: Online
Knowing how to handle large amounts of data, analyse it effectively and then present the findings are essential workplace skills. A recent study found 88% of employers want employees with data analysis skills. This intermediate Excel course will help you develop these skills by focusing on common workplace tasks and problems that require some of the more complex Excel functions. You will focus on how to handle large amounts of data and convert it into usable, valuable information. You will develop your skills so you can work with different formulae and functions to create for example automated budgets that take into account variable conditions. You will learn how to link data across spreadsheets and also calculate and present trends. You will work with pivot tables and learn why you use them. By the end of the course you will be confident you have the skills and insight to handle, analyse and present data for a range of circumstances.
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 want to get a job or progress into a better job and 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
195970
Full fee £179.00 Senior fee £143.00 Concession £90.00

Course Code: CEX01

Available start dates 

Wed, eve, 09 Nov - 07 Dec '22

Duration: 5 sessions (over 5 weeks)

Or call to enrol:020 7831 7831

Lines open Monday-Friday 12:00-18:00

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 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 is best (e.g. a PC/laptop/iMac/MacBook), or a tablet/iPad/smart phone/iPhone if you don't have a computer.
- Earphones/headphones/speakers.
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 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 workplace: using Excel (foundation)
• Essential digital skills for the workplace: Word, Excel and PowerPoint (foundation-level 1)
• Workplace skills: how to be organised, focused and efficient using MS Outlook and OneDrive (intermediate)
• Digital skills for the workplace: how to present, organise and communicate with Word (intermediate)
• Digital skills for the workplace: creating newsletters, reports and tables with Word (intermediate)
• Digital skills for the workplace: how to integrate Word, Excel and PowerPoint to organise, present and communicate data (advanced)
• Business skills: how to collaborate using OneDrive and SharePoint (intermediate)
• Business skills: how to collaborate with Microsoft Teams (intermediate)
• Business Administration: Word, Excel, PowerPoint and Access (intermediate-level 2)
• Business administration: ICT skills for business (advanced)
• Business administration: how to organise and manage with OneNote, MS Outlook and OneDrive (intermediate)
• Getting job ready: identifying the most in-demand work skills and how you can develop them

We have many maths, English, office, employability and communication skills courses. Ask your tutor or contact universal.skills@citylit.ac.uk / 020 7492 2511 for more information. These courses include:
• Business Administration (with digital skills): English communication skills in a business environment (level 2)
• Professional communication skills: how to make your writing clear, concise and organised (level 2)
• Professional communication skills: reading, analysing, and comparing data and text (level 2)
• Professional communication skills: effective verbal communication in the workplace (level 2)
• Professional communication skills: effective written communication in the workplace (level 2).

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.