All courses

Digital skills · Intermediate

Data analysis (Excel, SQL, Power BI)

Turn data into decisions — a high-paying remote skill.

6 lessons3.3 hoursCertificate availableUHF Learning Team, Data analyst
Sign in to start the course
  1. Lesson 1 · 40 min

    Step 1: Spreadsheets

    • Sorting, filters, formulas (SUM, IF, VLOOKUP/XLOOKUP) and pivot tables.
  2. Lesson 2 · 30 min

    Step 2: Cleaning data

    • Remove duplicates, fix formats, handle blanks.
  3. Lesson 3 · 45 min

    Step 3: SQL basics

    • SELECT, WHERE, GROUP BY and JOIN.
  4. Lesson 4 · 40 min

    Step 4: Dashboards

    • Build charts in Power BI, Looker Studio or Excel.
  5. Lesson 5 · 20 min

    Step 5: Telling the story

    • Lead with the insight, then show the chart.
  6. Lesson 6 · 20 min

    Step 6: Getting paid for this skill

    • Build a portfolio of 3 sample projects, even unpaid ones.
    • Create profiles on Upwork, Fiverr, LinkedIn and local WhatsApp business groups.
    • Start with small fixed-price jobs, collect reviews, then raise your price.
    • Receive payments safely through Payoneer, Grey, bank transfer or the platform's own escrow.

Assignment

Analyse a public dataset and build a one-page dashboard.

Free learning resources

Final quiz

Sign in to take the quiz.

Certificate: complete every lesson and pass the quiz (70%).