Office & Email

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.

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.

Create OneDrive share links from web, desktop, and mobile, control Anyone, organization, existing access, and specific people permissions, choose view or edit, set passwords and expiration on work accounts, manage or revoke links, and understand live files versus downloads.

Create Excel named ranges with the Name Box or Define Name, choose workbook or sheet scope, use names in formulas, edit references in Name Manager, avoid spaces, understand fixed ranges versus Tables, and troubleshoot #NAME and #REF errors.

Create Word fillable forms with the Developer tab, text controls, checkboxes, drop-down lists, content control properties, editing restrictions, form protection, custom placeholders, .dotx templates, and Design Mode notes.

Create Excel heat maps with Conditional Formatting color scales, fix mixed data and duplicate rules, set custom two-color and three-color scales, use fixed thresholds, understand outliers, compare Data Bars and Icon Sets, and note Google Sheets support.