MS Office All Levels

Data Analysis Using MS Excel and Power BI - Beginner to Advanced (Hausa)

Data Analysis Using MS Excel and Power BI - Beginner to Advanced (Hausa)

star 5.0 (1 review)
group 114 students
video_library 35 lessons
language Hausa
Data Analysis Using MS Excel and Power BI - Beginner to Advanced (Hausa)
₦20000
Enroll Now shopping_cart

What You'll Learn

check_circle Fahimtar Excel daga farko: interface, worksheets, cells da data entry
check_circle Amfani da formulas kamar SUM, AVERAGE, IF, COUNT da sauran muhimman functions
check_circle Tsara da gyara data domin analysis
check_circle Sorting, filtering da formatting na data
check_circle Amfani da VLOOKUP da XLOOKUP wajen nemo da hada bayanai
check_circle Kirkirar charts da professional reports a Excel
check_circle Amfani da PivotTables wajen nazarin manyan datasets
check_circle Yin calculations na sales, expenses, profit da sauran business data
check_circle Yin data analysis daga real-life datasets
check_circle Gano patterns, trends da abubuwan da suke da muhimmanci a cikin data
check_circle Kirkirar practical Excel projects da za a iya amfani da su a real life
check_circle Fahimtar yadda ake tambayar data tambayoyi masu amfani domin samun insights
check_circle Fahimtar yadda ake import data zuwa Power BI
check_circle Kirkirar KPI cards domin nuna muhimman business metrics
check_circle Kirkirar bar da column charts domin kwatanta products, categories da locations
check_circle Amfani da line charts wajen gano trends da canje-canje a lokaci
check_circle Amfani da pie da donut charts wajen fahimtar percentage da contribution
check_circle Amfani da Power BI maps wajen nazarin sales da performance ta locations
check_circle Amfani da slicers da filters domin yin interactive analysis
check_circle Kirkirar cikakken interactive Power BI business dashboard
check_circle Fahimtar yadda ake karanta charts da dashboards domin gano useful insights
check_circle Juya raw data zuwa reports da za su taimaka wajen yanke business decisions
check_circle Yin practical projects da suka hada Excel da Power BI

Course Overview

Wannan cikakken Excel course ne da aka tsara musamman domin masu farawa (beginner) har zuwa advanced level, tare da koyarwa ta hanyar real-life examples da projects da zaka iya amfani da su a aiki, kasuwanci, ko makaranta. A cikin course, zaka koyi yadda ake amfani da Excel daga farko har zuwa advanced data analysis, da yadda ake tsara data, kirkirar reports, charts, PivotTables, formulas da sauran muhimman abubuwan da ake bukata wajen data analysis.

Course din yana dauke da 25 Excel lessons da 5 practical projects, sannan an kara masa cikakken 10-lesson Power BI chapter domin kara maka kwarewa wajen data analysis da dashboard creation.

A Power BI chapter din, zaka koyi yadda ake shigar da real-world data, kirkirar KPI cards, bar da column charts, line charts domin gano trends, pie da donut charts, amfani da maps wajen nazarin bayanan locations, slicers da filters, sannan ka gina complete interactive business dashboard daga data guda daya.

Ba wai kawai zaka koyi yadda ake kirkirar charts bane; zaka kuma koyi yadda ake nazarin bayanai, gano patterns, kwatanta results, da fitar da business insights daga data.

A karshen course din, zaka kasance kana da practical Excel da Power BI skills da zaka iya amfani da su wajen aiki, kasuwanci, makaranta da kuma real-life projects.

auto_awesome

EduCore AI Course Assistant

Ask any question about "Data Analysis Using MS Excel and Power BI - Beginner to Advanced (Hausa)" before or while studying.

OpenRouter AI
🤖
Hello! I'm your AI Tutor for Data Analysis Using MS Excel and Power BI - Beginner to Advanced (Hausa). Ask me anything about what you will learn, course topics, prerequisites, or practice exercises!

Course Curriculum

folder Module 1: Foundations
5 lessons
play_circle Lessn 0: Introduction and How to Download Microsoft Excel
— lock
play_circle Lesson1: Introduction & Interface
9m 04s lock
play_circle Lesson 2: Basic Data Entry
13m 07s lock
play_circle Lesson 3: Cell Formatting
8m 11s lock
play_circle Lesson 4: Basic Formulas
7m 37s lock
folder Module 2: Working with Data
4 lessons
play_circle Lesson 5: Cell References (Relative vs. Absolute)
11m 24s lock
play_circle Lesson 6: Essential Functions (IF, COUNT, COUNTA, ROUND)
22m 03s lock
play_circle Lesson 7: Sort & Filter
2m 50s lock
play_circle Lesson 8: Tables
2m 16s lock
folder Module 3: Analysis & Visualization
4 lessons
play_circle Lesson 9: Charts
6m 35s lock
play_circle Lesson 10: Conditional Formatting
19m 11s lock
play_circle Lesson 11: Data Validation
11m 51s lock
play_circle Lesson 12: PivotTables
13m 02s lock
folder Module 4: Advanced Tools
4 lessons
play_circle Lesson 13: Lookup Functions (VLOOKUP, XLOOKUP, INDEX/MATCH)
13m 36s lock
play_circle Lesson 14: Text Functions (LEFT, RIGHT, MID, CONCAT, TRIM)
19m 53s lock
play_circle Lesson 15: Date & Time Functions
7m 50s lock
play_circle Lesson 16: What-If Analysis (Goal Seek, Scenarios, Data Tables)
10m 59s lock
folder Module 5: Professional Applications
2 lessons
play_circle Lesson 17: Power Query Basics
6m 44s lock
play_circle Lesson 19: Macros (Intro)
8m 20s lock
folder POWER BI FOR DATA ANALYSIS & DASHBOARD CREATION
11 lessons
play_circle LESSON 1 — Getting Started with Power BI
10m 09s lock
play_circle LESSON 2 — Understanding the Dataset
11m 27s lock
play_circle LESSON 3 — KPI CARDS
13m 50s lock
play_circle LESSON 4 — BAR & COLUMN CHARTS
17m 30s lock
play_circle LESSON 5 — LINE CHARTS: ANALYZING TRENDS
12m 45s lock
play_circle LESSON 6 — PIE & DONUT CHARTS
11m 07s lock
play_circle LESSON 7 — MAP ANALYSIS
10m 11s lock
play_circle LESSON 8 — SLICERS & INTERACTIVE ANALYSIS
6m 55s lock
play_circle LESSON 9 — BUILD THE COMPLETE DASHBOARD
18m 04s lock
play_circle LESSON 10 — FINDING BUSINESS INSIGHTS
6m 28s lock
play_circle Files
— lock
folder PROJECTS
5 lessons
play_circle Project 1: Project Tracker
14m 32s lock
play_circle Project 2: Complete Report Sheet Creation
28m 34s lock
play_circle Project 3: Interactive Dashboard
15m 28s lock
play_circle Project 4: Invoice Generation and Printing
26m 54s lock
play_circle Project 5: Best Practices
49m 28s lock