Excel Dynamic Arrays: FILTER, SORT, UNIQUE, SEQUENCE & Spill Ranges

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.

• Let one formula fill a whole column for Lumen Tea Co., fix a #SPILL! error by clearing the cells in its way, spill an array calculation and total it with a spill reference.
• Sort Lumen's customer list by revenue, by region and revenue at once, by a key that is not in the output (average order value) and by a custom region order.
• Extract Lumen's orders for one region, then combine conditions with AND (*) and OR (+), and show a friendly message when nothing matches.
• Pull the distinct customers and teas from Lumen's order lines, count the customers with ROWS(UNIQUE()) and find the customers who ordered only once.
• Generate lot numbers, a weekly delivery schedule, month-end invoice dates and a Monday-first calendar grid, each with one formula driven by the settings cells.
• Build a region summary from one UNIQUE list: SUMIFS over E2#, shares over F2#, and the top region with XLOOKUP, so new regions appear without editing a single formula.
• Stack October and November orders into one table, pick columns for a short report, extract the top three orders and build a one-row summary.
• Build Lumen's Q4 top-N panel: one TAKE(SORT()) formula driven by N in E1, a share column, the top-N share of revenue and a bar chart of the leaders.