Excel University Blog
Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.
Copilot
One of the most powerful things we can do with Copilot in Excel is teach it our preferences once and have it follow them every time. Rather than spelling out formatting rules in every single prompt, we can set up standing personalization instructions that Copilot applies automatically. In this tutorial, we cover two approaches: global…
Multi-criteria lookups are one of the most common challenges Excel users face. Whether we need to find a single matching record, retrieve a full list of matching rows, or sum up values across multiple conditions, the approach changes depending on the goal. In this tutorial, we walk through three exercises that show how Copilot in…
Copilot in Excel can save a tremendous amount of time on routine finance tasks. In this tutorial, we walk through three exercises that show how Copilot can assign expense categories from a reference table, generate a formula-based summary, build a PivotTable report, and even write step-by-step documentation for future updates. If your team processes expense…
This tutorial shows how to use Microsoft 365 Copilot like a reusable macro in Excel. Instead of writing VBA or building Power Query solutions, we describe a list of tasks in plain language, paste that list into Copilot, and let it take action directly in our workbook. Video Tutorial We walk through three real-world exercises…
The best AI tools for accountants in Excel in 2026 are Microsoft Copilot (in three distinct flavors), the Claude by Anthropic Excel add-in, and Power Query’s AI-assisted features — but knowing which tool to use for which task is what separates efficient finance teams from overwhelmed ones. AI has changed how accountants interact with Excel,…
Have you ever opened an old workbook and stared at a formula packed with nested RIGHT, LEN, FIND, INDEX, and MATCH functions, wondering if there is a cleaner way? There is. Copilot in Excel can read those legacy formulas, figure out exactly what they do, and replace them with modern Excel functions that are easier…
Complex nested formulas can be intimidating. We have all opened a workbook and stared at a formula bar full of nested IFs, VLOOKUPs, and IFERRORs and had absolutely no idea what was going on. That is exactly the kind of situation where Copilot in Excel shines. In this tutorial, we walk through three exercises that…
Mapping credit card charges to GL accounts is one of those month-end tasks that is tedious enough once, and exponentially more painful every month after that. Raw credit card descriptions are cryptic, the volume is high, and the manual effort adds up fast. In this tutorial, we walk through three exercises that show how to…
Edit with Excel Copilot: Clean Data, Audit Formulas, and Create Pivot Tables If you’ve ever wished for an Excel helper that could quickly clean messy data, audit your formulas, or create robust pivot tables with a single prompt, you’re going to love Microsoft Copilot for Excel. Video Tutorial In today’s walkthrough, we’ll see how to…
Manually searching for currency exchange rates is a thing of the past. With Excel’s smart integrations, we can now pull real-time foreign exchange data into our workbooks using built-in features and free web APIs. Whether we are looking up current rates or building a currency converter, Excel has all the tools we need to get…