admin - TechyTools

Most Excel work is not typing formulas — it is moving around, selecting, copying, and formatting. The mouse does all

SUMIF in Excel: How to Use It with Examples

SUMIF adds up only the numbers that meet a condition you set. Instead of adding a whole column and then

INDEX and MATCH are two separate Excel formulas that become far more powerful together. Used as a pair, they do

A drop-down list is the simplest data-quality tool in Excel: instead of typing, the user picks from your list —

XLOOKUP is the modern replacement for VLOOKUP: it does the same job — find a value, return matching information —

Duplicate rows quietly ruin spreadsheets: mailing lists that send twice, stock counts that double up, sales totals that include the

“Printer in error state” is one of the least helpful messages Windows shows, because it is not one fault —

HP printers that produce blank pages are usually suffering from one of a few HP-specific causes: an empty or unrecognised

The printer runs, the paper feeds through, and the page comes out completely blank. Unlike a printer that will not

Google Sheets can do far more than store numbers in boxes — but only if you know a handful of