Adding a running total to a simple Microsoft Excel revenue sheet isn’t difficult, but adding a conditional running total will require a bit more effort. Solutions are simpler than you might think. The ...

At the sheet level, conditional running totals require focused expressions, but an Excel PivotTable requires only a few field swaps. Susan Harkins shows you how. An expression to return a simple ...

When your best-selling inventory is running low, but the next shipment is a month away by sea, relying on intuition for reordering leads to stockouts. By adding a 'Reorder Point' column to your Excel ...

Excel functions, or formulas, lie at the heart of the application’s deep well of capabilities. Today we’ll tackle IF statements, a string of commands that determine whether a condition is met or not.

Build formulas that remember what came before.