Use Copilot in Excel to build your brackets
The matchups are finally set, and the annual question is back: how do you pick a bracket that’s fun and gives you a real shot at predicting the winner—whether you’re following the men’s tournament, the women’s tournament, or both? This year, you can use Copilot in Excel as your bracket sidekick—turning past tournament patterns into quick “what-if” scenarios, stress-testing upset paths, and sanity-checking your picks against historic data. Instead of manually building an analysis, copy/pasting data, and building multiple versions, you can ask in natural language and let Copilot build the analysis for you right inside an Excel workbook. Below are a few fast, practical ways to use Copilot in Excel to build a bracket workbook, explore upside picks (hello, Cinderella runs), and model “if this happens, then what?” outcomes so you can fill your bracket with more confidence than the rest of the group. 1) Set up a bracket workbook Open a new workbook, then open Copilot in Excel. Make sure “Edit with Copilot” is turned on. Start by asking Copilot to create a bracket template: “Create a 2026 [men’s or women’s] college basketball bracket including all the latest teams and seeds. Build dropdowns for each round so I can choose the winner of each matchup all the way to a champion, formatted like a standard bracket. For each dropdown, show only the 2 teams in the matchup based on the winners chose in previous rounds using helper columns." With that foundation in place, you’ve got a clean structure for picks and scenario assumptions. From here, you can make your picks and Copilot can help you add calculations, create “what-if” views, and summarize the implications of different upset paths. Bonus: Want to theme your brackets around your favorite team? First have Copilot generate a simple skills sheet and ask it to follow the instructions when creating brackets. “Create a skills sheet for my favorite team, [Team]. Include the official team colors (with hex codes), mascot/nickname, text colors, and conditional formatting rules for winners/losers.” 2) Stress-test your bracket with real-world scenarios Now for the part that can actually give you an edge: use Copilot to spin up scenario tabs and see how your bracket performs under outcomes that happen all the time in March—Cinderella runs, unexpected seed collapses, and “hot team” momentum that goes against conventional logic. Try some follow-up Copilot prompts like: Cinderella path: “Pick a 10–13 seed to reach the Sweet 16 based on past tournament frequency. Create a version to reflect that upset path, and show which higher-seeded teams I’m fading.” All the 1-seeds don’t make it: “Create a version of my bracket where at least two 1-seeds lose before the Elite Eight. Identify the earliest-round upsets needed and how my champion pick changes.” Favorite team: “Assume my favorite team is [Team]. Build two paths: (1) optimistic (reach the Final Four) and (2) realistic (based on projected path). For each path, show who they’d likely face by seed line and which matchup round matters most for them.” Momentum model: “Calculate a “momentum multiplier” using the conference tournament games and recent performance for each team and use that to fill out a version of my bracket weighted by momentum.” 3) Compare bracket variants and choose your entry Once you’ve built a few scenario versions, Copilot can help you compare them—so you’re not guessing which bracket is better, you’re choosing the one whose risk/reward matches your needs. Use a prompt like: “Create a comparison analysis for all my bracket scenarios in this workbook including charts. Include number of upset picks by round, and my top 5 most ‘contrarian’ picks across all my brackets. Give a recommendation for which to submit if I’m trying to win my bracket challenge or simply play it safe.” Copilot can generate the comparison table, highlight the key differences, and summarize the tradeoffs in plain language—so you can decide whether you want a safer entry, a balanced upset strategy, or a bold bracket designed to win big. Your turn: build your bracket with Copilot Ready to try it? Open Excel, start a new workbook, and use Edit with Copilot to create your brackets. Once you’ve got a bracket you like, share it with your league, your family, or your coworkers.App Skills is evolving with Copilot in Excel
We are continuing to streamline the ways people engage with Copilot in Excel, and we've heard your feedback that working across multiple Copilot entry points can feel fragmented. To address this, Copilot in Excel is transitioning toward a more unified experience so users can easily choose between conversational assistance and direct editing capabilities. As part of this effort, the editing capabilities that App Skills provided will be integrated into Copilot Chat and Agent Mode in Excel, which became generally available earlier this year. This update is part of our broader work to simplify the Copilot entry points and make it clearer how to interact with Copilot depending on the task. We know that when you find a workflow that works, change can feel disruptive. That's why we want to give you a clear picture of what's evolving in how you use Copilot in Excel and how these changes provide an even better experience. Why this change matters We've heard your feedback about wanting a more capable experience when working with Copilot inside the spreadsheet. The enhanced editing experience that Agent Mode introduced was built specifically to address this. It's designed to handle more complex requests, work across multiple steps, and give you greater control over how Copilot edits your workbooks. Rather than maintaining separate experiences that can feel fragmented, we're bringing everything together so you have: More power: Copilot with Agent Mode can now handle complex, multi-step reasoning tasks that go beyond what App Skills could do. Better clarity: You'll know exactly where to go depending on what you need—direct editing happens with Agent Mode; quick answers and simple actions work best in Copilot Chat. Continued innovation: By focusing on improvements toward a unified experience, we can deliver new capabilities faster. As part of this, we also plan to better integrate Agent Mode’s editing capabilities into the Copilot Chat experience in the coming months. What’s changing? App Skills entry points in Excel are going away. You will no longer find an App Skills button in the ribbon or be able to use App Skills from the context menu. Existing skills are consolidating into Copilot Chat and Agent Mode. When you want Copilot to make changes directly in your workbook, Agent Mode is designed to support many core editing tasks, such as creating or updating tables, applying formatting, or generating charts and PivotTables. Copilot Chat remains available for tasks that don’t require modifying content, such as interpretation or exploration of your data and using agents like Analyst. If you can open the App Skills chat pane and submit a prompt, you may receive an error message instead of a response. During this transition, some users may still see App Skills entry points for a short time. In some cases, opening the App Skills pane may result in an error message indicating that App Skills is no longer available. If this happens, you can continue your workflow using Agent Mode or Copilot Chat based on the type of assistance you need. When is it happening? This update is rolling out now. Depending on your Excel version, you may see the App Skills entry point up until the end of February. App Skill scenarios not yet available Certain scenarios that previously used App Skills—specifically the Advanced Analysis mode that used Python in Excel and advanced text analysis capabilities—are not yet available within Copilot Chat or Agent Mode. We are continuing to expand support for these capabilities in Copilot Chat and Agent Mode—watch for updates as these become available over time. Note: this was originally communicated to commercial customers via the M365 Message Center (MC1184407) on November 10, 2025.
Explain Formulas with Copilot—Now on the Grid
Understanding complex formulas in Excel just got a lot easier. The new Explain Formula feature turns Copilot into your inline assistant, delivering clear, step-by-step breakdowns directly on the grid, right next to your data, no need to switch context or open the chat pane. What makes this especially powerful is that the explanations are contextual, grounded in your actual data and workbook, not generic descriptions. By bringing the explanation to where you’re working, Copilot helps you stay in flow. It’s a seamless, in-the-moment experience that makes it easy to scan, understand, and act on formulas right where you need it most. How It Works Here’s how to get an explanation in just a few clicks: Select a cell with a valid formula A Copilot icon appears next to the cell Click “Explain this formula” from the dropdown Copilot shows a step-by-step explanation directly on the grid Need to dive deeper? Click “Chat with Copilot” to continue the conversation in the side pane Note: If the Copilot chat pane is already open, the explanation will be displayed there instead of on the grid. What It Does: Contextual Formula Explanations When you select a formula cell, Copilot can now explain what that formula does using a dedicated card shown in the grid. Helping you quickly understand what the formula does based on your actual data and context, not just a generic description. This makes it easy to: ✅ Understand the formula’s goal in your workbook ✅ Learn how it works, function by function ✅ Build confidence without ever leaving your sheet For example, given this formula: =I4 * XLOOKUP(H4, $L$4:$L$7, $M$4:$M$7) With just a click, Copilot will explain that: Because the explanation is tailored to your actual data and scenario, it’s faster to grasp, easier to verify, and more relevant to your work. Copilot provides the clarity you need right where you need it. Copilot Can Explain Any Excel formula No matter how simple or complex, Copilot can explain any Excel formula. Whether you're working with math, logic, references, arrays, or text manipulation, Copilot helps you understand what’s going on and why. Availability This feature is gradually rolling out to Excel for Windows and Excel for the web. Feedback We’d love to hear how this new experience is working for you. Let us know: ✔️ Was the explanation clear and easy to understand? ✔️ Was it easy to access the explanation when you needed it? ✔️ Did the overall experience feel intuitive and helpful? Just click the 👍 or 👎 at the bottom of the Copilot response to share your thoughts. Your feedback helps us refine the experience and prioritize what’s next.
