Excel Blog

Each red row names a depot and machine the rate card does not have

Planned finishes count weekends: Mon 16 Mar is really Fri 20 Mar

XLOOKUP on the lane alone returned the standard rate, not next day

One Rebate, Reported Eight Ways From the Same 46 Invoices

One Column of Site Codes, Counted Eight Ways

Ten Cells From One Replace All, and the Four of Them It Could Not Reach

Eight Lines Out of 1,840, and the Only Thing That Changed Was the Number Format

Sixteen References, Fourteen Keys, One Reconciled Total

One Summary Column, Twenty Sheets, Three Outcomes

The Import: Sixteen Remittances, Four Country Prefixes, and a Key That Is Not in a Column of Its Own

The Orders Table: Fourteen Rows, One Customer Key, and No Region Anywhere In It

A Q3 Rep Sheet With Its Region Column Merged — Shown As the File Actually Stores It

One Month of Branch Sales, With Every Kind of Nothing a Cell Can Hold

A Group Summary Tab, Where Every Number Was Typed by a Formula Pointing Somewhere Else

Aged Receivables, in the Order the Accounting System Exported Them

July Sales Ledger Beside the Bank Export, Fourteen Rows Each

The Summary Tab of a Workbook With Twelve Monthly Sheets Behind It

A One-Product Monthly Model, and an Empty Grid Beside It

A Distributor's Order, With the Assumptions Stacked Beside It

Wholesale Orders, One Quarter

Sales Pipeline by Rep

Sales Data for Conditional Formatting

Sample Sales Data for Your First Dashboard

Common Excel Formulas Example