This course is FREE if a) Your pay is less than £25,300.60 a year OR b) You are on universal credit or JSA or ESA  Find out more >

This course is FREE for Londoners who are on a Low-Income or on Active Benefits or Other-Benefits or if you do not already have a full level3 qualification. Find out more about free courses for jobs >

Digital skills for business: visualising data with Excel - from column charts to scatter plots (intermediate)

Course Dates: 07/03/24 - 11/04/24
Time: 10:00 - 13:00
Location: Hybrid (choose either online or in-person)
Data visualization in Excel is an essential skill, used by business, researchers, statisticians, journalists and many more to make information interesting and accessible. On this course you will focus on the key ways of presenting and interpreting data so you can describe patterns, trends and relationships as well find anomalies and inconsistencies. You will work on when, why and how to use the different visualisations including bar charts, line graphs, scatter plots, pie charts and tables. You will also examine different ways of formatting the data. By the end of the course you can be confident you can present and visualise data in a way that enhances what you want to say and engages others.
This course is FREE if you are employed and on a low wage or you are claiming benefits. For more information Click here
This course will be delivered online or in person. See the ‘What is the course about?’ section in course details for more information.
Download
Book your place
In stock
SKU
218260
Full fee £179.00 Senior fee £143.00 Concession £90.00

Digital skills for business: visualising data with Excel - from column charts to scatter plots (intermediate)
  • Course Code: CEX13A
  • Dates: 07/03/24 - 11/04/24
  • Time: 10:00 - 13:00
  • Taught: Thu, Daytime
  • Duration: 5 sessions (over 6 weeks)
  • Location: Hybrid (choose either online or in-person)

Course Code: CEX13A

Thu, day, 07 Mar - 11 Apr '24

Duration: 5 sessions (over 6 weeks)

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 for business purposes in a visually appealing and appropriate manner. You will learn how to approach different datasets and choose the most appropriate means of visualising it. You will work with bar charts, line graphs, scatter plots, pie charts and tables and on tasks which require you to identify trends, patterns and relationships. You to practise converting your data into appropriate visualisations, and on effective formatting and labelling.

You can choose to attend this course either live online or in person.
- 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?

• the importance of data analysis in the workplace
•recognising the purpose and function of different data in different contexts
•identifying the different types of visualisations - bar charts, line graphs, scatter plots, pie charts and tables
•choosing the right type of visualisation and converting data into visualisations
•labelling and formatting the key features of well-designed and well-presented data so it is easy to identify and read
•calculating trends, patterns and relationships across data.

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

•identify and analyse the importance of data analysis in the workplace
•recognise the purpose and function of different data in different contexts
•identify the different types of visualisations - bar charts, line graphs, scatter plots, pie charts and tables
•choose the right types of visualisation and convert data into visualisations
•label and format the key features of well-designed and well-presented data so it is easy to identify and read
•calculate trends, patterns and relationships across data.

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, complete these courses:
• Digital skills for the workplace: using Excel (foundation)
• 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).

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:
• Business administration: using Word, Excel, PowerPoint and Access in the office (intermediate)
• Award in Digital and IT Skills: word-processing, spreadsheets, presentations and databases (level 2)
• 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: how use Teams and SharePoint for collaboration (intermediate)
• Digital skills for the workplace: creating newsletters, reports and tables with Word (intermediate)
• Digital skills for business: how to present and communicate data integrating Word, PowerPoint and Excel - a project-based approach (advanced)
• Digital skills for business: presenting and managing professional-looking documents with Word and Excel - from reports to newsletters (intermediate)

You can also do classes in the maths and English areas. These include:
• 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)
• Business administration with digital skills: communication skills in a business environment (advanced level 2)
• Maths for business: the essential skills to run a company and make a profit (level 1-2)

For more information, talk with your tutor or contact universal.skills@citylit.ac.uk / 020 4582 0423.

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.