Most "Office productivity" content is the same five Excel formula tips repeated forever. This is different: the tools below remove entire categories of tedium from a knowledge worker's day, not just individual cell tasks.
The unsung hero — clipboard productivity
If you copy and paste more than ten times a day (you do), a clipboard manager is the highest-leverage tool you can install. LionPaste on macOS gives you unlimited history, regex search, snippets, paste-queue FIFO, and 11 text transforms (URL encode/decode, JSON pretty/minify, case conversion, sort lines, remove duplicates) without ever leaving the keyboard. Full deep dive.
Calculator with memory
Everyone uses a calculator. Almost no one uses one that remembers what they did 30 seconds ago. CalculatorX adds a permanent history tape, Indian-style lakhs/crores grouping, GST calculations, and 13 themes — all free. Switching to it adds maybe one productivity percentage point per day, but it adds up. Why we recommend it.
What to learn before reaching for tools
INDEX/MATCH(orXLOOKUPif your version supports it). VLOOKUP is fine but limited.- Real pivot tables. Most "complicated formulas" in business spreadsheets are pivots that nobody wrote as pivots.
- Named ranges. Nothing else cleans up a sheet faster.
- Keyboard shortcuts for your single most-used 5 actions. The rest will follow.
The principle behind these picks
The compound-interest tools win. A clipboard manager saves seconds per use, hundreds of times a day. A better calculator saves you the mental tax of remembering numbers. Neither shows up on a productivity report — but both quietly add an hour to every week.
Browse the related catalogs
See Excel plugins, Google Sheets add-ons, and desktop utilities on LionScripts.
