Five Excel habits to drop tonight: merged cells, blank rows, hand-applied colors, hard-coded rates, one crowded sheet

Unmerge first Complete records replace merged cells and blank rows, conditional formatting replaces hand-applied color, changeable values move into their own referenced cells, and one file becomes three tabs for source, logic, and report.

One cell, one formula MAP works across matching arrays, BYROW and BYCOL handle a whole row or column at once, SCAN keeps every running subtotal, and REDUCE returns only the final accumulated answer.

Four swaps, one evening Everything reads the Master File Table for fast file lookup, Files adds dual panes and file tagging, AppControl keeps three days of performance history, and PowerToys Command Palette stands in for the Start menu.

Stop the prefetching Preload pages, under Settings then Privacy and security, keeps guessing which links you will tap and holding the radio awake, and Android Police puts switching it off at roughly 1.5 to 2 hours of extra daily battery for heavy browsers, at the cost of slower page loads.

Guests optional Smart devices get internet without a path to your files, but isolation is two separate switches, so try reaching your home server from the guest side before you trust it.