Job-Ready Data Skills: Excel + Power BI

4–6 hrsTotal video

BeginnerLevel

Self-pacedFormat

EnglishLanguage

LifetimeAccess

A1 · Who it's for

Built for people with little to no data experience

If you can use a computer but have never built a report or dashboard professionally, this course takes you from raw data to a finished, interview-ready project — without wasting time on features you'll never use on the job.

B1 · What you'll be able to do

Outcomes

✓ Clean and standardize a messy real-world dataset in Excel
✓ Build PivotTable and slicer-driven dashboards
✓ Import and model data in Power BI using Power Query
✓ Write the 10–15 DAX functions that cover most real analyst work
✓ Present a finished capstone project in a job interview

C1 · Curriculum

4 modules, 1 capstone project

~5 hours of video · 4 mini-projects · 1 capstone

Data entry standards, formatting & validation
Core formulas: SUMIFS, COUNTIFS, VLOOKUP/XLOOKUP, nested IF
Mini project: clean a messy sales dataset

PivotTables and PivotCharts
Dashboards with slicers
Mini project: monthly sales report dashboard

Power Query — importing & cleaning data
Data modeling basics & relationships
Essential DAX functions

Building a portfolio project from raw data to dashboard
Resume & LinkedIn checklist for analyst roles
Common interview questions, answered using your own project

D1 · Reviews

What learners say

"I had never opened Excel professionally before this. Six weeks later I was building the report my manager used every Monday."

Amara K.

Lagos, Nigeria

✓ Verified learner

"The Power BI module alone was worth more than the whole price. I used the capstone project in my job interview."

Rohan S.

Pune, India