Guides

    Not a formula. A walkthrough.

    Ask how to do anything in Excel, Google Sheets, or Salesforce. Get step-by-step instructions, not a 12-minute YouTube video that covers six unrelated things.

    Used by 99,000+ spreadsheet and Salesforce users

    Try it

    Free to try. No credit card. 5 generations on us.

    Walkthrough

    A real output for a real prompt.

    How-To Guide Generator

    How do I highlight overdue invoices in Excel?

    Software

    Excel
    Sheets
    Salesforce
    Generate Guide

    Step-by-Step Guide

    Excel

    Highlight overdue invoices in Excel

    Use a conditional-formatting rule that reads the due-date column, so any invoice past its date turns red automatically across the whole range.

    Steps

    1. Select the range of invoice rows you want to check, e.g. A2:F200.
    2. On the Home tab, open Conditional Formatting and choose New Rule.
    3. Pick “Use a formula to determine which cells to format.”
    4. Enter the formula below so it reads the due-date column.
    5. Click Format, choose a red fill, then OK to apply it down the range.

    The formula

    =$D2 < TODAY()

    Good to know

    • Lock the column with $D2 so every field in the row reacts to the same date.
    • In Google Sheetsit's the same idea under Format → Conditional formatting, custom formula.

    Formulas are half the work in a spreadsheet. The other half is the interface itself: menus, toolbars, dialog boxes, settings buried three submenus deep. Pivot tables, conditional formatting, data validation, named ranges, protecting sheets, sharing permissions. None of that is a formula. All of it is the reason people Google “how to [x] in excel” 500 million times a year.

    This tool answers those questions with an actual walkthrough. Not a formula. Not a 12-minute YouTube video where the first 3 minutes are an intro. Just the steps, in order, for the specific thing you asked about.

    What it covers

    Excel (desktop and 365), Google Sheets, and Salesforce. Within each, the full interface: menus, shortcuts, settings, data tools, formatting, sharing, automation UI.

    Why the explanation is better than a Google result

    Most search results for “how do I do X in Excel” are written by content farms, then SEO-optimized into unreadable mush. They start with three paragraphs explaining what Excel is. They pad every step with “Now, click Insert. The Insert tab is a tab that lets you insert things.” They cover four methods when you only need one.

    We give you one method, the one most people use, written the way a coworker would explain it. If there are better approaches for specific situations, we mention them at the end.

    When to use this vs. the formula generator

    Formula generator: “give me a formula that calculates X.” How-To: “walk me through doing X.” A lot of the time you actually want both. Ask the how-to first to understand the setup, then ask the formula generator for the specific calculation.

    Salesforce bias

    Salesforce has five UIs layered on top of each other by now: Classic, Lightning, Setup, Object Manager, and whatever you call the App Builder flow. The tool defaults to Lightning because that's what 95% of orgs use in 2026. If you're on Classic, say so in the prompt.

    Common questions.

    Guides & tutorials.

    In-depth How-To Guides walkthroughs from our library — the how and the why behind what this tool generates.

    Charts & Dashboards

    +22 more guides

    Pivot Tables

    +1 more guides

    Data Analysis & Statistics

    +6 more guides

    Solver & What-If Analysis

    +9 more guides

    Formatting & Cell Styles

    +13 more guides

    Conditional Formatting

    +2 more guides

    Sorting, Filtering & Cleaning Data

    +22 more guides

    Tables & Data Validation

    +7 more guides

    Formulas & References

    +6 more guides

    Workbooks & Worksheets

    +18 more guides

    Printing & Page Setup

    +2 more guides

    Shortcuts, Tools & Productivity

    +23 more guides

    Importing, Exporting & Sharing

    +7 more guides

    Templates & Personal Finance

    +17 more guides

    Pairs well with.

    Stop wrestling with syntax.

    Start free