502 tips · new ones added continuously
Every tip is one concrete thing you will do better or faster. Filter by what you use and who you are — or just search.
The newer replacement for VLOOKUP searches in either direction, doesn't break when a column gets inserted, and has a built-in “not found” fallback.
Duplicate values, overdue deadlines, or below-average results highlight themselves — you just define the rule.
Ctrl+E
Type one example into the next column (say, a name pulled from an email address) and Ctrl+E fills in the rest to match. No formulas.
Ctrl+T
Ctrl+T turns a range into a “smart” table — automatic filters, formatting for new rows, and readable formulas.
“Do not disturb until 12:00” tells coworkers more than a permanent red dot — and it turns itself off.
Shift+Enter
Enter sends a Teams message right away. Shift+Enter starts a new line, and the formatting button opens the full editor.
An empty calendar is an invitation to meetings. Block off your mornings for deep work before someone else does it for you.
F4
One key, two superpowers — repeating your last action and toggling dollar signs in a formula.
Ctrl+↓
Don't scroll through a sheet with thousands of rows. Ctrl+arrow jumps to the end of the block, and with Shift it selects as it goes.
The Activity feed can show only messages where someone mentioned you. Everything else is mostly noise.
Ctrl+Shift+M
Ctrl+Shift+M toggles your mic, Ctrl+Shift+O toggles your camera. When it's suddenly your turn to talk, you're not hunting for a button.
Ctrl+E
The search bar at the top finds people, messages, and files — and a slash launches commands.
↑
Typo in a message you just sent? Press the up arrow and you're editing right away — no hunting through menus.
Split your sidebar into sections — Projects, Team, Noise. Channels you don't need to see get collapsed.
A threaded reply keeps a discussion together and doesn't flood the channel. A team that threads has half the noise.
The bookmark icon on a message adds it to Later — your personal list of things to come back to.
A notification schedule automatically quiets Slack outside working hours. It leaves you alone in the evening — and shows colleagues when you're reachable.
Operators narrow a search to a specific person, channel, and time period — instead of scrolling through history.
Backticks turn text into code, three of them make a code block. A readable message saves time on both ends.
“Remind me about this” brings a message back at a time you choose. Slack stops being the place where tasks get lost.
Ctrl+K
The quick switcher finds a channel, a message, or a person in a few keystrokes. Slack's single most important shortcut.
A category like “Waiting on reply” or “Client A” colors emails across folders — and you find them with one click.
Anything that takes less than two minutes, do right when you read it. Longer things go to your task list — and archive the email.
Constantly checking your inbox shreds your focus into pieces. Three fixed blocks a day are enough for 95% of jobs.
Even in Outlook, an email can wait until Monday morning. The new version has Schedule Send right next to the Send button.
Ctrl+R
Ctrl+R replies, Ctrl+Enter sends, Ctrl+1/2/3 switches between mail, calendar, and people.
A Quick Step can move a message, mark it read, and forward it all at once. Turn a repeated sequence into a single button.
Automatic rules move system notifications, reports, and CCs into folders — your inbox stays reserved for messages that actually need you.
In Outlook, drag a message onto the calendar icon — it creates an event with the email's text inside. No more retyping.