MS Excel for Data Analysis — Beginner to Advanced (Practical Course in Hausa)

What You'll Learn

Fahimtar Excel daga tushe (interface, sheets, data entry)

Amfani da formulas kamar SUM, AVERAGE, IF, COUNT

Tsara data da kyau (tables, formatting, sorting, filtering)

Kirkirar charts da reports masu kyau

Amfani da PivotTables domin analyzing data

Yin calculations na kasuwanci (profit, expenses, tracking sales)

Tsara student results da grading system

Amfani da lookup functions (VLOOKUP/XLOOKUP)

Sarrafa data cikin sauki da confidence

Gina real-life projects da zaka iya amfani da su kai tsaye

Requirements

Laptop ko computer (recommended)
Microsoft Excel (ko wani version mai kama da shi)
Basic knowledge na computer (kamar typing da mouse)
Sha’awar koyon sabuwar skill
Ba sai kana da experience da Excel ba — za mu fara daga farko.

Course Overview

Wannan cikakken Excel course ne da aka tsara musamman domin masu farawa (beginner) har zuwa advanced level, tare da real-life examples da projects da zaka iya amfani da su a aiki, kasuwanci, ko makaranta. A cikin wannan course, zaka koyi yadda ake amfani da Excel daga tushe har zuwa matakin da zaka iya analyzing data, kirkirar reports, da kuma yanke shawara cikin sauki. Course din yana dauke da lessons 25 (20 lessons + 5 projects), inda kowanne lesson yake da practical domin ka fahimta sosai ba tare da wahala ba. An yi amfani da examples na Najeriya (₦, kasuwanci, makarantu) domin ka ga yadda zaka yi amfani da Excel a rayuwa ta gaskiya. Idan kana son skill da zai taimaka maka samun aiki ko kara maka riba — wannan course naka ne.

Course Curriculum

Module 1: Foundations 5 lessons

▶️ Lessn 0: Introduction and How to Download Microsoft Excel

—

▶️ Lesson1: Introduction & Interface

9m 04s

▶️ Lesson 2: Basic Data Entry

13m 07s

▶️ Lesson 3: Cell Formatting

8m 11s

▶️ Lesson 4: Basic Formulas

7m 37s

Module Quiz

Module 2: Working with Data 4 lessons

▶️ Lesson 5: Cell References (Relative vs. Absolute)

11m 24s

▶️ Lesson 6: Essential Functions (IF, COUNT, COUNTA, ROUND)

22m 03s

▶️ Lesson 7: Sort & Filter

2m 50s

▶️ Lesson 8: Tables

2m 16s

Module Quiz

Module 3: Analysis & Visualization 4 lessons

▶️ Lesson 9: Charts

6m 35s

▶️ Lesson 10: Conditional Formatting

19m 11s

▶️ Lesson 11: Data Validation

11m 51s

▶️ Lesson 12: PivotTables

13m 02s

Module Quiz

Module 4: Advanced Tools 4 lessons

▶️ Lesson 13: Lookup Functions (VLOOKUP, XLOOKUP, INDEX/MATCH)

13m 36s

▶️ Lesson 14: Text Functions (LEFT, RIGHT, MID, CONCAT, TRIM)

19m 53s

▶️ Lesson 15: Date & Time Functions

7m 50s

▶️ Lesson 16: What-If Analysis (Goal Seek, Scenarios, Data Tables)

10m 59s

Module Quiz

Module 5: Professional Applications 2 lessons

▶️ Lesson 17: Power Query Basics

6m 44s

▶️ Lesson 19: Macros (Intro)

8m 20s

PROJECTS 5 lessons

▶️ Project 1: Project Tracker

14m 32s

▶️ Project 2: Complete Report Sheet Creation

28m 34s

▶️ Project 3: Interactive Dashboard

15m 28s

▶️ Project 4: Invoice Generation and Printing

26m 54s

▶️ Project 5: Best Practices

49m 28s

Student Reviews

5.0

★★★★★

Course Rating

5 Stars

100%

4 Stars

3 Stars

2 Stars

1 Star

Nura Karatu Jun 08, 2026

★ ★ ★ ★ ★

good

MS Excel for Data Analysis — Beginner to Advanced (Practical Course in Hausa)

₦5000 ₦10000 50% OFF

Sale ends in: Calculating...

6 modules

24 lessons

All Levels

Certificate on completion