This course teaches learners how to use Microsoft Copilot inside Excel to work faster and smarter โ from writing formulas in plain English to cleaning data, building PivotTables, generating charts, and automating multi-step workflows with Agent Mode. Learners finish with the skills to apply AI-assisted analysis to real business problems while knowing how to verify and trust the results.

Who it's for: Beginners to advanced Excel users, Business professionals and analysts, Students building practical data skills, Anyone with Microsoft 365 Copilot access wanting to work faster in Excel
Zero tedious manual formula typing โ turn hours of spreadsheet work into seconds with AI
Ask in plain English โ Copilot generates complex XLOOKUP, INDEX/MATCH, and nested IFS instantly
Fix messy dates, split text, remove duplicates, and standardize inconsistent formatting in 1 click
Generate multi-variable PivotTables, trend lines, and dynamic charts from raw data without manual drag-and-drop
Command Copilot Agent to execute multi-sheet reconciliations, monthly reporting flows, and cross-workbook summaries
Spot-check AI outputs, inspect formula precedents, detect calculation errors, and verify data accuracy
Transform raw transaction logs into clean, dynamic executive dashboards and automated visual scorecards
What Copilot in Excel is, its licensing requirements, and a tour of the interface.
Why spreadsheet structure matters, converting ranges to Excel Tables, and cleaning data with Copilot prompts.
Turning plain-English requests into working formulas, common formula requests, and debugging formulas with Copilot.
Asking analytical questions, generating PivotTables, and building charts and visualizations with Copilot.
What Plan mode is, when to use it, and reviewing Copilot's changes before and after they're applied.
Designing prompts for Agent Mode and using guardrails and oversight to keep autonomous workflows on track.
The anatomy of a good Excel prompt, iterating on prompts, and common mistakes to avoid.
Why you still need to check Copilot's work, data governance basics, and a full capstone project.
Built for real corporate spreadsheet workflows and data analysis โ not outdated formula memorization
| Feature | Celoris Live Masterclass | Traditional Excel Courses / Pre-recorded |
|---|---|---|
| Training Format | 100% Live in Celoris Classrooms with screen sharing & real-time prompt tests | Pre-recorded 2018 videos with zero AI or Copilot features |
| Hands-on AI Practice | Live prompt engineering with messy real-world corporate datasets | Static slides or basic VLOOKUP drills with clean toy examples |
| Copilot Agent Mode | Full coverage of 2026 Agent Mode, Plan Mode & multi-sheet workflows | Outdated curriculum ignoring autonomous AI agent capabilities |
| Formula Auditing & Trust | Systematic frameworks to catch AI errors & verify enterprise calculations | Zero error verification or blind trust in AI outputs |
| Investment & Access | Free launch pass tier open per round with โน0 tuition pass | Corporate workshops charging โน15,000 to โน35,000 upfront |
Try these proven prompt structures in your own spreadsheets โ click any prompt to copy it
"Clean this table: trim all leading and trailing spaces, format all phone numbers with '+91 ' prefix, capitalize customer names in Proper Case, and flag any rows with duplicate email addresses in a new column called 'Is_Duplicate'."
"Write a formula in Column G: If Region is 'North' and Sales > 50000, apply a 12% incentive bonus; if Region is 'South' and Sales > 40000, apply 10%; otherwise 5%. Round the result to the nearest rupee."
"Create a summary PivotTable showing total Revenue and Units Sold by Product Category across Q1-Q4. Calculate Month-over-Month growth rate and highlight the top 3 highest margin products."
"Compare 'Sheet_Bank_Statement' against 'Sheet_Ledger'. Match records by Transaction ID and Amount, identify all un-reconciled line items, and generate a new Reconciliation Report sheet with total variance."
Classes are conducted live and interactively in Celoris Classrooms with screen sharing, live spreadsheet exercises, and direct Q&A. This batch meets Starts 13 Oct ยท 7:00 PM IST (90 minutes per session). Mentored by Prabha Singh.
A Microsoft 365 Copilot license is recommended so you can practice prompts in real time inside Excel (desktop or web). However, every session is demonstrated with high-definition screen recordings, downloadable practice workbooks, and prompt templates, so you can master the frameworks even before your workplace activates Copilot.
Yes, absolutely. The course begins with the foundational principles of preparing clean tabular data and headers so Copilot can parse it accurately. You do not need to memorize complex formulas โ Copilot will generate formulas (like XLOOKUP, SUMIFS, and nested logic) from your plain English instructions.
Plan Mode explains the step-by-step logic for a specific task and waits for your confirmation before touching the spreadsheet. Agent Mode operates autonomously across multi-sheet workbooks to clean data, build PivotTables, generate summary reports, and run financial reconciliations, while pausing at safety checkpoints for your review.
Yes. A critical module is dedicated to formula auditing and data verification. You will learn how to spot-check Copilot's calculations, inspect cell precedents, validate mathematical logic, and ensure total data integrity before presenting numbers to management or clients.
Yes! Every session recording is uploaded immediately to your Celoris student dashboard with lifetime access. You also receive downloadable sample business workbooks, exercise sheets, and the Celoris Copilot Prompt Swipe File with 100+ production-tested prompts.
Free passes are released in rounds: up to 15 passes per round, until all 15 seats in the batch are claimed. Once claimed, you receive 100% full tuition access to the live batch, recordings, and capstone project at โน0. Standard course fee is โน1,200.
Yes, upon completing the hands-on capstone project, you earn a verified Celoris Academy Certificate of Completion that you can add to your LinkedIn profile and resume.
Ask about Microsoft 365 licensing, Excel versions, or batch schedule directly on WhatsApp.
Written by our students on the earlier Celoris website and carried over here. New reviews from this site appear below.
Priya Ramanathan
Celoris student ยท from our earlier website
โI've used Excel for years but never touched Copilot until this course. The module on prompt-writing best practices alone was worth it โ I went from vague one-line prompts to getting exactly what I wanted on the first try. The capstone project tied everything together nicely.โ
Rohan Deshmukh
Celoris student ยท from our earlier website
โSolid course overall, but Module 6 on Agent Mode felt rushed compared to everything else. I had to rewatch it twice and still felt a little unsure setting checkpoints. Would love a longer walkthrough with a messier real-world example.โ
Sneha Iyer
Celoris student ยท from our earlier website
โI kept confusing Plan mode and Agent mode before taking this course. The side-by-side comparison in Module 5 made it click immediately. Also appreciated the honesty about verifying Copilot's output instead of just trusting it blindly.โ
Arjun Malhotra
Celoris student ยท from our earlier website
โThe course itself is well structured, but Copilot's UI changed twice while I was going through it and some screenshots/references no longer matched what I saw in my own Excel. Not really the instructor's fault since Microsoft updates constantly, but frustrating as a learner.โ
Ananya Krishnan
Celoris student ยท from our earlier website
โIf you already know basic Excel, this is a great next step. The data-cleaning prompts in Module 2 saved me real time this week at work. Docked one star because I wish there were more practice files โ some exercises reused the same dataset.โ
Vikram Nair
Celoris student ยท from our earlier website
โA lot of Excel courses are just "watch me click buttons." This one made me actually do the work with a messy dataset at the end, which is where the real learning happened. Highly recommend for anyone who learns by doing.โ
Kavya Reddy
Celoris student ยท from our earlier website
โWish this had been clearer upfront about licensing costs before diving into features I couldn't actually try without paying more for a Copilot add-on. The content itself is fine, just wasn't fully prepared for that.โ
Aditya Chatterjee
Celoris student ยท from our earlier website
โModule 3 on natural-language formulas was excellent โ I finally stopped Googling XLOOKUP syntax every time. Minor gripe: the debugging section could use one more example with a genuinely broken formula.โ
Meera Pillai
Celoris student ยท from our earlier website
โI wanted more time actually watching prompts being typed and results appearing in real time. Some lessons explain concepts well but don't show enough live examples inside the spreadsheet itself.โ
Karan Bhatia
Celoris student ยท from our earlier website
โI run reports every week for my team and this course cut my prep time nearly in half. The PivotTable and charting prompts in Module 4 alone paid for the course. Well organized from start to finish.โ
Priya Ramanathan
Celoris student ยท from our earlier website
โI've used Excel for years but never touched Copilot until this course. The module on prompt-writing best practices alone was worth it โ I went from vague one-line prompts to getting exactly what I wanted on the first try. The capstone project tied everything together nicely.โ
Rohan Deshmukh
Celoris student ยท from our earlier website
โSolid course overall, but Module 6 on Agent Mode felt rushed compared to everything else. I had to rewatch it twice and still felt a little unsure setting checkpoints. Would love a longer walkthrough with a messier real-world example.โ
Sneha Iyer
Celoris student ยท from our earlier website
โI kept confusing Plan mode and Agent mode before taking this course. The side-by-side comparison in Module 5 made it click immediately. Also appreciated the honesty about verifying Copilot's output instead of just trusting it blindly.โ
Arjun Malhotra
Celoris student ยท from our earlier website
โThe course itself is well structured, but Copilot's UI changed twice while I was going through it and some screenshots/references no longer matched what I saw in my own Excel. Not really the instructor's fault since Microsoft updates constantly, but frustrating as a learner.โ
Ananya Krishnan
Celoris student ยท from our earlier website
โIf you already know basic Excel, this is a great next step. The data-cleaning prompts in Module 2 saved me real time this week at work. Docked one star because I wish there were more practice files โ some exercises reused the same dataset.โ
Vikram Nair
Celoris student ยท from our earlier website
โA lot of Excel courses are just "watch me click buttons." This one made me actually do the work with a messy dataset at the end, which is where the real learning happened. Highly recommend for anyone who learns by doing.โ
Kavya Reddy
Celoris student ยท from our earlier website
โWish this had been clearer upfront about licensing costs before diving into features I couldn't actually try without paying more for a Copilot add-on. The content itself is fine, just wasn't fully prepared for that.โ
Aditya Chatterjee
Celoris student ยท from our earlier website
โModule 3 on natural-language formulas was excellent โ I finally stopped Googling XLOOKUP syntax every time. Minor gripe: the debugging section could use one more example with a genuinely broken formula.โ
Meera Pillai
Celoris student ยท from our earlier website
โI wanted more time actually watching prompts being typed and results appearing in real time. Some lessons explain concepts well but don't show enough live examples inside the spreadsheet itself.โ
Karan Bhatia
Celoris student ยท from our earlier website
โI run reports every week for my team and this course cut my prep time nearly in half. The PivotTable and charting prompts in Module 4 alone paid for the course. Well organized from start to finish.โ
Written by real Celoris students and checked by our team.
Batch 07 FullBatch 08 Launching
Starts 13 Oct ยท 7:00 PM IST โข 15 Passes Open