From Excel to Dashboards
Clean your data, summarise it with pivot tables and turn it into a dashboard your manager reads in a minute.

Taught by Dr Reem Al-Hinai
What you will learn
- Clean data and make formats consistent
- Use functions like XLOOKUP and SUMIFS with confidence
- Summarise data with pivot tables
- Design a simple, honest dashboard
About this course
Most data work in companies starts and ends in Excel. This course takes you from a messy sheet to a clear dashboard, with habits that protect you from the usual mistakes.
Before you start
- Excel 2021 or Microsoft 365
Syllabus
3 sections · 6 lessons · 1 h 4 min
Clean data2 lessons · 20 min
- The right table shapeFree preview9 min
- Cleaning text and dates11 min
The functions you need2 lessons · 20 min
- XLOOKUP10 min
- SUMIFS and COUNTIFS10 min
Summarise and present2 lessons · 24 min
- Pivot tables12 min
- An honest dashboard12 min
- Excel quiz4 questions
Your instructor

Data scientist and analytics lecturer · 3 courses
Reem holds a PhD in applied statistics and has led analytics teams in banking and healthcare. She loves turning complex numbers into clear stories, and teaching analysts when to doubt their own results.
Questions
Does it work in Google Sheets?
Mostly yes, and we point out the differences where they exist.
How long do I keep access?
The course stays in your account with no time limit, including any updates to its lessons.
How do I get the certificate?
When you finish every lesson and pass the required quizzes, issue it from the course page. It carries a code anyone can verify.
Can I get a refund?
Yes, within 14 days of purchase if you have completed less than 20% of the lessons. Contact us from the messages page.
Reviews
4.7
3 reviews
- 5 ★2
- 4 ★1
- 3 ★0
- 2 ★0
- 1 ★0
- ححمد السعدي14 Nov 2026
محتوى ممتاز، وأتمنى لو كانت هناك تمارين إضافية في القسم الأخير.
- LLayla Mansour26 Oct 2026
The final project brought everything together. I felt I really understood instead of memorising.
- ووليد الحوسني26 Oct 2026
شرح واضح جدًا ومرتب، وأكثر ما أعجبني التمارين القصيرة بعد كل درس. طبقت ما تعلمته في عملي من الأسبوع الأول.