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.
Functions
Comparing two lists in Excel is one of the most common tasks in accounting, finance, and operations. Whether we need to confirm that every open invoice has been paid, find bank deposits missing from the books, or run a full two-way reconciliation, the right formulas turn a manual, error-prone process into a clean, dynamic exception…
Excel Copilot is a powerful assistant, but left to its own devices it tends to improvise. Sometimes that works great. Other times, not so much. The good news is that we can take control by setting up workbook-scoped rules and custom skills. Rules tell Copilot how to behave inside a specific workbook. Skills tell it…
This post is dedicated to the memory of Jeff Sharp, an active member of the Excel University community and a generous contributor who freely shared his knowledge with fellow Excel enthusiasts. Last year, he sent me this CUBE function example he built, suggesting it might make a good blog post. Jeff, this one’s for you.…
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…
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…
For CPAs and accounting professionals, Excel isn’t just a spreadsheet tool — it’s the engine behind financial reporting, month-end close, audit workpapers, and budget models. Mastering Excel directly improves the speed and accuracy of your work. And when that mastery comes through structured, qualifying coursework, it also satisfies your CPE requirements. Excel for CPAs CPE…
For accountants who rely on Excel daily, knowing when to use XLOOKUP versus VLOOKUP can save hours of rework and eliminate costly lookup errors. The short answer: XLOOKUP is the more powerful, flexible replacement for VLOOKUP in nearly every accounting scenario — but understanding why helps you use both tools with confidence. Here’s a practical…
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…