Y9065 - Excel for work: spreadsheets, charts and data part 2 (level 2)

Header
Start Date: 23/11/2026      End Date: 01/02/2027        Start Time: 18:00      End Time: 20:15        Hours per Week: 2.25      No of Weeks: 9
Fees:      £35.00 (tuition)     £259.00 (overseas)     £10.00 (concessionary)
Tutor: Jagdeep Chatha        No of Places: 11
Idea Store Whitechapel

Course Overview

Course Overview
In this course, you'll tackle the advanced Excel skills that make you genuinely valuable in the workplace.
You'll learn to work with pivot tables, complex functions, and multi-sheet workbooks. You'll explore how to use Excel alongside AI tools to analyse trends, build dashboards, and present data in ways that help people make decisions. These are the skills that get you noticed at work - and they're increasingly the skills that separate someone stuck in the same role from someone who gets promoted.

What will you learn and be able to do?

What will you learn and be able to do?
* Use pivot tables to summarise and analyse large data sets so you can answer questions about your data in seconds instead of hours - such as taking a year's worth of sales transactions and instantly seeing totals by product, region, or month without manually adding anything up.
* Apply advanced functions to solve real problems so your spreadsheets can handle genuinely complex work - such as VLOOKUP to pull details from a database, COUNTIF to count orders from a particular area, or SUMIF to total only expenses in a specific category.
* Use AI tools to work with data more effectively so you can get insights faster and with more confidence - such as cleaning up messy data, spotting trends you hadn't noticed, getting chart recommendations, or generating summaries of what a data set is telling you.
* Use conditional formatting and data validation to keep spreadsheets reliable so the data stays clean and the key information stands out - such as highlighting overdue tasks in red automatically, or setting up dropdown menus so people can only choose from approved options.
* Present your data analysis clearly to others so your Excel skills translate into real influence at work - such as walking your team through a dashboard, explaining what the charts show and what decisions the data supports, or importing data from external CSV files to build a complete picture.
* empty
* empty
* empty
* empty
* empty

Entry requirements

Entry requirements
This course is for learners who are already confident using a computer and have some experience with spreadsheets - for example, from our Word, Excel and PowerPoint for work course, or from using Excel at work.
You should be comfortable with entering data, formatting cells, and using simple formulas.
This is an evening course designed for people who are currently employed, self-employed or looking to improve their skills.
Prosp User 8

Equipment required

Equipment required
Please bring to every lesson:
A folder
Pens and pencils
Lined A4 paper
A smartphone (if you have one)
A reusable water bottle
You will also need a personal Gmail account to access Google Classroom. If you don't have one, your tutor will help you set one up.
Prosp User 9

How will you know you are making progress?

How will you know you are making progress?
Your tutor will give you regular feedback on your work. You'll complete a portfolio of advanced tasks demonstrating your skills across all four Office applications.
You need to attend at least 80% of your classes.
Prosp User 12
Prosp User 11

Progress opportunities - your next steps

Progress opportunities - your next steps
Other courses you can do after this course include:
Excel for work: spreadsheets, charts and data (level 2) - go deeper into data analysis
Start or grow your business with digital marketing (level 1–2) - evening course
Write and design the student newsletter - develop communication and design skills
Get ready for work in the NHS and council: admin and digital skills
Please ask your tutor for more information or contact us at: digital.ideastore@towerhamlets.gov.uk
Prosp User 10

Other info

Other info
One of our aims is to help you make progress in work or future studies. We also want to help you participate in your communities and become an active citizen. In our classes, you will develop important skills that employers value and that will help you in everyday life. Here’s what you will learn:
Communication Skills: You will learn to speak and write more clearly and confidently. This includes practising conversations for work, writing emails, and filling out forms.
Decision-Making: You will learn how to make good choices by evaluating different options and thinking critically about situations.
Teamwork: You will learn how to work well with others.
Problem-Solving: You will develop the ability to identify problems and find effective solutions, useful in both work and daily life.
Time Management: You will practice managing your time effectively, including setting goals and meeting deadlines.
By improving these skills, you will increase your chances of finding a job, advancing in your career, and becoming an active member of your community.
Prosp User 13

Extra Support

Extra Support
We can help you if you tell us you have a learning difficulty, disability or other support needs. Please tell us when you enrol or in your first class.
Prosp User 14