I Asked Microsoft Copilot to Calculate My Taxes — Here's What Happened

Share
I Asked Microsoft Copilot to Calculate My Taxes — Here's What Happened

Can Microsoft Copilot accurately calculate your federal taxes? I put it to the test by first walking through a manual tax calculation in Excel using the 2025 federal tax brackets, then asking Copilot the same question to compare results.

Part 1: Manual Tax Calculation in Excel

The process starts with understanding three key pieces of information:

  1. Filing status — Married filing jointly, single, head of household, etc.
  2. Taxable income — Found on IRS Form 1040, Line 15
  3. Tax bracket — The 2025 federal brackets determine how much you owe at each income level

I demonstrate the step-by-step calculation in Excel, showing how the progressive tax system works. Each portion of income is taxed at a different rate — you don't pay the highest bracket rate on your entire income.

Part 2: Testing Microsoft Copilot

With the manual calculation done, Chris asks Copilot the same tax question. Copilot correctly identifies that it needs the filing status before it can calculate, and asks for clarification — a good sign that it understands the problem.

After providing the filing status, Copilot returns the correct tax liability, matching the manual Excel calculation.

Marginal vs. Effective Tax Rate

The video also covers the important distinction between the marginal tax rate (the bracket your top dollar falls into) and the effective tax rate (the actual percentage of your total income that goes to taxes). These two numbers can be very different.

For more Copilot-powered financial analysis in Excel, see how Copilot handles financial ratio calculations using Formula Completion, or how to use the Future Value function correctly for investment projections.

Marginal Tax Rate VS Effective Tax Rate

How to Create Audio Overviews of Word Documents with Microsoft 365 Copilot
Microsoft 365 Copilot can convert Word documents into spoken audio summaries — what Microsoft calls Audio Overviews. Instead of reading a long employee handbook, report, or proposal, you can listen to it while commuting, walking, or preparing for a meeting. The audio output can be saved as an MP3 to your
Summarize Outlook Attachments with Copilot: Chris Menard Training
In today’s fast-paced digital world, managing emails efficiently is crucial, especially when it comes to handling attachments. I demonstrate an exciting new feature that has rolled out in Microsoft Outlook’s Copilot — the ability to summarize Outlook attachments with Copilot
Combining Unique Names from Multiple Lists with Copilot in Excel: Chris Menard Training
Copilot in Excel can help us combine unique names from multiple lists, a task that’s often needed but can be tricky to execute manually.

Want to learn more? Visit courses.chrismenardtraining.com for online training courses.

Read more

Copilot Skills in PowerPoint - Live Stream on October 20, 2026

Copilot Skills in PowerPoint - Live Stream on October 20, 2026

𝗠𝗼𝘀𝘁 𝗣𝗼𝘄𝗲𝗿𝗣𝗼𝗶𝗻𝘁 𝘂𝘀𝗲𝗿𝘀 𝗸𝗻𝗼𝘄 𝗖𝗼𝗽𝗶𝗹𝗼𝘁 𝗰𝗮𝗻 𝗰𝗿𝗲𝗮𝘁𝗲 𝘀𝗹𝗶𝗱𝗲𝘀. 𝗙𝗮𝗿 𝗳𝗲𝘄𝗲𝗿 𝗸𝗻𝗼𝘄 𝗮𝗯𝗼𝘂𝘁 𝘁𝗵𝗲 𝟴 𝗯𝘂𝗶𝗹𝘁-𝗶𝗻 𝗖𝗼𝗽𝗶𝗹𝗼𝘁 𝗦𝗸𝗶𝗹𝗹𝘀 𝘁𝗵𝗮𝘁 𝗰𝗮𝗻 𝗰𝗼𝗺𝗽𝗹𝗲𝘁𝗲𝗹𝘆 𝗰𝗵𝗮𝗻𝗴𝗲 𝗵𝗼𝘄 𝘆𝗼𝘂 𝗯𝘂𝗶𝗹𝗱, 𝗶𝗺𝗽𝗿𝗼𝘃𝗲, 𝗮𝗻𝗱 𝗽𝗿𝗲𝘀𝗲𝗻𝘁 𝗮 𝗱𝗲𝗰𝗸. Join me live on October 20, 2026, at Noon Eastern as I demonstrate each Copilot Skill and show practical ways to use them in your presentations. PDF of the 8 Copilot Skills in Pow

By Chris Menard