Fix duplicate emails in Outlook by removing duplicate account entries, checking POP leave-copy settings, reviewing rules that copy messages, restarting Outlook, using Clean Up Folder, resyncing mobile accounts, understanding forwarding, and avoiding risky cleanup add-ins.
Filter Excel data by text, numbers, dates, colors, and multiple columns, turn filters on and off, clear filters, use advanced OR criteria, convert data to Tables, add slicers, and read visible record counts.
Fix Excel #NUM errors caused by impossible calculations, negative square roots, oversized results, whole-column mistakes, IRR RATE and XIRR convergence failures, optional guesses, #VALUE differences, circular references, and Evaluate Formula.
Delay or schedule Outlook email delivery for one message, create a rule that delays every sent message, use Schedule Send in new Outlook and Outlook.com, understand classic Outlook needing to stay open, edit or cancel delayed mail, and add rule conditions.
Delete blank rows and remove duplicate rows in Excel using Go To Special, Delete Entire Row, Remove Duplicates, selected columns, duplicate highlighting, Excel Tables, undo precautions, and Google Sheets alternatives.
How to Delete Blank Rows and Duplicate Rows in Excel Read More »
Use Dictate in Word to voice type documents, grant microphone permission, speak punctuation and commands, fix Dictate not starting, update Microsoft 365, select the right microphone, check internet access, use language settings, and control auto punctuation.
Create hanging indents in Word using keyboard shortcuts, the Paragraph dialog, exact 0.5 inch settings for MLA and APA references, default styles, the ruler markers, hidden tabs and spaces, and applying indentation to a full citation list.
Run Word mail merge for letters, labels, envelopes, and email using Excel or Outlook contacts, prepare source data, use the wizard, insert merge fields, preview records, fix wrong or blank fields, format merged dates and numbers, filter recipients, and use Mac Mailings tools.
Create and use Outlook Quick Steps to move, forward, categorize, mark read, and automate repeated email actions, including built-in Quick Steps, custom multi-action steps, keyboard shortcuts, editing, ordering, and fixing broken target folders.
Create reusable Excel LAMBDA functions, test LAMBDA syntax, save functions in Name Manager, call them like built-in formulas, use LET, understand recursion, fix #CALC argument mismatches, and share named functions between workbooks.