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

About this course

The course develops Excel skills for analysing and presenting workplace data. Learners work with pivot tables, multi-sheet workbooks and advanced functions such as VLOOKUP, COUNTIF and SUMIF to examine larger datasets. It also covers conditional formatting, data validation and the use of AI tools for cleaning data, identifying trends, suggesting charts and summarising findings. Learners explore how to import CSV data and present analysis through charts and dashboards.

What you'll learn

• Create pivot tables to summarise and analyse larger datasets
• Apply advanced functions including VLOOKUP, COUNTIF and SUMIF
• Use conditional formatting and data validation to improve spreadsheet reliability
• Use AI tools to clean data, identify trends and generate analytical summaries
• Present findings with charts, dashboards and data imported from CSV files

Is this course right for you?

The course is intended for improver-level learners developing beyond fundamental Excel techniques. It focuses on applying spreadsheet skills to workplace data analysis, reporting and decision-making.