Skip to content
Maarifa

From Excel to Dashboards

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

4.73 reviews6 learners

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 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

Dr Reem Al-Hinai
Dr Reem Al-Hinai

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

    شرح واضح جدًا ومرتب، وأكثر ما أعجبني التمارين القصيرة بعد كل درس. طبقت ما تعلمته في عملي من الأسبوع الأول.