I recently saw a coworker type out a SUM formula in Excel to get a quick total, only to delete it a second later. When I showed him a pro shortcut hidden in plain sight, he realized he'd been wasting ...

BYROW replaces thousands of table formulas with one spill formula, making spreadsheets leaner and much more robust.