Skip to content
All public programs
Enrolling now Excel · 16 hours Live online · Zoom or Microsoft Teams Urdu & English (bilingual), mostly in Urdu Beginner to intermediate

Data Analytics Specialist: Microsoft Excel

A 16-hour live online program on business Excel: advanced formulas and lookups, pivot tables, dynamic charts and interactive dashboards, with real-world examples. The first part of the Certified Data Analytics Specialist program.

Fee per participant

PKR 20,000 + taxes PKR 25,000

Starts in

– Days
– Hours
– Mins
– Secs
  • When6–22 December 2026
  • Duration16 hours · 8 live sessions × 2 hours (Tue & Thu 7–9 pm, Sun 11 am – 1 pm), 6 – 22 Dec
  • FormatLive online
  • WhereZoom or Microsoft Teams
  • LanguageUrdu & English (bilingual), mostly in Urdu
  • Register by6 December 2026

Live session schedule

All times are Pakistan time (PKT, UTC+5).

🗣️ Language: Urdu & English (bilingual), mostly in Urdu

  • 6Dec Excel 16 December 2026 · 11:00 am – 1:00 pm PKT
  • 8Dec Excel 28 December 2026 · 7:00 – 9:00 pm PKT
  • 10Dec Excel 310 December 2026 · 7:00 – 9:00 pm PKT
  • 13Dec Excel 413 December 2026 · 11:00 am – 1:00 pm PKT
  • 15Dec Excel 515 December 2026 · 7:00 – 9:00 pm PKT
  • 17Dec Excel 617 December 2026 · 7:00 – 9:00 pm PKT
  • 20Dec Excel 720 December 2026 · 11:00 am – 1:00 pm PKT
  • 22Dec Excel 822 December 2026 · 7:00 – 9:00 pm PKT

Who should attend

  • Anyone looking for a hands-on, project-based data analytics course on Excel and Power BI Desktop
  • Data analysts and Excel users who want advanced data modeling, dashboard design and BI skills
  • Aspiring data professionals who want to master the leading business intelligence tool
  • Students who want an engaging, highly interactive approach to training
  • Anyone looking to pursue a career in data analysis or business intelligence

What you will be able to do

  • Work faster in Excel with practical tips and tricks
  • Use advanced formulas and lookups (XLOOKUP, INDEX & MATCH, SUMIFS) with confidence
  • Analyze data with pivot tables and slicers
  • Design dynamic charts and interactive dashboards

Program outline

01 Excel Module 1: Business Excel with real-world examples and painful areas +
  • Tips and tricks to speed up your work
  • Advanced formulas & functions: date, text and logical functions (IF, AND, OR)
  • SUMIFS, COUNTIFS
  • VLOOKUP, HLOOKUP, XLOOKUP
  • CHOOSE, INDEX & MATCH, IFERROR
02 Excel Module 2: Analyzing and designing reports +
  • Conditional formatting
  • Pivot tables with slicers
  • Dynamic charts using form controls
  • Interactive dashboard using pivot tables

What's included

  • 16 hours of live, hands-on training
  • Real-world business examples
  • Build an interactive dashboard
  • Session recordings on our Learning Management System (LMS), available for 6 months after the program ends
  • E-certificate of completion from Innovinc AI

Before you join

You should know file & folder management, basic Excel formulas & functions, formatting worksheets, and sorting and filtering data in Excel. Join from a laptop with Microsoft Excel installed.

Data Analytics Specialist: Microsoft Excel flyer
Program flyer Download full brochure (PDF) Share on WhatsApp
Jahangir Sachwani

Your trainer

Jahangir Sachwani

Founder & CEO, Innovinc AI · Lead Trainer

27+ years in training and analytics · 500,000+ professionals trained · Lead Trainer for Excel & Power BI at LUMS · Microsoft certified.

Frequently asked questions

Can I join only the Excel or only the Power BI part?+

Yes. You can join the full package (40 hours, PKR 55,000, early bird PKR 40,000 until 26 Nov), Microsoft Excel only (16 hours, 6–22 Dec, PKR 25,000, early bird PKR 20,000 until 26 Nov) or Microsoft Power BI only (24 hours, 29 Dec – 24 Jan, PKR 30,000, early bird PKR 25,000 until 4 Dec). International fees: USD 199 (early 149), USD 99 (early 79) and USD 119 (early 99). Each option has its own page under Public Programs, and the full package can be paid in 2 instalments in PKR at no extra charge (instalments are not available for Excel only or Power BI only). The full package is the best value.

What language is the program taught in?+

The program is bilingual, delivered mostly in Urdu with English, so concepts are easy to follow. Course materials, the software and technical terms are in English.

Is there a group discount?+

Yes: 5 + 1 free and 10 + 2 free. Enrol your group together and the free seats are applied automatically.

How do I pay?+

Fill in the form to reserve your seat. You will see the payment details straight away and receive them by email. In Pakistan you can pay by bank transfer or Easypaisa; international participants pay in USD through Payoneer. Your seat is held for 48 hours while you pay.

When is my seat confirmed?+

As soon as we receive your payment, we email your enrolment confirmation with a receipt, a calendar file for all sessions and joining instructions.

What time zone are the sessions in?+

All times are Pakistan time (PKT, UTC+5). International participants are welcome: this page shows the session times in your own time zone, and you can choose your country from the list next to the schedule.

Can my company pay and get an invoice?+

Yes. Tick "My company needs an invoice" and add the company details. You can also enrol several colleagues together: for every 5 paid seats, one more is free (5 + 1).

What if I miss a session?+

Every live session is recorded. If you miss a class, you can watch the recording on our Learning Management System (LMS) and catch up before the next session. You can also send your questions to the trainer. Recordings stay available for 6 months after the program ends.

What is the refund policy?+

See our refund policy page for full details. In short, you can get a refund or move to the next batch if you cancel in good time. Read the refund policy.

Can this program be run for our team only?+

Yes. Any program can be delivered privately for your organization, online or onsite, with examples from your own work.

Enrol now

Reserve your seat

Your seat is held while you pay. You'll get the payment details on the next screen and by email.

Pay in
Payment method

Card payments, JazzCash and instant Easypaisa checkout are coming soon.

1 × fee
Total

Fees are + taxes. Any applicable taxes are shown on your invoice.

We'll only use your details for this program. See our privacy policy.

Other public programs

Enrolling now Full package · 40 hours Live online · Zoom or Microsoft Teams

Certified Data Analytics Specialist: Microsoft Excel & Power BI

6 Dec – 24 Jan 2027

A 40-hour live online program to turn raw data into actionable insights: advanced Excel for analysis and dashboards, then Power BI Desktop end to end, from shaping data and building data models to DAX and interactive reports.

  • 40 hours · 20 live sessions × 2 hours (Tue & Thu 7–9 pm, Sun 11 am – 1 pm): Excel 16 hours, Power BI 24 hours
  • Urdu & English (bilingual), mostly in Urdu
  • Beginner to intermediate

Fee per participant

PKR 40,000 + taxes PKR 55,000

Enrolling now Certification program · 48 hours Live online · Zoom or Microsoft Teams

Advanced Power BI, Fabric & Generative AI

27 Dec – 11 Apr 2027

A 48-hour advanced live online certification program for professionals: Advanced Power BI, Power BI Service, Microsoft Fabric and Generative AI, to build modern, AI-powered analytics solutions for real business impact.

  • 48 hours · Sundays only, 4 hours per session, 2:00 – 6:00 pm Pakistan time
  • Urdu & English (bilingual), mostly in Urdu
  • Advanced

Fee per participant

PKR 35,000 + taxes PKR 40,000

Enrolling now 6-month program Live online · Zoom or Microsoft Teams

Certified BI AI Professional

27 Dec – 18 Jul 2027

A 6-month advanced live online program to master Business Intelligence, analytics and Generative AI: Power BI Advanced and Power BI Service, Microsoft Fabric, SQL, Python and PL-300 exam preparation, with Generative AI built into every module.

  • 6 months · Sundays only, 4 hours per session, 2:00 – 6:00 pm Pakistan time
  • Urdu & English (bilingual), mostly in Urdu
  • Advanced

Fee per participant

PKR 60,000 + taxes PKR 100,000

Enrol now