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.
Info
For accountants building financial reports in Excel, choosing between a PivotTable and a formula-based approach is one of the most consequential decisions you’ll make. The wrong choice creates reports that break on refresh, resist auditing, or require manual rework every month. The right choice depends on three factors: whether your output format is locked, how…
When you need to reconcile two lists in Excel — matching transactions, comparing account balances, or identifying exceptions — Power Query offers a more reliable and repeatable approach than manual VLOOKUP formulas. For CPAs and accountants who run the same reconciliation every month, Power Query turns a tedious, error-prone process into a structured, refreshable workflow.…
Excel remains the most widely used tool for financial reporting among CPAs and accountants — and when built correctly, an Excel-based financial report can pull updated data, recalculate automatically, and deliver consistent, audit-ready output every single period. The key is moving beyond static, manually updated spreadsheets toward structured, refreshable report models that reduce errors and…
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,…
Power Query is one of the most valuable tools a CPA or accountant can learn in Excel — and it’s still underused in most accounting departments. With Power Query, you can automate the repetitive data cleanup and transformation work that consumes hours every month-end close, replacing manual steps with a repeatable, one-click process that runs…