For your profession · 247 tips
For solo professionals who are the production line, the sales team and the back office at once. Proposals, invoicing, client comms and time planning that still leaves room for billable work.
Recommended start
Three in-depth guides that cover most of what eats your day. The rest gets easy after that.
A complete guide with prompts: Beeper unifies WhatsApp, Messenger, and Slack into one app, and Claude pulls promises and deadlines out of them via MCP on a regular schedule and writes them into Notion. Includes a patient introduction to the terminal for anyone who's never opened one.
AI · 23 minAn explainer with prompts: what it means to let AI run in a loop, what's true in the hype, what's overblown, and how to safely try your first loop.
AI · 15 minA guide with prompts: why a chatbot silently gets math wrong, how a persistent DuckDB skill lets you query CSV or Excel in plain words — and check results.
AI · 27 minEverything for you
Filter by category or platform, or just search — the list below is already narrowed down to your profession.
Other professions
One tip a week
I send one usable tip a week. Two minutes to read, hours saved.
1 tip a week · no spam · unsubscribe in one click
In-depth guide · 23 min
A complete guide with prompts: Beeper unifies WhatsApp, Messenger, and Slack into one app, and Claude pulls promises and deadlines out of them via MCP on a regular schedule and writes them into Notion. Includes a patient introduction to the terminal for anyone who's never opened one.
In-depth guide · 15 min
An explainer with prompts: what it means to let AI run in a loop, what's true in the hype, what's overblown, and how to safely try your first loop.
In-depth guide · 27 min
A guide with prompts: why a chatbot silently gets math wrong, how a persistent DuckDB skill lets you query CSV or Excel in plain words — and check results.
In-depth guide · 27 min
A complete guide with prompts: how connectors get added, what Buffer, Canva, Notion, or Supabase can really do — and two honest ways to bring in Gemini.
In-depth guide · 24 min
A guide with seventeen prompts: the Meta Ads connector, the official Google Analytics MCP server, both sides combined into one picture — and clear limits.
In-depth guide · 23 min
A guide with prompts: why the agent writes a different script every time, when to move from chat to a file, scheduled runs, and catching silent breaks.
In-depth guide · 26 min
A guide with prompts: a website without hiring a developer — from scaffolding through git as a safety net to a domain and Vercel. Proven on this site.
In-depth guide · 21 min
A complete guide with prompts: the anatomy of a music brief, the path from variants to a final track, and a sober look at the licensing reality most skip.
In-depth guide · 20 min
A guide with prompts: how a plain description becomes a working calculator, quiz, or prototype, refining and sharing it — and when you need a real app.
In-depth guide · 19 min
Seven criteria, three tools, no marketing: language quality, documents, connectors, routines, and pricing. Plus a decision guide and a test of your pick.
In-depth guide · 20 min
A complete guide with prompts: from the first mail and calendar connection through one simple routine to the set of four that holds a day together.
In-depth guide · 19 min
A guide with prompts: break down the listing, reframe your experience without inventing, pass the ATS, and a cover letter that won't repeat your CV.
In-depth guide · 18 min
A complete guide with prompts: phrasing the research question, a brief that returns a usable report, critical reading of the result, and five use cases.
In-depth guide · 20 min
A complete guide with prompts: connect AI to Notion or a notes folder, ask questions in your own words, and have the archive fill itself in every week.
In-depth guide · 18 min
A guide with prompts: turning finished text into listenable audio — preparing the text for the ear, choosing a voice, and hard voice-cloning rules.
In-depth guide · 21 min
A complete guide with prompts: one visual identity, one command — a style prompt, an AI-written script, batch generation, WebP compression, a safe API key.
In-depth guide · 21 min
A complete guide with prompts: set up the other side's role, run the rehearsal for real, and handle six of the toughest talks — from a raise to a layoff.
In-depth guide · 17 min
A complete guide with prompts: a lead magnet people want, a welcome sequence, drafts in your voice, deliverability, and GDPR consent — with a case study.
In-depth guide · 16 min
A complete guide with prompts: break a pillar topic into posts, a newsletter, and a video script, lock in your brand voice, and keep a human on publish.
In-depth guide · 21 min
A guide with prompts: a bank export, anonymization, transaction categories, forgotten subscriptions uncovered, and a ten-minute routine that sticks.
In-depth guide · 19 min
A complete guide with prompts: campaign structure from goal to format, personas from real data, seven copy angles for A/B tests, and reading an export.
In-depth guide · 19 min
A guide with prompts: nail down your criteria, search with citations, build a comparison table, and pull complaints from reviews. Services save most.
In-depth guide · 16 min
A complete guide with prompts: have a year of sent mail analyzed, find the recurring types, and pull templates in your own words — time savings measured.
In-depth guide · 21 min
A complete guide with prompts: from seed phrases through clusters and search intent to a content brief, writing without SEO spam, and the era of AI search.
In-depth guide · 22 min
A complete guide with prompts for five contract types: anonymization, clause-citing risk analysis, and questions for the other party. Know what you sign.
In-depth guide · 17 min
A complete guide with prompts: content pillars and brand voice, a monthly plan, batch-produced posts for LinkedIn, Instagram, and X, and a monthly review.
In-depth guide · 18 min
An honest comparison of the three most popular task managers across ten criteria. Plus a table, a pick for your situation, and a lossless migration guide.
In-depth guide · 17 min
A guide with 13 prompts: Claude Cowork pulls contacts and notes from scanned cards, prepares a CSV for your CRM, and drafts follow-ups. A human sends them.
In-depth guide · 18 min
A guide with prompts: a style description from your own writing, a living brand book in a Project, one-prompt consistency checks, quarterly reviews.
In-depth guide · 18 min
A complete guide with prompts: a routine finds unanswered threads, tracks deadlines, and drafts polite reminders. AI writes the draft — you always send.
In-depth guide · 18 min
A complete guide with prompts: write your priority rules in plain language, connect Google Calendar, and let AI watch collisions and plan time blocks.
In-depth guide · 16 min
A guide with prompts: action-based categories, an escalation rule so the boss's mail never vanishes, and a weekly audit. Move and label — never delete.
In-depth guide · 18 min
A complete guide with prompts: connect calendar, tasks, and mail, let AI build a Friday review and three priorities for next week. Decisions stay yours.
In-depth guide · 19 min
A guide with prompts: when a Claude routine is enough and when you need n8n, Zapier, or Make, three full scenarios step by step, and error handling.
In-depth guide · 19 min
A complete guide with prompts: connect your mail, write rules in plain language, and cut morning email to fifteen minutes. AI drafts — only a human sends.
In-depth guide · 21 min
A guide with prompts: the routine tells a promise from a pleasantry, sweeps mail and meetings each evening — five minutes to approve. A human confirms.
In-depth guide · 19 min
A guide with prompts: why a language model must not do the math in chat, how to turn a table into a script that recalculates, and how not to overreach.
In-depth guide · 19 min
A complete guide with prompts: how to dictate a usable transcript, tidy it into an email or notes with one prompt, and turn commutes into writing time.
In-depth guide · 20 min
A complete guide with prompts: where to keep a library, how to version and improve prompts, how to share them in a team — and ten every library needs.
In-depth guide · 17 min
A complete guide with prompts for hard critique: untraining AI from agreeing with you, decision premortems, red-teaming a proposal — and when to ignore it.
In-depth guide · 17 min
A guide with prompts: research the other side in twenty minutes, build arguments and a walk-away point, rehearse the hardest part, and get a one-pager.
In-depth guide · 18 min
A complete guide with copy-paste prompts: how to pick a tool, what to type into the first empty box, and telling a good answer from plausible nonsense.
In-depth guide · 14 min
A complete guide with prompts: describe a formula in plain words and get a working fix, debug errors, design a table that holds, and when to use a macro.
In-depth guide · 19 min
A complete guide with prompts: when talking to AI beats typing, how to run a conversation that resolves something, and where voice mode hits hard limits.
In-depth guide · 20 min
A complete guide with prompts: what to upload to a Project, how to write its instructions, when to start a new one, and maintenance so it doesn't lie.
In-depth guide · 23 min
A complete guide with prompts: get a script written and explained, run it safely on a copy of your data, and build a tool library — without writing code.
In-depth guide · 17 min
A complete guide to standing instructions: what belongs in them, how they differ from a Project, testing them — and ready sets for common professions.
In-depth guide · 19 min
A complete guide with prompts: phrases for sharpening, narrowing, and shifting tone, variants instead of guessing, and when to scrap a chat and restart.
In-depth guide · 18 min
A guide with prompts: steering translation with your own samples, translation versus localization, back-translation checks, and glossary workflows.
In-depth guide · 17 min
A complete guide with prompts: why one example beats a thousand words of instructions, when one or three, ready templates, and your own style bank.
In-depth guide · 15 min
A guide with prompts: the brief method for a one-minute draft, ready asks for the hardest email types, teaching AI your voice, and a pre-send check.
Type 154*1.21 into the address bar and the result shows up right in the suggestions — no Enter, no opening a calculator.
Before you publish, have AI fix only the typography: smart quotes, dashes instead of hyphens, spacing around numbers and units. It leaves the wording alone.
Instead of trawling ten-year-old forum threads, paste the error message — or a screenshot of it — into AI and ask three things: what it means, what to do, and what not to do.
An email typed on the wrong keyboard layout or an export from an old system: paste the text into AI and get it back with the accents in the right place. It works in reverse too.
AI loves to improve your style, even when nobody asked it to. Tell it to fix only spelling and punctuation and list the changes — your voice stays yours.
Attendance against sign-ups, payments against orders: paste two lists and AI lists what's in one and missing from the other — even through typos.
Describe in plain words what you want to match, and AI returns a regular expression with a part-by-part explanation and test cases. For Sheets, editors, and bulk edits.
A forwarded conversation, “see below,” and thirty emails of history. Drop the thread into AI and ask: who's claiming what, where's the agreement, and what are you supposed to do.
You know the meaning but not the word? Describe it to AI and get ten candidates with the shades of difference between them. Works for technical terms and cliché-free synonyms too.
Copying a table out of a PDF turns the columns into one tangled noodle of text. Upload the PDF to AI, ask for CSV — and check the control total.
Paste an official letter into AI and get four answers: what they want from you, by when, what happens if you don't, and exactly what to do. No legalese, no panic.
Gaps in your prompt get silently filled with the model's own assumptions. Have them listed out — see what the answer is standing on before you build work on top of it.
The Gboard keyboard remembers what you last copied, and you can pin important items permanently. Just turn it on.
AirDrop's counterpart is built into every newer Android phone — and with a free app from Google it sends photos and files to Windows too.
You don't have to painfully recall every subscription you're paying for — searching payment confirmations in your inbox plus two system screens puts the list together in ten minutes.
Ctrl+Shift+S
Edge and Firefox capture an entire web page from header to footer with a single command. No extensions, no stitching pieces together.
Don't upload a corrected PDF as another file. Manage versions swaps it out under the same link — for everyone who has it.
Put the meeting window on the monitor with the camera, notes and materials on the other. You look people in the eye, never share anything private, and minutes write themselves.
“You froze” usually doesn't mean slow internet — it means unstable Wi-Fi. An Ethernet cable is the single most reliable upgrade for calls.
Alt+;
Copying a table with hidden rows and they paste in too? Alt+; selects only the visible cells — the hidden ones stay home.
Switching back and forth between the sheet with source data and the sheet with results? View → New Window shows both at once.
Ctrl+click on sheet tabs groups them — and whatever you type into one gets written into all of them. Fix twelve monthly sheets in one move.
A hidden Gmail setting adds a second button to Reply that sends the email and tidies the conversation out of your inbox in one move. One click instead of two.
Gmail can forward an email as an .eml attachment — even ten messages at once. The recipient gets the originals, headers and all, not a mangled copy.
Gmail turns an open email into a Calendar event in three clicks — with the subject as the title and a link back to the conversation.
A password your browser once saved can be revealed anytime — uncovering a login you thought was lost for good.
Newer iPhones have a programmable button above the volume controls. Voice memo, flashlight, camera, or a custom shortcut with one press-and-hold.
The iPhone has gestures for working with text: a three-finger pinch copies, a spread pastes, and a swipe left undoes the last action.
A cable that falls behind the desk every time you unplug it is a daily micro-frustration. An office clip and a few reusable cable ties end it for good.
Google Calendar and Outlook can both show a second time axis next to your own. Plan a meeting across time zones by looking, not by doing math in your head.
C
One letter instead of clicking: C for a new event, T for today, D/W/M to switch views, J and K to page through. A question mark shows every shortcut.
Send a link, the other person picks an open slot themselves, and the meeting lands on both calendars. A built-in Google Calendar feature almost nobody knows about.
A laptop sitting on the desk shoots your chin and the ceiling from below, and a window behind you turns you into a silhouette. Camera height and light direction fix more than a new webcam ever will.
A laptop permanently docked at 100% is wrecking its battery. Almost every manufacturer has a hidden option that stops charging earlier — and multiplies the battery's lifespan.
You don't have to click your way through a Save dialog: drag a folder or file from Finder into it and the dialog jumps straight to that spot.
Select photos, right-click, Create PDF — done. Finder's Quick Actions can even convert formats or remove a background without opening an editor.
Does an invoice belong in the project folder and in accounting? Tags solve the age-old dilemma of where to save a file — it can show up in more than one place at once.
Finish an email you started on the tram, on your Mac, exactly where you left off. Handoff passes work in progress between your devices automatically.
Cmd+Shift+/
Not sure where an app hides a certain feature? This shortcut opens menu search, finds the command by name, and points an arrow at where it lives.
Your Mac sees your iPhone's hotspot right in the Wi-Fi menu, even when it's off on the phone. One click and you're online — no touching your phone.
Your Mac's built-in camera is mediocre. Just set your iPhone near the monitor and the Mac offers it as a webcam — wirelessly, with nothing to install.
Cmd
The icons in your Mac's menu bar aren't nailed down — hold Cmd and drag them elsewhere, or drag one downward to remove it entirely.
Drag a document you have open straight into an email or chat using the small icon in the window's title bar — no hunting for the file in Finder.
You might already own a second monitor — your iPad. Sidecar turns it into a wireless Mac display in two clicks, even on the road.
A verification text arrives and Safari on your Mac offers it right in the field to fill in — the phone stays in your pocket. Just turn on message forwarding.
A hidden option in Accessibility changes how you use the trackpad — drag windows and files with a light three-finger touch, no holding down and no thumb fatigue.
Move the cursor past the edge of your Mac's screen — and it shows up on the iPad. One keyboard, one mouse, two devices, zero setup.
Build your own Quick Action in the Shortcuts app in five minutes — select photos, right-click, and they're the right size for email.
On iPhone, slide your finger off the 123 key onto a digit and the keyboard snaps back to letters by itself. Gboard has a key hold or a permanent number row.
Tap the space bar twice at the end of a sentence — your phone inserts a period and a space, then capitalizes the next sentence. iPhone and Android.
Google Messages sends a text at a scheduled time when you hold down the send button. iPhone does the same in iMessage via Send Later.
A long press on an icon opens a shortcut menu: new email, selfie, private tab, navigate home. One tap instead of hunting inside the app.
You can't scan a code on your own screen with the camera. But you can hold your finger on it in Photos, or open it through Google Lens.
iPhone offers to share the password automatically as soon as someone nearby tries to connect. Android generates a QR code that scans and connects.
Android can trigger battery saver by percentage. iPhone has no built-in schedule — but a Shortcuts automation turns on Low Power Mode entirely on its own.
Stop retyping details off paper. iPhone can scan text with the camera directly into a text field; Android does the same through Google Lens.
No need to dig through settings: swiping on a notification on iPhone offers an hour of silence; holding one on Android turns off just the annoying category.
A monitor rotated 90° shows a full document page, a long email, or code without endless scrolling. Windows and Mac both handle it right in settings.
Default pointer and scroll-wheel speed is tuned for monitors from a decade ago. Two sliders save hundreds of arm movements a day.
Most people sit in their chair exactly as it arrived from the store. Three checkpoints — elbows at desk height, knees at a right angle, feet on the floor — take a minute to fix.
With an external monitor and keyboard, a laptop can run closed and save desk space. Just change one setting for what closing the lid does.
Word, Excel, and PowerPoint quietly save copies of your work as you go. File → Info → Manage Document recovers even files you never saved.
Before a meeting or a coworker pulls you away, write one sentence: what you're doing and what the next step is. Coming back then takes seconds, not a quarter hour.
Chrome, Edge, and Firefox can all fill in a PDF form directly. And when the form has no fillable fields, Edge and Firefox just let you type the text straight onto it.
Highlighting and annotating a PDF is handled by the free Acrobat Reader, Edge, and Preview on Mac. Feedback belongs in the file, not in a five-paragraph email.
A contract, an attachment, and a scanned addendum, all in one file: Preview handles it on a Mac, free PDF24 on Windows — just don't upload sensitive documents anywhere.
Need to send three pages out of a fifty-page PDF? Print the range “12-14” to PDF and the new file is born. No installing anything.
A work laptop and your own computer on one desk doesn't have to mean two keyboards. A USB switch flips between them with a single button.
For subscriptions through the App Store or Google Play, you can cancel the trial a minute after activating it: it still runs to the end, and nothing gets charged. Elsewhere, a reminder does the job.
Holding an arrow key or Backspace repeats at a speed you can configure. Two sliders almost nobody ever touches — and typing instantly feels snappier.
Space
Stay muted for the whole meeting. When you want to say something, hold the key, talk, release — and the microphone mutes itself again.
Sharing your full desktop shows colleagues your notifications and half-typed messages too. Sharing one window shows only what you meant to show.
One function pulls data from another spreadsheet into yours — and keeps it current. No more manually copying numbers between files.
Shift+Delete
Does your browser keep offering a typo or an old site? Select the suggestion with the arrow key and press Shift+Delete — it's gone for good.
Slack and Teams can both send a message later — an arrow next to the send button, or a right-click. Write the idea down now, don't disturb your colleague.
Colleagues will forgive a grainy picture, but not a booming mic sound from across the room. A mic near your mouth is the cheapest meeting upgrade there is.
A site won't log you in, or it's stuck in a loop? Don't clear your whole history. Cookies can be wiped for just that one troublesome site.
You don't have to email links to yourself. Chrome generates a QR code for a page, and Chrome and Firefox can both send a tab straight to your phone.
A phone's camera puts the built-in webcam in its pocket. Windows 11 can connect it wirelessly as a regular camera for Teams and Meet alike.
A banking-app alert for every charge catches a forgotten subscription or a compromised card in the minute it happens — not a month later on a statement.
Zoom and Teams can filter out barking, keyboard clatter, and next-door drilling. Just switch noise suppression to high in your audio settings.
Because of Fast Startup, shutting down Windows isn't a clean stop — the system tucks part of its state away. When the PC misbehaves, only Restart helps.
Gmail, your calendar, or Teams can run in their own window with an icon on the taskbar — no address bar and no risk of an accidentally closed tab.
The “This site wants to show notifications” popup can be switched off globally with one toggle. Sites stop asking — and you stop dismissing them.
Asterisks around a word make it bold, underscores make it italic, a dash makes a bullet. A longer work message suddenly looks like a document.
Tapping 1× switches a voice message to 1.5× and 2× — a three-minute monologue takes half the time. And you can listen to your own recording before it sends.
Long-press a message and pin it to the top of the chat — for 24 hours, a week, or a month. A meetup address or a door code never gets buried again.
A conversation with yourself in WhatsApp is a notebook and a bridge between phone and computer — links, photos, and files, no cable and no emailing yourself.
Hold Alt and drag with the mouse — Word selects a rectangle of text across lines. Perfect for deleting a column of characters that a normal selection can't grab.
Teach Word that “dph” means “value added tax.” AutoCorrect can expand your own custom shortcuts across every Office app.
Ctrl+Shift+8
The ¶ button reveals spaces, tabs, and page breaks. Suddenly you can see exactly why text jumps where it shouldn't — and what to delete.
Word and Google Docs can both compare two versions of a file and highlight every difference. No more reading contracts line by line.
Shift+F5
Open a document and Word dumps you at the start. Shift+F5 jumps exactly to where you last stopped writing.
Type docs.new or sheets.new into your browser — and a new document opens right away. word.new and excel.new from Microsoft work too.
Windows and Mac both have automatic backup built in — all they need is a drive. Hourly file versions, and a deleted file back in two clicks.
Clicking a running app's taskbar icon just brings it to the front. Shift+click opens a new window, Ctrl+Shift+click launches it as admin — three tricks in one icon.
Win+Ctrl+T
Keep a calculator, notes, or a call always in view: Win+Ctrl+T from PowerToys keeps the selected window above everything else until you unpin it.
Ctrl+Space
What's in that file? Peek from PowerToys shows the contents of a selected file on Ctrl+Space — no waiting for Word, a photo viewer, or a PDF reader to launch.
Replace text across all filenames, add a date, number them. PowerRename from PowerToys renames whole batches at once — with a preview before anything actually happens.
F2
Renaming without a mouse: F2 opens the name for editing, Tab saves it and skips to the next file. Select several files, and they all get renamed at once.
Win+V
Windows can remember everything you copy. Just press Win+V instead of Ctrl+V.
Win+←
Dragging windows with the mouse is slow. Win + arrows snap windows into halves and quarters of the screen.
Win+1
Open apps pinned to the taskbar by their position number. No more hunting with the mouse.
Ctrl+Backspace
Ctrl + Backspace deletes the whole word to the left, Ctrl + Delete the whole word to the right. Typos disappear in one go.
Alt+Tab
The most famous shortcut, and most people only use half of it. Hold Alt and cycle through.
Win+H
Win + H on Windows, or the microphone on your phone's keyboard. Dictate a first draft of an email in a third of the time.
In the car, on a walk, with your hands full of groceries: “Hey Siri, add…” and the thought is in the system.
Ctrl+Shift+K
Ctrl+Shift+K and the article is in your library, tags included. No more bookmarks you'll never find again.
(Impact × Urgency) / Effort — three numbers per task, and the database sorts itself by actual value.
The query (p1 | p2) & due:today shows only what actually matters today. You don't see the rest — and that's the point.
“every Monday at 10 #meetings p1” — Todoist picks up the date, recurrence, project, and priority straight from the text.
Lights, do-not-disturb, a timer, and music with a single command. A ritual that tells your brain “it's work time now.”
The trick isn't standing all day — it's alternating positions, plus a bit of movement that fits into your work without interrupting it.
A receipt, a contract, a meeting note: snap it with a scanning app, the text gets recognized, the paper goes in the bin.
A sunrise alarm clock and smart bulbs set your circadian rhythm better than willpower ever could.
ANC headphones solve two problems at once: ambient noise, and coworkers who can't tell you don't want to be disturbed.
Client onboarding, publishing an article, the monthly close — a repeated process without a checklist means forgetting something, every time.
Monitor, keyboard, network, charging — all through a single USB-C cable. Connecting your laptop stops being a five-minute ritual.
One charger stays at your desk, a second one lives permanently in your bag. A few bucks buys the end of endless repacking and forgetting.
A neck that hurts from a monitor set too low. A stand or arm for a few dollars fixes years of discomfort.
Switching between types of work costs energy. Grouping similar tasks into blocks saves dozens of minutes a day.
Five minutes at the end of work: write down loose ends, glance at tomorrow, close the laptop. Work stays at work — even in your head.
A task with no time attached is just a wish. Drag your tasks into concrete calendar slots — and give your day a budget, like money.
Not a list of twenty items, but three things that absolutely must get done today. Everything else is a bonus.
On Friday or Sunday, go through your calendar, tasks, and notes — close out loose ends, plan three priorities. Monday starts with clarity.
A reply within 24 hours is the professional standard. A reply within 5 minutes is a bar you can never lower again.
Ninety minutes on Friday for all your admin at once — instead of scattered nagging all week long.
Every proposal written from scratch is an hour of lost time. A template with marked spots to fill in cuts it to ten minutes.
Submit by your own D−2 deadline. You get a buffer for review, printer trouble, illness — and a calm night's sleep.
The Notes app can scan documents — straightened, cropped, multi-page PDF. No other app needed.
The Shortcuts app can do automations: arriving at the office turns on Do Not Disturb, opening Instagram starts a timer.
Apps like Cold Turkey or Freedom block chosen websites for a set period. Decide once, and it holds for the whole morning.
Ideas and tasks drop into your Inbox without a second thought about where they belong. Once a day, you empty it — into projects, or into the trash.
Q
Type “p1” and the task turns red, “tomorrow 9am” and it gets a due date. Quick Add understands it all in one line.
A week with a time tracker (Toggl and similar) reveals the gap between what you think you do and reality. It's usually a shock — and the start of a change.
/
The / key opens the block menu — headings, tables, reminders, columns. Notion's core control.
Ctrl+P
Quick search finds a page by title and by content. In a growing workspace, it's the only navigation that makes sense.
Ctrl+H
Ctrl+H can also replace formatting, double spaces, and paragraph marks. Cleaning up a whole document in a few clicks.
Data separated by commas or semicolons crammed into one column? The Text to Columns wizard splits it correctly.
A filter view filters data just for you — everyone else in the shared sheet sees everything unchanged.
Ctrl+Alt+Shift+H
Google Sheets and Docs save every single change. Ctrl+Alt+Shift+H opens a timeline — and you can revert to any point.
Insert → Checkbox turns a range of cells into an interactive list — and you can attach formatting and formulas to it.
Alt+=
Cursor below a column of numbers, Alt+equals — and SUM is done, range and all.
A revenue summary by month and category out of thousands of rows? Insert → PivotTable, then drag three fields.
Ctrl+PageDown
Move between the sheets of a workbook from the keyboard — no clicking the tabs at the bottom.
Select the cells and look down at the status bar — the sum, average, and count are always right there.
Ctrl+Alt+V
Ctrl+Alt+V opens Paste Special — paste results without formulas, formats without content, or transpose a table.
Alt+Enter
Enter jumps to the next cell — Alt+Enter creates a line break inside the same one. No more broken layouts.
Ctrl+;
Ctrl+semicolon inserts today's date as a fixed value — unlike the TODAY() function, it doesn't change.
Data → Remove Duplicates cleans up a list of contacts or line items — and tells you how many it deleted.
Data validation turns a cell into a menu of allowed values. Task statuses or categories can no longer be typed wrong.
You don't have to drag a formula across a thousand rows — double-clicking the little black square copies it down to the end of the adjacent data.
Ctrl+T
Ctrl+T turns a range into a “smart” table — automatic filters, formatting for new rows, and readable formulas.
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.
Duplicate values, overdue deadlines, or below-average results highlight themselves — you just define the rule.
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.
View → Freeze Panes keeps the table header locked at the top no matter how far you scroll.
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.
F4
One key, two superpowers — repeating your last action and toggling dollar signs in a formula.
An empty calendar is an invitation to meetings. Block off your mornings for deep work before someone else does it for you.
Anything that takes less than two minutes, do right when you read it. Longer things go to your task list — and archive the email.
An automatic rule moves newsletters under a label and marks them as read. You read them when you want to.
Search operators find in seconds an email you'd otherwise spend fifteen minutes hunting for by hand.
An email written Saturday evening can go out Monday at 8 AM. Scheduled sending respects the recipient's time — and your reputation.
The Snooze feature hides an email from your inbox and brings it back at a time you choose. Your inbox stays clean and nothing gets lost.
Answering similar questions over and over? Save the reply as a template and drop it in with two clicks.
Two profiles means two sets of bookmarks, logins, history, and extensions. No more signing out and mixing work with personal.
Win+S
When Windows can't “find” your files, it's probably not indexing the right folders. One search setting fixes it all.
Blue light in the evening delays falling asleep. Windows can automatically warm up the screen after sunset.
Win+V
Clipboard history (Win+V) can sync through your Microsoft account — copy something on your work PC, paste it on your laptop.
Ctrl+P
The virtual printer “Microsoft Print to PDF” makes a PDF out of any app that can print — a webpage, an email, even an invoice from your accounting software.
Windows can reopen the apps that were running before a restart. An overnight update doesn't have to mean rebuilding your workspace in the morning.
Win+Z
Hover over the maximize button (or press Win+Z) and pick where the window belongs — halves, thirds, a grid.
Win+H
Voice typing in Windows works in your language and starts wherever the cursor is blinking. Dictate a first draft of an email in a third of the time.
Win+E
A new folder, finding a file, copying — it all starts with File Explorer. Open it with a shortcut, not by hunting for an icon.
Win+Ctrl+→
Win+Ctrl+D creates a new desktop, Win+Ctrl+arrows switch between them. Slack on one, focused work on the other.
An alternative to window-switching — the active window sits center stage, the rest lined up at the edge. Helps you keep one thing in focus.
Cmd+Option+D
Cmd+Option+D hides the Dock. On a laptop that gets you a noticeable strip of extra screen — the Dock slides out only when you want it.
Set up a Work mode that lets through only colleagues and family — synced to your iPhone and Apple Watch too.
Preview handles arrows, boxes, text, and blurring sensitive info. For 90% of everyday edits, you don't need anything else.
Save a search as a smart folder — say, “PDFs from the last week.” The contents keep themselves up to date by the rules you set.
Right-click in Finder → Import from iPhone → Scan Documents. The scan lands directly in the folder, perfectly cropped.
Cmd+Option+L
Finder has shortcuts for the folders you use most — Cmd+Shift+D for Desktop, Cmd+Option+L for Downloads, and more.
macOS can select text in a photo or screenshot just like regular text. Grab a phone number off a photo of a business card in two clicks.
Universal Clipboard works between Apple devices automatically — text, photos, and links travel over without emailing yourself.
Assign actions to the corners of your screen — flicking into a corner shows the desktop, starts the screensaver, or locks the screen.
Ctrl+→
Ctrl+arrows switch between virtual desktops. One for focused work, one for mail and chat — and distractions disappear from view.
The Preview app can drop your signature straight into a PDF. Capture it once, then sign in two clicks from then on.
Hold down the green button on a window and pick a half of the screen. Perfect for writing with reference material alongside.
Double-tapping the keyboard shortcut starts dictation wherever the cursor is blinking. It handles other languages surprisingly well.
Select files, right-click, Rename — Finder can replace text, add sequence numbers, and format names with numbering.
macOS can replace short shortcuts with long text system-wide — in email, browser, and chat alike. Set it up once, works everywhere.
Cmd+Option+V
The Mac has no Ctrl+X for files — instead, copy with Cmd+C and paste with Option: the file moves instead of copying.
Cmd+Tab
The app switcher can do more than it looks — quit apps, hide them, or switch between windows without ever letting go of the keys.
Cmd+Shift+5
Cmd+Shift+5 opens a panel that handles both screenshots and screen video — including area selection and a timer.
Cmd+Space
No need to open a calculator or google an exchange rate. Spotlight calculates and converts currencies and units right in the search field.