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.
Month End
Pivot tables are great, but they do not always produce the exact report layout that corporate requires. When the format is locked in and a pivot table simply will not fit, we turn to formulas. In this tutorial, we walk through three exercises that show how to use the SUMIFS function to build formula-based reports…
Month-end reporting often means the same tasks, repeated every single month. We pull data from a CSV, clean it up, build a summary, and maybe add a chart. If we are doing all of that manually, we are leaving a lot of time on the table. In this tutorial, we cover a three-exercise workflow that…
What if every new journal entry posted in QuickBooks Online landed in an Excel table automatically, no copy-paste required? In this tutorial we walk through exactly that workflow. We use Zapier to connect QuickBooks Online to an Excel workbook stored in OneDrive, loop through each journal entry line so it lands on its own row,…
Month-end reconciliations are a fact of life for anyone managing financial data. Whether we are comparing Shopify orders against QuickBooks invoices, matching a bank statement to a check register, or verifying inventory counts, the core task is always the same: take two lists and find what does not match. In this tutorial, we walk through…