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

About this course

The course focuses on using Excel for workplace tasks involving budgets, reports, records and other data. Participants will create structured spreadsheets, apply formulas and functions, and organise larger datasets using sorting and filtering. It also covers presenting information through charts and graphs, alongside using Microsoft Copilot or a similar AI assistant for tasks such as drafting text, summarising documents or suggesting spreadsheet formulas.

What you'll learn

• Construct structured spreadsheets for workplace tasks such as budgets, attendance records and stock inventories.
• Apply formulas and functions to automate calculations, including totals, averages and percentage differences.
• Sort and filter larger datasets to locate and organise relevant information.
• Create charts and graphs to communicate data clearly in reports.
• Use Microsoft Copilot or a similar AI assistant to support workplace tasks and spreadsheet problem-solving.

Is this course right for you?

The course is intended for learners at an improver level who are already in work and want to use Excel for numbers, budgets, reports or other data-related tasks. The level label suggests it is aimed at learners developing beyond fundamental Excel skills, although the source does not specify a formal experience requirement.

• Relevant to workplace tasks involving budgets, reports, records or data.
• Includes examples drawn from project budgeting, staff attendance, stock control and sales analysis.
• Covers both conventional Excel methods and AI-assisted office tasks.