DataBeginnerEnglish3 modules · 7 lessons · about 7.4 hours

Data Analysis with Excel and SQL

Go from a messy spreadsheet to clear answers: clean data, write lookups and SUMIFS, build pivot tables and charts, then query databases with SQL.

You will be able to

Clean and structure raw data in Excel
Answer business questions with SUMIFS, COUNTIFS and XLOOKUP
Build pivot tables and choose an honest chart for the message
Write SQL queries that filter, group and aggregate data
Combine tables with INNER and LEFT JOIN

Before you start

Comfort with basic arithmetic and percentages. No programming needed.

Who it's for: students from any engineering branch, BBA/MBA students and anyone preparing for analyst, operations or consulting roles. No coding background needed.

What you'll be able to do:

Clean a raw dataset and turn it into a proper Excel Table
Use SUMIFS, COUNTIFS and XLOOKUP to answer business questions
Summarise thousands of rows with a pivot table and pick the right chart
Write SQL queries with WHERE, GROUP BY, HAVING and JOIN

You'll need Excel (desktop or the free web version) or Google Sheets. For SQL, any free online SQL editor or SQLite works.

This course is free. Your progress is private to your account. My learning shows every course you’ve started.