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

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.

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
•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 (telephone temporarily unavailable).

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 necessary in business, 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 (intermediate-level 2)
• Touch typing and keyboard skills
• Business Administration: getting ready for level 3 certificate in IT user skills - ICDL Advanced (intermediate)
• Business administration: how to organise and manage with OneNote, MS Outlook and OneDrive (intermediate)
• Award in Digital and IT Skills: word-processing, spreadsheets, presentations and databases (level 2)
• Level 3 certificate in IT user skills (ICDL Advanced)
• Digital skills for business: visualising data with Excel - from column charts to scatter plots (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:
• Becoming data literate: how to present data for work or study (level 2)
• Becoming data literate: understanding data and how it is presented from pie-charts to bell curves (level 2)
• Maths for business: the essential skills to run a company and make a profit (level 1-2)
• Maths for business with Excel: 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)

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