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

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