Skip to content
Sabaqاردو

Excel for Data Analytics (Luke Barousse)

By Luke Barousse

Course audio
Course audio: English
Level
Intermediate
Length
42 lessons · 11 hours

What you'll be able to do

  • Use lookup, statistical, text and date functions confidently
  • Build dashboards with charts, tables and PivotTables
  • Clean and combine data with Power Query
  • Model data with Power Pivot and DAX

About this course

Luke Barousse's full Excel course for data analysts (about 11 hours), split into 42 lessons at his chapters. It moves from worksheets and the ribbon through logical, math, statistical, lookup, text and date functions and array formulas, then charts, sparklines, tables and formatting, with a dashboard project. The second half covers PivotTables and PivotCharts, the Analysis ToolPak, Power Query and M, and Power Pivot with DAX, ending with a project shared on GitHub. Strong preparation for analyst jobs and freelance reporting work.

Before you start: Basic computer skills

Syllabus

42 lessons · 10:59:43 in total

  1. 1Welcome3:53
  2. 2What is Excel?3:26
  3. 3About Course4:00
  4. 4Excel Install11:23
  5. 5Worksheets16:33
  6. 6Workbooks12:51
  7. 7Ribbon14:33
  8. 8Formulas Intro11:29
  9. 9Function Intro11:06
  10. 10Logical Functions10:40
  11. 11Math Functions9:52
  12. 12Statistical Functions11:28
  13. 13Array Formulas20:14
  14. 14Lookup Function17:57
  15. 15Text Functions13:54
  16. 16Date and Time Functions8:14
  17. 17Charts Intro20:32
  18. 18Charts Advanced13:32
  19. 19Charts Statistics12:22
  20. 20Sparklines3:58
  21. 21Tables17:31
  22. 22Formatting16:32
  23. 23Collaboration14:30
  24. 24Project #1: Build Dashboard46:13
  25. 25Project #1: Share Projects7:03
  26. 26PivotTable Intro21:07
  27. 27PivotTable Advanced14:40
  28. 28PivotCharts10:10
  29. 29Analysis Add-ins19:17
  30. 30Data Tables9:06
Show all 42 lessons
  1. 31Analysis ToolPak14:58
  2. 32Power Query Intro20:22
  3. 33Power Query Editor29:47
  4. 34Advanced Transformations21:45
  5. 35Append vs Merge24:15
  6. 36M Language23:58
  7. 37Power Pivot Intro25:50
  8. 38Power Pivot Window19:17
  9. 39DAX Intro21:16
  10. 40DAX Advanced18:06
  11. 41Project #2: Share w/ Git & GitHub17:33
  12. 42Project #2: Document w/ README.md14:30

What to take next

Related courses

Videos by Luke Barousse, played from their official YouTube channel. Subscribe on YouTube

Official upload by the teacher or institution on their own channel, shown with YouTube's embedded player.

Lessons last checked Oct 2026. Course summary and lesson structure by Sabaq.

Report a problem or a rights request