Data Analysis with Excel

Welcome: what is data analysis?

Free preview
The video for this lesson is coming soon.

Welcome!

Data analysis means turning raw numbers into answers people can act on.

In this course you will follow the same four steps on every dataset:

  1. Get the data into Excel
  2. Clean it so it can be trusted
  3. Analyse it with formulas and PivotTables
  4. Present the answer in a chart or dashboard

Practice file: create a sheet with these columns and about 30 rows of example sales: Date, Region, Product, Salesperson, Quantity, Unit price, Payment method – or use your own company data.

Liked this lesson?

12 lessons · Data Analysis with Excel

See the full course