DeskPlainXLOOKUP vs VLOOKUP: choose the right lookup and avoid silent mismatches
Compare the defaults, compatibility, and common failure cases using a small product-price example.
THE GUIDE LIBRARY
Find the detail you need.
Browse by subject or narrow the collection with a few words. Each guide includes scope, sources and a next step.
38 guides
COUNTIF and COUNTIFS: build counts you can explain
Count one condition, combine conditions, and avoid double-counting with a reproducible support-ticket example.
Dates stored as text in Excel: convert them without reversing day and month
Diagnose the underlying value, preserve the source, and choose a conversion method that matches the date format.
Print Excel on one page without making the report unreadable
Choose a print area, compare one-page-wide and one-page-total layouts, and check the actual output before printing.
Remove a blank page in Word without breaking section formatting
Identify the paragraph, page break, or section setting causing the page before you change it.
Create a Word table of contents that updates correctly
Build the table from heading styles, choose the right update action, and fix missing or unwanted entries at their source.
OneDrive Free up space vs Delete: choose the action that preserves your files
Separate PC storage, cloud quota, offline access, and deletion before changing a synced folder.
Outlook mailbox full: find the quota, preserve important mail, and choose the right archive
Separate mailbox limits from cloud storage and learn why moving mail into the ordinary Archive folder may not help.
Edge PDF Printing Problems: Find the Failing Step Before Changing Settings
Separate a damaged PDF, an Edge preview problem, a printer connection, and a version-specific regression with a controlled comparison.
Printer Wi-Fi vs USB: Choose a Connection and Troubleshoot It Clearly
Pick a practical home-office connection, distinguish network Wi-Fi from Wi-Fi Direct, and compare failures without losing track of printer queues.
Double-Sided Printing Settings: Long Edge, Short Edge, and Manual Duplex
Choose the binding edge, confirm automatic duplex support, and use a two-page comparison before printing a larger document.
Avery Labels Not Lining Up: Diagnose Shift, Scaling, and Sheet Feed
Distinguish a uniform offset from cumulative misalignment, verify the exact stock, and adjust only after a measured plain-paper comparison.
Scanner Not Detected in Windows 11: Separate Connection, App, and Compatibility Problems
Check whether Windows sees the scanner, compare scan apps, and account for ARM and Protected Print limits without assuming printing proves scanning support.
Printer Printing Blank Pages: Isolate the File, Print Route, or Device
Use the printer’s own diagnostic output and one simple document to distinguish a blank-page hardware symptom from file and application problems.
How to Print Labels in Word: Identical Labels, Different Labels, and Mail Merge
Choose the right Word workflow, match the label product, and inspect a complete plain-paper sheet before committing your stock.
Fill, Sign, and Save a PDF: Keep a Verified Completed Copy
Identify interactive fields versus a flat form, add information with the right tool, and reopen the saved PDF before sending it.
Printer Offline in Windows 11: A Practical Checklist
Check the connection, selected printer, and queue in a useful order before removing your Windows printer setup.
How to Clear a Printer Queue in Windows 11
Cancel unwanted jobs, avoid duplicate printouts, and check whether the problem is the queue, the connection, or one document.
Windows Protected Print Mode: Check These Things Before Switching
Understand printer removal, scanning compatibility, and the difference between Protected Print and the driver servicing timeline.
Microsoft Print to PDF Not Working? Start With These Checks
Separate an Edge-only problem from a Windows-wide PDF printing issue, and use a built-in export route when you need a file now.
Print a PDF at Actual Size or Fit: Which Should You Choose?
Choose the right scaling option for ordinary documents, labels, and templates, then verify one page before printing the full file.
Format a resume in Word without fighting the layout
Build a readable resume with consistent spacing, simple headings, and a careful Word-to-PDF check.
Remove duplicates in Excel while preserving your source
Review repeated values, choose the right comparison columns, and create a clean result without overwriting the original.
Outlook rules not working? Check your version, account, and rule order
Troubleshoot a mail rule carefully, with separate paths for new Outlook and classic Outlook for Windows.
What OneDrive sync icons mean, and what to check next
Tell online-only files from local copies, recognize sync warnings, and check important files before changing anything.
Clean up Windows 11 storage without guessing which files to delete
Use Windows Storage settings to review space, remove selected temporary files, and configure cautious automatic cleanup.
An editable cover letter template, with a practical writing plan
Use a clear four-part structure, choose evidence you can support, and check the exact attachment before you send it.
A spreadsheet cleanup checklist that starts with a recoverable copy
Use a preserved source, explicit comparison rules and a structured review record. Practice with an explained Excel lab and answer key.
A printer troubleshooting checklist you can hand to support
Record the symptom, isolate where printing changes, and share a useful description without passwords or confidential documents.
Choose and edit a Word resume that gives your experience room
Compare two carefully laid-out Word resumes, inspect the real PDF pages and adapt the examples using a separate editing guide.
Windows Update looks stuck: identify the stage before trying a fix
Separate a slow download, a pending restart and a failed installation, then use the appropriate Windows 11 checks.
Bluetooth not working in Windows 11: separate pairing, connection and audio problems
Find out whether the radio, accessory or sound destination needs attention before removing devices or changing drivers.
Wi-Fi connected but no internet in Windows 11: find where the connection stops
Compare the PC, the local Wi-Fi network and internet access without resetting managed settings or disabling protection.
How to take, save and safely share a screenshot in Windows 11
Choose a capture method, find the saved image and review what it reveals before sending it to someone else.
Choose which apps start with Windows 11 without disabling what you need
Review startup entries, distinguish restored windows from startup tasks and test small changes you can reverse.
Change default apps in Windows 11 by file type, browser or link
Fix the app that opens a file without renaming the file, changing its format or resetting unrelated preferences.
File Explorer search cannot find a file: check location, filename and indexing
Use a known file as a control and separate search coverage from missing files before changing Windows indexing.
External monitor not detected in Windows 11: check the entire connection path
Distinguish a display-mode choice from a cable, USB-C or dock limitation before changing graphics drivers.
No guide matches those filters. Try a shorter phrase or another topic.