September 2026

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

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.