Skip to main content
Certificate
Course completed by
James Oyelowo
Issued
November 2, 2026
Certificate ID
d5f62fb94c8ab2d4
Skills
Understand the complete data analysis workflow from raw data to actionable insights. Navigate and work confidently with Microsoft Excel and Google Sheets. Use essential spreadsheet formulas including SUM, AVERAGE, COUNT, IF, VLOOKUP, and XLOOKUP. Sort, filter, organise, and validate large datasets efficiently. Clean messy datasets by removing duplicates, correcting inconsistencies, and handling missing values. Create Pivot Tables to summarise and analyse large amounts of information. Build professional charts and interactive dashboards for data visualisation. Learn the fundamentals of SQL and understand how databases work. Write SQL queries using SELECT, WHERE, ORDER BY, GROUP BY, COUNT, and JOIN. Turn analytical findings into clear business reports and presentations. Apply analytical thinking to solve real-world business problems. Build a portfolio-ready capstone project using real datasets.
