Inside Pramza's Excel with AI Bootcamp: A Cohort 2 Excel Study
Excel has approximately 1.5 billion users globally, but very many don't know how to build logic in it. What each formula does. What is the best formula for each situation. That "if" logic that forms the very foundation of how Excel thinks. And here's what's even more shocking: less than half of those 1.5 billion people have ever received any formal Excel training. Most are opening spreadsheets, copying formulas they don't understand, and praying nothing breaks before the boss asks for the report. Nobody taught them the why behind it, and that gap, between knowing Excel exists and actually commanding it, is exactly where the AI future will leave people behind. That is exactly why we built this bootcamp.
"Developing superintelligence will be the most profound technological advancement we will see in our lifetime." "Future of AI is for everyone."
What does this mean to Excel and people using Excel?
- Excel users need to move from memorizing formulas to understanding logic
- AI is changing the Excel workflow
The traditional workflow used to be:
Now the new workflow:
- Data literacy is becoming more important
- The Excel professional is becoming an AI-powered problem solver
- People who know how to use Excel + AI to solve problems faster and better.
Pramza Decision
Hence, the introduction of the Excel with AI Bootcamp. This was a one-month bootcamp designed around one simple idea: Excel users need to move beyond just knowing how to use Excel to actually understanding how to solve problems with Excel and AI.
Excel is everywhere. It is used across businesses and organizations globally, yet many people who use it every day have never received formal Excel training.
The Excel skills required in the workplace are changing. Excel is no longer just about entering data, doing basic calculations or preparing simple spreadsheets. Professionals are increasingly expected to analyze data, build dashboards, automate repetitive tasks, generate reports, identify trends and turn raw data into meaningful insights.
Many people learn Excel by trial and error. They copy formulas from colleagues, search online when they get stuck, or use formulas without fully understanding what they do or why they work.
AI is changing how we work. With AI becoming part of the modern workplace, Excel users now have an opportunity to use AI to help them write and understand formulas, analyze data, troubleshoot problems, automate tasks and work more efficiently.
The gap is no longer just about knowing Excel. The bigger question is whether professionals can combine their Excel knowledge with AI to solve problems faster, smarter and better.
With this in mind, the Excel with AI Bootcamp was structured as a one-month practical learning experience, working through this framework:
Understand the problem
•Clarify exactly what needs to be solved before opening Excel.
Structure the data
•Organise the raw numbers into a clean, usable format.
Choose the right Excel approach
•Pick the formulas, functions or dashboard tools that fit the problem.
Use AI to accelerate the work
•Bring in AI to speed up formulas, cleaning and analysis.
Validate the result
•Check the output against the data to catch errors before they spread.
Turn data into insights
•Translate the numbers into a story decision-makers can act on.
Make better decisions
•Use the insight to guide a real business decision.
Schedule
| Schedule | Detail |
|---|---|
| Period | 1 practical month |
| Virtual Training Days | Monday, Wednesday & Saturday (repetition of the Wednesday session) |
| Weekday Sessions | 7:30 PM – 9:30 PM |
| Saturday Session | Morning Session: 7:30 AM – 9:30 AM |
Modules
Week 1
Advanced Excel Formulas & Functions
- Lookups: VLOOKUP, XLOOKUP, INDEX-MATCH, nested lookups
- Logic: IF, IFS, AND, OR, IFERROR
- Text & Dates: Cleaning text, date functions
- Dynamic Arrays: FILTER, SORT, UNIQUE, SEQUENCE
- Conditional Math: SUMIFS, COUNTIFS, AVERAGEIFS
Week 2
Hard Coding in Excel
- Nested Formulas: Layering multiple functions in one formula
- Cross-Sheet Formulas: Combining data across sheets
- Multi-Condition Logic: Formulas checking several conditions
- Layered Lookups: Lookups combined with logic
Week 3
Excel with AI
- AI Formula Help: Copilot/ChatGPT for formulas
- Task Automation: Automating repetitive tasks
- AI Data Cleaning: Cleaning data with AI prompts
- AI Insights: Quick summaries from data
- Responsible Use: Limits and ethics of AI
Week 4
Building Interactive Dashboards
- Pivot Tables: Grouping, fields, slicers
- Charts: Bar, line, combo, waterfall, funnel
- Conditional Formatting: Colour and icons for data
- Data Validation: Drop-downs, controlled entry
- Dashboard Build: Assembling the final dashboard
Our Data: Student Profession Analysis
- Accountants64%
- Data Analysts27%
- Business Owners9%
Dataset Used
Every cohort practices on the same shared workbook, a realistic, multi-sheet dataset built for hands-on exercises.
Sheet Explanation
- Sheet 1: Included instructions
- Sheet 2: Sales Ledger
- Sheet 3: Expenses
- Sheet 4: Payroll
- Sheet 5: Dashboard (use it for practice)
Polls Carried Out During the Session
During the session we carried some polls to understand how the students are fairing:
Poll 1: How are you finding the training so far?
- Excellent100%
- Good0%
- Okay0%
- Challenging0%
Poll 2: How confident are you using Excel now?
- Very confident95%
- Confident5%
- Somewhat confident0%
- I still need more practice0%
Feedback from Learners
Some feedback we have received from our learners after the training:
"The programme gave me valuable knowledge and a much better understanding of data analysis using Excel, as well as how to integrate AI into data analysis and decision-making."
"It was an amazing experience and fun classes. It has made my Excel work very efficient and faster."
"One of the most interactive trainings I have ever attended. The instructors used practical examples and real world datasets that made learning more engaging."
"There is absolutely no regret. The ROI is definitely positive."
"The programme gave me valuable knowledge and a much better understanding of data analysis using Excel, as well as how to integrate AI into data analysis and decision-making."
"It was an amazing experience and fun classes. It has made my Excel work very efficient and faster."
"One of the most interactive trainings I have ever attended. The instructors used practical examples and real world datasets that made learning more engaging."
"There is absolutely no regret. The ROI is definitely positive."
Cohort 3 Is Enrolling Now
The next Excel with AI Bootcamp runs virtually, twice a week, from 5th to 30th October — same practical format, same four modules, same shift from memorising formulas to solving real problems with Excel and AI.
Excel with AI Bootcamp · Cohort 3
5th – 30th October · Twice a week · 7:30–9:30 PM · Virtual
Frequently Asked Questions
What is the Excel with AI Bootcamp?
A one-month, practical Pramza Solutions programme that takes Excel users beyond memorised formulas, teaching them to combine Excel with AI tools to solve real business problems faster.
Who is the bootcamp for?
Accountants, data analysts, and business owners make up the bulk of every cohort, but anyone who uses Excel at work and wants to work faster with AI is welcome.
When is the next cohort?
Cohort 3 runs virtually, twice a week, from 5th to 30th October. You can register on our Events page.
Statistic on Excel's ~1.5 billion global users is a widely cited industry estimate. Source