Skip to main content
Virtual · 4 weeks

Excel & Power BI with AI (Virtual)

Go from messy spreadsheets to an automated Excel report and a Power BI dashboard in four weeks, with Copilot and ChatGPT doing the slow parts.

Two live evening classes a week from anywhere in India. You bring your own work data or use ours, learn the Excel functions, pivots and Power Query that office jobs use daily, build your first Power BI dashboard and use AI to write and check formulas.

Tools you'll use
  • Excel
  • Power Query
  • Power BI
  • Microsoft Copilot
  • ChatGPT
Book free counselling See the full syllabus

Free 20-minute call or WhatsApp chat before you join.

What you walk out with

  • An Excel report that refreshes with one click
  • Your first Power BI dashboard
  • A formula and prompt cheat sheet
  • LearnPact certificate of completion

Where this takes you

  • Faster reporting in your current job
  • Next: Data Analytics with AI

Syllabus, week by week

Every block is taught live, practised with trainer help, then tested on a changed problem before you move on.

  1. Week 1
    1. Excel that saves hours
    • XLOOKUP, IFS and text functions
    • Pivot tables and charts
    • AI for formulas

    You build: A cleaned sales table with a pivot summary.

  2. Week 2
    2. Power Query
    • Import and clean
    • Merge and append
    • One-click refresh

    You build: A monthly report that refreshes itself.

  3. Week 3
    3. Power BI dashboards
    • Data model basics
    • Simple DAX measures
    • Visuals that read well

    You build: A one-page dashboard.

  4. Week 4
    4. AI and your own report
    • Copilot and ChatGPT for analysis
    • Checking AI numbers
    • Publishing and sharing

    You build: Your own work report, automated.

Your portfolio and your certificate

Final project

One of your own recurring reports rebuilt in Excel and Power BI, refreshing with one click.

Job-simulation test

In the last class: fix a broken lookup, a wrong pivot and an AI summary that misreads the data.

Certificates

  • LearnPact certificate of completion
  • A first step towards Microsoft PL-300

On every virtual course

Written into your enrolment confirmation before you pay.

  • Live, every class

    Taught live by a named trainer, with your questions answered in the session. Recordings are added the same day.

  • Refund if it isn't for you

    Courses of four weeks or less: tell us before the second class. Longer courses: before week 3. The full fee comes back.

  • Work reviewed by a trainer

    Assignments and your final project are reviewed by the trainer, not auto-graded.

  • One fee, in writing

    GST-inclusive in India, billed in your own currency abroad. Instalments where offered, never a loan.

  • Certificate within 7 days

    Issued within seven days of completing the final project or test.

  • Step up later

    Move to the full course within 60 days and the fee you paid counts towards it.

Right for you if you are

  • Office staff who build reports every week
  • Graduates adding a skill employers ask for in most job ads
  • Anyone preparing for a data career

Probably not for you if

  • People who already build Power BI dashboards at work
Trainer to be named before the batch opens. You meet them at counselling, before you pay.

Questions people ask

Is it live or recorded?+
Live. Every class is taught live by the trainer, with questions answered in the session; recordings are added the same day for revision.
What if it isn't for me?+
Tell us in writing before the second class and we refund the full ₹3,999.
Do I need Power BI installed?+
Power BI Desktop is free from Microsoft and runs on Windows. Mac users follow along in the browser version, with a few features shown by the trainer.

Talk to us before you join

Book a free 20-minute call at a time that suits your time zone. Meet the trainer, ask anything, and get the fee, timetable and refund terms in writing before you pay.

Book free counselling Try a ₹99 Sunday Lab first

Other courses