Skip to content
1:10OnlineUrdu

Excel to Power BI in Urdu: Data Analysis & Dashboards for Jobs and Freelancing

Learn Excel from basics to advanced and build professional Power BI dashboards, explained step by step in simple Urdu. Perfect for students, job seekers and office workers who want a skill employers actively look for.

Teacher & owner AMNA LATIF

12 sessions · 1 hour 30 minutes per session

About this QSquad

Excel and Power BI are among the most demanded skills in offices, banks, companies and freelancing. This QSquad takes you from Excel basics to building interactive Power BI dashboards, with everything explained in Urdu and practised on real-world data. What you will learn: Excel formulas and functions used daily in offices (IF, SUMIFS, VLOOKUP, XLOOKUP and more) Cleaning and organising messy data quickly Pivot tables, charts and an Excel dashboard Power BI: importing data, Power Query, data modelling and basic DAX Building an interactive Power BI dashboard from scratch How the class works: 12 live sessions, three times a week, each with hands-on practice using sample business data (sales, HR and finance). Practice files are shared in every class. We finish with a final project you can add to your CV, LinkedIn or freelancing profile. Taught by a Computer Science graduate who explains every concept step by step in simple Urdu.

Teacher

AMNA LATIF

What you will learn

  • Use Excel formulas and functions confidently for office work
  • Clean, sort, filter and organise large data sets
  • Use lookup functions: VLOOKUP, XLOOKUP and INDEX-MATCH
  • Summarise data with pivot tables and charts
  • Build a professional Excel dashboard
  • Import, clean and model data in Power BI
  • Create an interactive Power BI dashboard for your portfolio

Who this QSquad is for

  • Job seekers who want a skill employers ask for
  • BBA, B.Com, accounting, finance and CS students
  • Office workers who use Excel and want to work faster
  • Freelancers who want to offer data analysis and dashboard services
  • Beginners who learn better when concepts are explained in Urdu

Entry requirements

  • A Windows laptop or computer with internet access
  • Microsoft Excel 2016 or newer
  • Power BI Desktop

Prerequisites

  • No prior Excel experience needed
  • Basic ability to use a computer and the internet

Sessions

Starts 2026-12-02 — 2026-12-28

Times shown in UTC
  1. Excel EssentialsInterface, data entry, formatting, and shortcuts that save time
  2. Formulas & Cell ReferencesBuilding formulas, relative vs absolute references ($)
  3. Everyday FunctionsSUM, AVERAGE, IF, COUNTIF, SUMIF, SUMIFS with office examples
  4. Lookup FunctionsVLOOKUP, XLOOKUP and INDEX-MATCH to find data across sheets
  5. Cleaning Messy DataText functions, removing duplicates, Text to Columns, data validation
  6. Organising DataExcel Tables, sorting, filtering and conditional formatting
  7. Pivot TablesSummarising large data sets in seconds
  8. Charts & Excel DashboardChoosing the right chart and building a one-page dashboard
  9. Introduction to Power BIInstalling Power BI Desktop, loading data, the Power BI interface
  10. Power QueryCleaning and transforming data in Power BI
  11. Data Modelling & DAX BasicsRelationships between tables, measures with SUM, CALCULATE, and more
  12. Final Project: Interactive DashboardBuild a complete sales dashboard, plus tips for your CV, LinkedIn and freelancing

Members & seat availabilityMembers & seat availabilitySigned in, you see who is in this QSquad: its teacher and members see everybody in it, and anybody else sees only adults with a public profile. Tap a face to view their profile or send a message.


0 / 5 minimum reached0%

It runs only if the minimum is reached when joining closes. If not, it is cancelled, nothing is charged and every hold is released.

Policies

Joining and leaving close exactly 24 hours before the scheduled start of the first session. At this cutoff, the enrolled student count is final. If minimum enrolment is reached, the total tuition value — the value per session multiplied by the number of sessions — is divided equally among enrolled students and deducted from their Q-Wallets, together with applicable additional fees, tax and optional donations. If minimum enrolment is not reached, the QSquad is cancelled automatically and all reserved funds are released.

Students who leave before the cutoff receive a full release of their reserved funds. If the QSquad is cancelled because minimum enrolment is not reached, no payment is collected. After the cutoff, students cannot leave through the normal enrolment process. Teacher or platform cancellations trigger refunds for undelivered sessions and any refundable associated fees.

Common questions

How long is each session?
1 hour 30 minutes. Every session in this QSquad has that length, set when it was created, and it does not change once anyone has joined.
What will I pay in total?
The whole group pays 100 Creds per session across 12 sessions, 1,200 Creds in all, shared equally by the students enrolled when joining closes: from 120 Creds each if every seat is taken, to at most 240 Creds each at the minimum of 5. Your share can only go down as more people join. Any tax and optional extras are shown before you confirm.
What happens if the minimum enrolment is not reached?
This QSquad needs 5 students. If the minimum is not reached when joining closes, the QSquad is cancelled, nothing is charged and your hold is released.
Can more students be added later?
No. Capacity is fixed at 10 and does not change once anyone has joined.

Capacity, schedule & pricing

QSquad value per session
100 Creds
Total QSquad valueTotal QSquad valueValue per session × 12 sessions, shared equally by the students enrolled at the cutoff.
1,200 Creds
Your estimated tuitionYour estimated tuitionIf it runs with the 0 enrolled now (or the minimum, if fewer).
240 Creds
Most you can payMost you can payThe share at the minimum enrolment of 5; fewer cancels it and charges nothing.
240 Creds

Joining closes inJoining closes inJoining and leaving are unavailable after this.13d 1h 44m

Tuition by number of students

StudentsTuition each
1Does not meet minimum enrolment
2Does not meet minimum enrolment
3Does not meet minimum enrolment
4Does not meet minimum enrolment
5240 Creds
6200 Creds
7172 Creds
8150 Creds
9134 Creds
10120 Creds

Plus 5% tax on tuition and fees, added when you join.

0 / 10 joined10 seats available
0 / 5 minimum reached0%

It runs only if the minimum is reached when joining closes. If not, it is cancelled, nothing is charged and every hold is released.

Join QSquad

Your seat is held once you join. If the minimum is not reached when joining closes, the QSquad is cancelled, nothing is charged and your hold is released.