techsupportoffice

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 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 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.

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.