AI
AI for Excel & PowerPoint (Microsoft Copilot) — syllabus 2026
Use Copilot to clean data, write formulas, find insights and turn Excel analysis into management decks — plus prompt engineering and how to show these skills on your resume.
Module-wise syllabus
Tap a module to see every topic. The same syllabus is used in our classroom and live online batches.
01Introduction to Microsoft Copilot4 topics
- Copilot in Microsoft 365
- How Copilot works with Excel & PowerPoint
- Data security & permissions
- MIS & analytics use cases
02Copilot in Excel — Data Handling3 topics
- Understanding datasets with natural-language questions
- Cleaning & preparing data
- Spotting errors, blanks & duplicates
03Copilot for Analysis & Insights3 topics
- Automatic summaries & insights
- Trend & variance analysis
- KPI identification, forecasting & what-if
04Copilot for Formulas & Automation3 topics
- Formulas from plain English
- XLOOKUP, INDEX-MATCH, IF, SUMIFS with Copilot
- Explaining existing formulas
05Copilot for Excel Dashboards3 topics
- Charts from prompts & right-chart selection
- Dashboard layouts
- Executive summary from dashboard data
06Copilot in PowerPoint3 topics
- Presentations from prompts
- Slides from Excel data
- Auto titles, bullets, layouts & design
07Copilot for MIS Presentations3 topics
- Monthly / weekly MIS decks
- KPI storytelling for leadership
- One-click executive summary slides
08Excel + PowerPoint + Copilot Workflow3 topics
- Excel analysis → PPT slides
- Auto-updating presentations
- Cutting report-preparation time
09Prompt Engineering for Office3 topics
- Prompts for analysis, summaries & charts
- PowerPoint prompt techniques
- Do’s & don’ts; improving accuracy
10Corporate Case Studies2 topics
- Sales MIS, finance & budget analysis
- HR dashboards, operations reporting
11Interview & Job Readiness2 topics
- Copilot interview questions & practical tests
- Putting Copilot skills on your resume
Projects & practice
AI-assisted sales MISExcel-to-PPT management deckPrompt library for daily reports
Programmes that include AI & Copilot
| Programme | Duration | Fees |
|---|---|---|
| Professional MIS & Analytics + Job Placement | 6–8 months | ₹30,000 |
| Professional Business Analytics + Job Placement | 8–10 months | ₹40,000 |
Frequently asked questions
Can I download the AI & Copilot syllabus as a PDF?
Yes. Use the “Download syllabus PDF” button on this page — enter your name and mobile number and the PDF opens instantly.
How long does the AI & Copilot course take?
It is taught inside our programmes: Professional MIS & Analytics + Job Placement (6–8 months, ₹30,000); Professional Business Analytics + Job Placement (8–10 months, ₹40,000). Module-wise batches are also possible — ask the counsellor.
Is it online or classroom?
Both. Classroom batches run at our Dwarka, Uttam Nagar and Janakpuri branches, and live online batches are available.