Skip to content
1:10OnlineEnglish

Excel Power Query & Power Pivot – Intensive Course

A practical intensive course in Excel Power Query & Power Pivot for office professionals, analysts and students, with real workplace examples and live practice in a small online group of up to 10 learners.

Teacher & owner Geethu Sha

8 sessions · 1 hour per session

About this QSquad

This intensive course helps office professionals, analysts and students build practical skills in Excel Power Query & Power Pivot that they can use at work straight away. Classes are live, online and interactive, in a small group of up to 10 learners, with real examples, exercises and time for questions. Session plan (8 sessions, 1 hour each, two sessions each week): Session 1 – Importing data Session 2 – Cleaning data with Power Query Session 3 – Merging and appending Session 4 – The data model Session 5 – DAX basics Session 6 – Refreshable reports Session 7 – Case study: real workplace scenarios Session 8 – Mini project How the classes work: • Clear explanations with real workplace examples • Hands-on exercises in every session • Templates, checklists and practical tips you can reuse • Personal feedback in a small group

Teacher

Geethu Sha

What you will learn

  • Understand and apply: importing data
  • Understand and apply: cleaning data with Power Query
  • Understand and apply: merging and appending
  • Understand and apply: the data model
  • Understand and apply: dAX basics

Who this QSquad is for

  • Office professionals, analysts and students
  • Professionals who want practical, job-ready skills
  • Career changers and fresh graduates

Entry requirements

  • Laptop with a stable internet connection
  • Working microphone and camera
  • Notebook and pen
  • Access to the software used in class (free trials are fine)

Prerequisites

  • Open to beginners and those with some experience

Sessions

Starts 2026-12-24 — 2027-01-17

Times shown in UTC
  1. Importing dataImporting data: key ideas explained step by step, with worked examples and guided practice.
  2. Cleaning data with Power QueryCleaning data with Power Query: key ideas explained step by step, with worked examples and guided practice.
  3. Merging and appendingMerging and appending: key ideas explained step by step, with worked examples and guided practice.
  4. The data modelThe data model: key ideas explained step by step, with worked examples and guided practice.
  5. DAX basicsDAX basics: key ideas explained step by step, with worked examples and guided practice.
  6. Refreshable reportsRefreshable reports: key ideas explained step by step, with worked examples and guided practice.
  7. Case study: real workplace scenariosCase study: real workplace scenarios: key ideas explained step by step, with worked examples and guided practice.
  8. Mini projectMini project: key ideas explained step by step, with worked examples and guided practice.

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. 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 8 sessions, 800 Creds in all, shared equally by the students enrolled when joining closes: from 80 Creds each if every seat is taken, to at most 160 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 × 8 sessions, shared equally by the students enrolled at the cutoff.
800 Creds
Your estimated tuitionYour estimated tuitionIf it runs with the 0 enrolled now (or the minimum, if fewer).
160 Creds
Most you can payMost you can payThe share at the minimum enrolment of 5; fewer cancels it and charges nothing.
160 Creds

Joining closes inJoining closes inJoining and leaving are unavailable after this.33d 1h 12m

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
5160 Creds
6134 Creds
7115 Creds
8100 Creds
989 Creds
1080 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.