Office & Email

Create Excel drop-down lists from another sheet by typing cross-sheet Data Validation references, using named ranges, handling sheet names with spaces, older Excel limitations, fixed ranges, tables, and same-workbook limits.

Create custom Excel number formats for leading zeros, currency, thousands, millions, colors, negative numbers in parentheses, hidden values, reusable workbook formats, and format codes that change display without changing values.

Create Outlook distribution lists as Contact Groups or Contact Lists, add members from contacts or email addresses, use groups in the To field, edit membership, nest groups, use Bcc for privacy, and understand sync limits.

Compare two Word documents, create a third marked-up comparison file, choose original and revised documents, accept or reject changes, use Combine for multiple reviewers, show source documents, and handle busy formatting differences.

Continue numbered lists in Word after paragraphs, images, tables, pasted text, or split sections, use Continue Numbering, Set Numbering Value, Restart at 1, and fix pasted list numbering.

Count colored cells in Excel with Find and Replace for one-time counts, use GET.CELL named formulas for live color codes, count with COUNTIF, save as .xlsm, and understand color as formatting rather than data.

Change Excel date formats with built-in and custom formats, use locale for non-US dates, create custom date codes, fix serial numbers and ##### dates, change regional defaults, and avoid date entry confusion.

Check Word word count in the status bar, count selected text, enable missing status bar word count, open the full Word Count dialog, include text boxes, footnotes, and endnotes, understand hyphen and punctuation counting, and track counts while writing.

Combine text in Excel with CONCATENATE, CONCAT, TEXTJOIN, and ampersand formulas, add spaces and punctuation, skip blanks, preserve date formatting with TEXT, fix #NAME errors, formulas showing as text, and use Flash Fill.

Change Word margins for a whole document or one section, use custom margin values, insert section breaks, add gutters and mirror margins for binding, switch inches and centimeters, set defaults, and handle printer margin warnings.