Combining Tables in Excel: VSTACK, HSTACK, Lookups, GROUPBY & Reconciliation

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Stack the North, South and West order exports into one live table with a single header row, then count, total and query the combined table.
• Stack the September and October files and tag every row with its month, then summarise orders and revenue by month from the combined table.
• Enrich the combined order lines with the customer's region and the unit price from two master tables, compute revenue and find the revenue that has no matching customer.
• Compare the web-shop order list with the invoices in accounting, flag the records missing on either side, list them with FILTER and total the missing amount.
• Remove exact duplicate rows from a stacked export, count distinct orders and find the order that exists in two different versions.
• Summarise the combined orders by region with GROUPBY, show each region's share with PERCENTOF, rank categories by average order and rebuild the summary with UNIQUE + SUMIFS for older Excel.
• Rebuild the CRM total per region from the order lines, compare it with the finance ledger, set a Match/Check status with a tolerance and colour the rows that need a look.
• Combine three monthly files whose regions are in different orders into one Q3 table with lookups and a spilling XLOOKUP, total it and chart revenue by region and month.