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
Step-by-Step Guide
ExcelHighlight 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
- Select the range of invoice rows you want to check, e.g. A2:F200.
- On the Home tab, open Conditional Formatting and choose New Rule.
- Pick “Use a formula to determine which cells to format.”
- Enter the formula below so it reads the due-date column.
- Click Format, choose a red fill, then OK to apply it down the range.
The formula
Good to know
- Lock the column with
$D2so 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
- Chart Sheet in Excel
- Area Chart in Excel
- Create a Gantt Chart in Excel
- Thermometer Chart in Excel
- Add a Trendline in Excel
- Sparklines in Excel
+22 more guides
Pivot Tables
- Group Pivot Table Items in Excel
- Pivot Chart in Excel
- Multi-level Pivot Table in Excel
- Update a Pivot Table in Excel
- How to use Slicers in Excel
- Pivot Tables in Excel
+1 more guides
Data Analysis & Statistics
- Quick Analysis Tool in Excel
- Analysis ToolPak in Excel
- ANOVA test in Excel
- t-Test in Excel
- Moving Average in Excel
- Data Analysis in Excel
+6 more guides
Solver & What-If Analysis
- Solver in Excel
- Transportation Problem in Excel
- Assignment Problem in Excel
- Shortest Path Problem in Excel
- What-If Analysis in Excel
- Capital Investment in Excel
+9 more guides
Formatting & Cell Styles
- Insert Hyperlinks in Excel
- Format Cells in Excel
- Strikethrough Text in Excel (Easy Shortcut)
- Superscript and Subscript in Excel
- How to Line Break in Excel
- Cell Styles in Excel
+13 more guides
Conditional Formatting
- Create a Heat Map in Excel
- Add Data Bars in Excel
- Shade Alternate Rows in Excel
- Manage Conditional Formatting Rules in Excel
- Conditional Formatting in Excel
- Icon Sets in Excel
+2 more guides
Sorting, Filtering & Cleaning Data
- How to Sort Data in Excel
- Date Filters in Excel
- Sort by Color in Excel
- How to Filter Data in Excel
- Highlight Row Differences in Excel
- Apply Number and Text Filters in Excel
+22 more guides
Tables & Data Validation
- Budget Limit in Excel
- Remove Table Formatting in Excel
- Create Drop-down Lists in Excel
- Dependent Drop-down Lists in Excel
- Table as Source Data - Excel Tutorial
- Table Styles in Excel
+7 more guides
Formulas & References
- Create External References in Excel
- Formula Bar in Excel
- Show Formulas in Excel
- Floating Point Errors in Excel
- Cell References in Excel
- How to Copy a Formula in Excel
+6 more guides
Workbooks & Worksheets
- Workbook Views in Excel
- Mark a Workbook as Final in Excel
- View Multiple Worksheets in Excel
- How to Unhide Sheets in Excel
- Worksheets in Excel
- How to AutoFit Columns in Excel
+18 more guides
Printing & Page Setup
- Insert Page Breaks in Excel
- How to Print Sheets in Excel
- Insert Page Numbers in Excel
- Add Headers and Footers in Excel
- Set a Print Area in Excel
- Print Gridlines and Headings in Excel
+2 more guides
Shortcuts, Tools & Productivity
- Save As Shortcut in Excel
- How to Spell Check in Excel
- Insert Comments in Excel
- Skip Blanks in Excel
- How to Enable Macros in Excel
- How to AutoFill in Excel
+23 more guides
Importing, Exporting & Sharing
- How to Convert Excel to PDF
- Share Excel Data with Word Documents
- Share Workbooks - Excel Tutorial
- Save to OneDrive in Excel
- Microsoft Query in Excel
- How to Merge Excel Files
+7 more guides
Templates & Personal Finance
- Create a Meal Planner in Excel
- Create an Invoice in Excel
- Create a Calendar in Excel
- Create a Budget in Excel
- Loan Amortization Schedule in Excel
- Time Sheet in Excel
+17 more guides