Pro Kit · e-book + tools27 filesAbout 3.5 hours to read

Analyse data in Excel with Copilot and Python, and prove every number you send

For analysts and students who already use Excel: a 12-chapter e-book, a 24-sheet Master Workbook, 5 fillable forms, 9 Word templates, 6 cheat sheets and a 35-file practice pack with messy data, Power Query, tested Python and an answer workbook.

  • Analyst Master Workbook (24 sheets): dated Tool notes, data profile, reconciliation, function picker, AI output log with a data-boundary check, month-end calendar, leave-Excel scorecard, go/no-go readiness check and a dashboard with four Excel charts
  • Practice files pack (35 files): messy sales, HR and service-desk datasets, a Power Query script, the same analysis as tested Python with pytest, Python in Excel cells you can also run locally, an executed notebook and an answer workbook
  • An AI prompt pack (30 prompts, each with the check to run), an AI data-boundary procedure, an analyst workbook standard and a leadership sign-off memo, ready to brand
  • 33 messages, 9 scenario cases with model answers, a 45-minute team briefing and a 14-question LMS-ready knowledge check

The Excel with Copilot and Python Analyst Kit · Bodhih Pro Kits · 346 by Bodhih Training, trainers to 2,000+ companies since 2008.

Quick answer

How do you use Copilot and Python in Excel for data analysis without getting wrong numbers?

Write the question first, keep data in Excel tables, clean it with recorded Power Query steps, report numbers from formulas, use Copilot to explore and draft, use Python in Excel for what formulas do badly, and check every output against an independent total. The Excel with Copilot and Python Analyst Kit from Bodhih Training covers each step.

Want the full free guide first? Read How to use Copilot and Python in Excel for data analysis.

Sound familiar?

You already feel the problem. Here is what it is costing you.

Hours of copy and paste every month

The same export, the same eleven fixes, in a slightly different order each time, and a nagging doubt that one was missed.

A total that looks fine

Duplicates push it up, numbers stored as text pull it down, and the result looks plausible. Nobody can say whether it is right.

Confident answers from AI

Copilot gives a margin that sounds right. Is it? Without a method and an independent check, nobody knows until it matters.

Not sure what may go into an AI tool

HR data, customer lists, unreleased results: the rules are unclear, so people either avoid the tools or take risks with them.

Now imagine this

Picture the next few weeks with the kit open beside you.

Picture next month's export arriving. Instead of opening last month's file, you open the Data profile sheet and count what is wrong before you touch anything. Then you press Refresh, and the Power Query steps you built once clean the new file the same way as the last.

By lunchtime the summaries are built from the data, not typed. You ask Copilot for a margin with the method stated, read the formula, compare it with your own total, and log the result. The Reconciliation sheet says RECONCILED on every row, and the readiness check says GO.

Whether you start with the practice pack tonight or the Analysis request brief tomorrow morning, every file has a filled SAMPLE so you can see what good looks like, and every exercise has its answer waiting in the answer workbook.

What’s in the box

27 files that do the work for you

The e-book shows you how. The tools make it happen. Here is exactly what you download.

E-book

The Excel with Copilot and Python Analyst Kit (e-book, PDF)

The guide: methods, worked examples, scripts and exercises

🔒
Cheat sheet

Start here: the analyst workflow map

The job in nine steps with the file for each, a 15-minute quick start, your first hour, your first week, the 30/60/90-day plan and the 'brand it in five minutes' box.

🔒
Cheat sheet

Situation router: which files to open, in which order

14 common analyst situations, each with the files to open in order, plus the 15-minute quick start.

🔒
Spreadsheet

Analyst Master Workbook (24 sheets)

Settings, dated Tool notes, self-assessment and gap plan, data profile, monthly and store results with traffic lights, reconciliation, formula reference and function picker, data boundaries, AI output log, month-end calendar, leave-Excel scorecard, readiness check, dashboard with four Excel charts, decision log, crosswalk, RACI, roadmap, What changed, glossary and sources.

🔒
Spreadsheet

Business case calculator: low, expected, high and do-nothing cases

Time-based business case for the kit's workflow with break-even months, net after 24 months, the monthly cost of the current way and a cumulative chart. Every input is your estimate; the low case may not pay back.

🔒
Fillable PDF

Analysis request brief (fill before you open the data)

One-page fillable brief: the question, the decision it feeds, who decides and when, the data and its owner, the definition of each number, the format, and what may go into an AI tool.

🔒
Fillable PDF

Data profiling record (before cleaning)

Two-page fillable record of what is wrong with an incoming file before you fix anything: shape, keys, types, dates, duplicates, outliers, and the rule or correction for each issue.

🔒
Fillable PDF

AI output check record (Copilot or Python in Excel)

One-page fillable record for any AI-generated formula, table, chart, code or insight you plan to keep: the data boundary, the prompt, the output, the independent check, the result and the disclosure.

🔒
Fillable PDF

Workbook review checklist (peer review before sharing)

Two-page fillable checklist a second person uses before a workbook or report is shared: structure, inputs and formulas, reconciliation, AI use, versioning, sharing and sign-off.

🔒
Fillable PDF

Report readiness check (go/no-go, printable)

One-page go/no-go check before a report is sent: twelve criteria, seven of them critical, with evidence and a verdict rule. The Master Workbook's Readiness check sheet calculates the verdict for you.

🔒
Word template

Leadership sign-off memo: AI-assisted analysis in Excel

Ready-to-brand memo for a finance or analytics lead to approve the workflow, the tools, the data boundaries, the checks and the 12-week plan, with a decision table and signature block.

🔒
Word template

Analyst workbook standard (procedure starter)

A short, adoptable standard for analytical workbooks: structure, tables and inputs, formulas, cleaning, checks, AI use, naming and versioning, sharing, review and retirement.

🔒
Word template

AI data-boundary procedure for Copilot and Python in Excel (policy starter)

A plain-English procedure: data classes, which tool may see which data, what never to paste, how to minimise and pseudonymise, checking and disclosure, incidents and training, with a crosswalk pointer by market.

🔒
Word template

Monthly analysis report template

A two-page report template: the one-line finding, what changed and why, key numbers with traffic lights, decisions needed, method and AI-use note, reconciliation statement and appendix.

🔒
Word template

Message and email library (33 messages)

33 ready-to-edit messages for scoping requests, data problems, access and licences, AI disclosure and pushback, review and sign-off, sending and correcting reports, and changing the way of working.

🔒
Word template

AI prompt pack for analysts (30 prompts with human-review rules)

30 prompts for Copilot in Excel, Python in Excel or any approved assistant, grouped by step of the job, each with what to paste in and the check to run before you use the output.

🔒
Word template

Scenario casebook (9 cases with model answers)

9 realistic cases from the US, Canada, the UK, Ireland, Australia and New Zealand: the facts, the questions and a model answer that cites the kit's method, chapters and files.

🔒
Word template

Worked examples: Carlos's filled templates

The three most-used templates filled in for the March 2027 sales report: the Analysis request brief, the AI output check record and the Workbook review checklist, with every number matching the workbook.

🔒
Word template

45-minute team briefing plan and knowledge-check answer key

A timed 45-minute session to brief a team on the workflow, data boundaries and checks, with materials, facilitator notes, two exercises from the practice pack and the knowledge-check answer key.

🔒
Cheat sheet

Modern formula card with classic fallbacks

One-page card: XLOOKUP, FILTER, SORT, UNIQUE, LET, LAMBDA, GROUPBY and PIVOTBY with syntax, a Saguaro example, the minimum version and the classic fallback, plus a mini-infographic of the dynamic-array spill.

🔒
Cheat sheet

Copilot and Python in Excel quick reference

Two-page reference: the five-part prompt, Copilot's edit, plan and chat modes, what to check, Python in Excel essentials (=PY, xl(), outputs, row-major order, shortcuts, where code runs) and a mini-infographic of the check loop.

🔒
Cheat sheet

Numbers that matter: analyst quality card

The numbers that show whether an analytical workflow is working: definitions, formulas, where each lives in the workbook and what to do if it moves, with Carlos's before and after.

🔒
Cheat sheet

Tool notes and data rules by market (November 2026)

Dated notes for Python in Excel, Copilot in Excel, GROUPBY, LAMBDA, Power Query and pandas (plans, platforms, modes, retired features), and the data rules for AI use by market, each with the official source.

🔒
Import file

Knowledge check (LMS-ready, 14 scenario questions)

14 scenario questions with four options, the correct letter and an explanation, ready to import into Bodhih LMS or any LMS.

🔒
Calendar plan

30-day practice plan, 12-week rollout and month-end cycles (calendar)

52 calendar events: 30 daily practice sessions, 12 weekly rollout check-ins, three month-end cycles and four quarterly reviews.

🔒
Import file

Task board: 30-day practice plan and 12-week rollout (CSV)

50 tasks with milestone, owner, due and status, ready to import into Planner, Trello, Asana, Notion or Jira.

🔒
pack

Practice files pack (35 files: data, Power Query, Python, tests, notebook, answers)

Messy SAMPLE datasets (sales, HR, service tickets) as CSV and xlsx, clean Excel tables for PivotTable, GROUPBY and Python in Excel practice, the Power Query M script, the same analysis as tested plain Python with pytest, Python in Excel cells with a local runner, an executed Jupyter notebook, a Copilot prompt library and the answer workbook.

🔒
Inside the e-book

Chapter by chapter

Each chapter opens with a real situation, gives you a method and ends with something to do today, using the tools in your kit.

Format
PDF e-book + XLSX + fillable PDF + DOCX + PDF cheat sheets + ICS + CSV + ZIP practice pack
Files
27 files plus a one-click ZIP
E-book
65 pages
Works with
Excel for Microsoft 365, Excel 2021 and 2024 (with fallbacks), Google Sheets and LibreOffice for the workbook, Word, Google Docs, Acrobat, Python 3.10+
Best for
Analysts and students who report numbers from Excel every month
Facts checked
November 2026, with official sources on the Tool notes sheet
  1. Start from the question, then pick the engine

    Write the question first, then choose formulas, Power Query, Copilot or Python for each part, with what measured studies of AI at work actually found.

  2. Tidy data and Excel tables

    Tidy data rules, Excel tables, profiling a messy file before you touch it, and why a plausible total can hide three errors.

  3. Clean once, refresh every month

    Power Query cleaning step by step, documented corrections, and the same cleaning as tested Python.

  4. The modern formula set

    XLOOKUP, FILTER, SORT, UNIQUE, LET and LAMBDA, with version checks and classic fallbacks for shared files.

  5. Summaries: PivotTables, GROUPBY and charts

    PivotTables, GROUPBY and PIVOTBY, rates computed from sums, and charts titled with the finding.

  6. Copilot in Excel: prompts that work

    Edit, plan and chat modes, the five-part prompt, and what Copilot is good and bad at in late 2026.

  7. Check everything Copilot gives you

    The check loop, the averaged-percentage trap, four ways to verify, and the AI output log.

  8. Python in Excel: the basics

    =PY cells, xl(), outputs, row-major order, where the code runs and who can use it.

  9. Python in Excel for real analysis

    Medians, reshaping, multi-row rules and charts in Python, with HR and service-desk examples.

  10. What may go into an AI tool

    Data classes, what regulators in six markets say, minimising and pseudonymising, and the boundary matrix.

  11. Error checks, versions and sharing

    Control totals, a raw-to-clean bridge, pytest, Excel's auditing tools, review roles, naming and sharing.

  12. The monthly report and when to leave Excel

    The month-end calendar, the readiness check, an honest business case and the leave-Excel scorecard.

What you get

Not just reading. Tools you will actually open again.

Start here

  • 00-Start-Here-Analyst-Kit-Map.pdf: the workflow in nine steps, a 15-minute quick start, first hour, first week and 30/60/90 days
  • Situation-Router.pdf: 14 situations and the files to open in order

Workbooks

  • Analyst-Master-Workbook.xlsx: 24 sheets including Settings, Tool notes, Self-assessment, Gap plan, Data profile, Monthly sales, Store results, Reconciliation, Formula reference, Function picker, Data boundaries, AI output log, Month-end calendar, Leave-Excel scorecard, Readiness check, Dashboard, Decision log, Crosswalk, RACI, Roadmap, What changed, Glossary and Sources
  • Analyst-Workflow-Business-Case-Calculator.xlsx: low, expected, high and do-nothing cases with break-even months and a cumulative chart

Fillable PDF forms

  • Analysis request brief (fill before you open the data)
  • Data profiling record (before cleaning)
  • AI output check record (Copilot or Python in Excel)
  • Workbook review checklist (peer review before sharing)
  • Report readiness check (go/no-go, printable)

Word templates

  • Leadership sign-off memo: AI-assisted analysis in Excel
  • Analyst workbook standard (procedure starter)
  • AI data-boundary procedure for Copilot and Python in Excel (policy starter)
  • Monthly analysis report template
  • Message and email library (33 messages)
  • AI prompt pack for analysts (30 prompts with human-review rules)
  • Scenario casebook (9 cases with model answers)
  • Worked examples: Carlos's filled templates
  • 45-minute team briefing plan and knowledge-check answer key

Cheat sheets

  • Modern formula card with classic fallbacks
  • Copilot and Python in Excel quick reference
  • Numbers that matter: analyst quality card
  • Tool notes and data rules by market (November 2026)

Practice files, calendar and import

  • Practice files pack (35 files: data, Power Query, Python, tests, notebook, answers)
  • 30-day practice plan, 12-week rollout and month-end cycles (calendar): 52 events
  • Task board: 30-day practice plan and 12-week rollout (CSV): 50 tasks
  • Knowledge check (LMS-ready, 14 scenario questions)
Outcomes

When you have worked through it, you will be able to…

Every outcome is practised with a worked example and a tool, not just described.

  • Turn a vague request into a written question with a decision, a decider and agreed definitions
  • Profile a messy file and clean it with recorded, repeatable Power Query steps
  • Use XLOOKUP, FILTER, LET, LAMBDA, GROUPBY and PIVOTBY where your version has them, with fallbacks where it does not
  • Prompt Copilot in Excel with table, task, method and output, and check every answer against an independent value
  • Write and read Python in Excel cells for statistics, reshaping and charts
  • Decide which data may go into which AI tool, and log every AI output you keep
  • Reconcile a report with control totals and a raw-to-clean bridge, and get it reviewed before it goes out
  • Judge when a report has outgrown Excel, with a scorecard and an honest business case
Measure it

Know your starting point. Prove your progress.

People who measure before and after improve faster and can show it. AssessAll, our sister assessment platform, has AI-graded assessments that pair with this kit. Take one now, work through the kit, then re-take it.

Read a page

A taste of the Introduction

It is the fourth working day of April, and Carlos Medina has a number he does not trust. Carlos is the financial analyst at Saguaro Outfitters, a 450-person home-and-outdoor retail chain with twelve stores across Arizona and a head office in Phoenix. Every month he turns the stores' sales export into the report the operations team uses to decide which stores need attention. Every month it takes him about 16 hours of copying, pasting, fixing and checking. This month the total looks fine. It is close to what he expected. That is exactly what worries him, because last quarter a total that "looked fine" turned out to contain a store counted twice. This book is about the gap between a number that looks right and a number you can defend.

From The Excel with Copilot and Python Analyst Kit, Bodhih Training
Why this kit

The honest comparison

Free templates and typical adviceThis kit
Data to practise onClean sample tables with no problems to findMessy SAMPLE files with nine kinds of problem, plus clean tables and an answer workbook
Copilot guidanceLists of promptsA five-part prompt, 30 prompts each with its check, and an AI output log
Python in ExcelFeature toursCells to type, the same code runnable on your computer, a notebook and pytest tests
Proving the numbersRarely coveredReconciliation sheet, raw-to-clean bridge, review checklist and go/no-go check
Data protection with AIA general warningData classes, a boundary matrix, a procedure starter and a dated six-market crosswalk
Keeping currentUndated screenshotsTool notes with official links and last-checked dates; a What changed log
Who it’s for

Made for you if…

  • Financial, operations, sales and HR analysts who build monthly reports in Excel
  • Professionals moving from spreadsheet basics to analyst-level work
  • University students in business, finance, economics and analytics courses (follow your institution's academic-integrity rules on AI use)
  • Team leads who want AI tools used with clear data boundaries and checks
  • Readers in the US, Canada, the UK, Ireland and the EU, Australia, New Zealand and other English-speaking markets
Being honest

Probably not for you if…

  • Beginners who need spreadsheet basics first: start with our Spreadsheet Superpowers kit
  • Anyone wanting a guarantee that Copilot or Python in Excel will be on their plan: availability depends on your Microsoft 365 licence and organisation
  • Data engineers looking for database, cloud pipeline or machine-learning training
  • Anyone seeking legal advice on data protection: the dated sheets point to official sources and your adviser
Why Bodhih

Built by trainers, tested in real rooms.

Bodhih Training has designed and delivered corporate programmes since 2008. Bodhih Pro Kits package what works in those workshops into a guide plus the exact tools we use, so you can apply it the same day without a facilitator in the room.

2008Training organisations since
2,000+Companies served
200,000+Professionals trained
18,000+Programmes delivered
How it works

From here to using it in three steps

  1. STEP 1

    Tap Get the kit

    Name, email and country. UPI, card or netbanking in India; international cards everywhere else. No account to create.

  2. STEP 2

    Download instantly

    Your download page opens at once, with every file and a one-click ZIP. A permanent link lands in your inbox too.

  3. STEP 3

    Open the first tool

    Start with the quick-start chapter, then the main spreadsheet or planner. Most buyers use something from the kit the same day.

Ready when you are

Open the practice pack and do Day 1

Profile the raw file, see the three hidden errors, and watch the totals reconcile. Whether you start with the practice pack tonight or the analysis brief tomorrow, the files are ready, each with a filled SAMPLE. Not affiliated with or endorsed by Microsoft, Anaconda, the pandas project, OpenAI, Anthropic or Google.

$34one-time payment

Personal licence for the buyer's own use (and use with your own team where the kit says so). Please don't share or resell the files. Team and company licences: solutions@bodhih.com.

What buyers say

No ratings yet. Only people who have bought this kit can rate it - every buyer gets a one-click rating link a couple of days after their purchase.

Questions buyers ask

The Excel with Copilot and Python Analyst Kit: FAQs

Read the free guideAlready bought? Resend my link

Do I need Copilot or Python in Excel to use this kit?

No. Every exercise works without them: the practice pack runs the same Python on your own computer, and the prompts work with any approved assistant on dummy data. If you do have them, the book shows how to use and check them. Availability depends on your Microsoft 365 plan and your organisation's settings.

Which Microsoft 365 plans include Copilot in Excel and Python in Excel?

It changes often. In November 2026 Microsoft listed Copilot in Excel for certain Personal, Family, Premium, commercial Copilot and Copilot Chat-eligible business plans, and Python in Excel for Enterprise and Business users with preview for Family, Personal and Education. The workbook's Tool notes sheet has the details, official links and the date checked.

Is Copilot in Excel accurate enough for financial reporting?

Microsoft's own FAQ says Copilot can make mistakes, that you should verify anything it creates, and that you should avoid using it for decisions in sensitive areas such as finance. The kit's method is that formulas report the numbers, Copilot explores and drafts, and every kept AI output is checked against an independent value and logged.

What is Python in Excel, and where does the code run?

It lets you type Python into a cell with =PY and read workbook data with xl(). Microsoft says the code runs in isolated containers in the Microsoft Cloud with no network access and no access to your computer. Chapter 8 explains outputs, calculation order and availability.

Can I use XLOOKUP, LET and GROUPBY if my colleagues have older Excel?

Check first. The Function picker sheet shows the modern function or the classic fallback for each Excel version, and the Master Workbook itself uses only classic functions so everyone can open it.

What data can I paste into Copilot or ChatGPT at work?

It depends on your organisation's policy and contracts. The kit gives a data-class matrix, an AI data-boundary procedure starter and a dated crosswalk of regulator guidance for the US, Canada, the UK, the EU, Australia and New Zealand. It is not legal advice; ask your privacy lead.

How long does it take to learn this?

About 3.5 hours to read and a 30-day practice plan of roughly 25 minutes a day. The business case calculator lets you estimate your own learning and build time; the expected case in the sample breaks even in about 5.9 months, the low case in about 46.1.

Can I use this with my team?

Yes, within your own organisation under the personal licence: the team briefing plan, casebook and knowledge check are built for it. Company and multi-site licences are available from solutions@bodhih.com.

Does it work in my country?

The method and files work anywhere Excel does. Data-protection rules differ: the dated crosswalk covers the US, Canada, the UK, the EU, Australia and New Zealand with official links, and you should check local law with your adviser.

I am a student. Can I use this for coursework?

Yes for learning the skills, with the practice data. Follow your institution's academic-integrity rules on AI tools and disclose AI use where your course requires it.

How can I measure my starting point?

Score the kit's self-assessment, or take an AssessAll assessment such as Spreadsheet and Data Literacy or the Data Analysis in Python work sample to get an independent baseline.

How do I turn this into a development plan?

Use the gap plan sheet for the next 90 days, then build a measured individual development plan with Jobulary.

How much does The Excel with Copilot and Python Analyst Kit cost?

₹1,299 including 18% GST for buyers in India, or $34 for buyers outside India. One-time payment, no subscription, with an automatic invoice.

How do I get the files after paying?

Instantly. Your download page opens the moment payment succeeds, and a permanent download link is emailed to you. Download each file separately or everything in one ZIP.

What software do I need?

Any of the usual tools: Excel or Google Sheets for spreadsheets, Word or Google Docs for templates, Adobe Acrobat Reader, Preview, Xodo or GoodNotes for the fillable PDFs, and Google, Outlook or Apple Calendar for the calendar plan.

Can I get a refund?

Because it is a digital download, kits are not refundable once downloaded. We always refund a duplicate charge or a failed delivery, and if a file is corrupted and we cannot fix it within 3 working days. Full terms: bodhih.org/refunds.

Can my company buy this for a team?

Yes. Team and company licences, and workshops on this topic run by Bodhih Training, are available. Write to solutions@bodhih.com or call +91 99000 11601.

$34