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.
12 GUIDES · CHOOSE A READING PATH
Microsoft 365 made more manageable.
Make sense of Word, Excel, Outlook and OneDrive.
Workbooks, documents, email and cloud files need different kinds of care. Choose a task below to get the version details, examples and checks that fit it.
Make Excel data usable
Understand the data first, then choose the formula or cleanup step.
Remove duplicates in Excel while preserving your source4 min XLOOKUP vs VLOOKUP: choose the right lookup and avoid silent mismatches4 min COUNTIF and COUNTIFS: build counts you can explain4 min Dates stored as text in Excel: convert them without reversing day and month5 min Print Excel on one page without making the report unreadable5 min
Build a document that holds together
Control headings, spacing, blank pages and navigation.
Know where your mail and files live
Separate account limits, sync state and local device space.
Outlook rules not working? Check your version, account, and rule order4 min Outlook mailbox full: find the quota, preserve important mail, and choose the right archive5 min What OneDrive sync icons mean, and what to check next4 min OneDrive Free up space vs Delete: choose the action that preserves your files5 min
Compare selected columns, preview repeated records and download a reviewed copy.Open csv duplicate checker ↗
THE FULL COLLECTION
All Microsoft 365 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.
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.