Office & Email

Use VLOOKUP to pull values from another Excel sheet or workbook, write sheet references correctly, search several sheets with nested IFERROR formulas, understand closed-workbook updates, and know when to consolidate data instead.

Use XLOOKUP in Excel to replace VLOOKUP, look left or right, return custom not-found messages, match on two criteria, use approximate match modes, fix #NAME and #N/A errors, and understand why inserted columns do not break it.

Use Excel Subtotal to add group totals and grand totals to sorted lists, create collapsible outlines, use the SUBTOTAL formula, remove subtotals, nest multiple subtotal levels, copy only visible rows, and choose function numbers.

Use Excel SWITCH to replace long nested IF chains for exact-value matches, create default results, use nested IF in older Excel, avoid range-comparison mistakes, compare SWITCH with IFS, and understand case-insensitive matching.

Use Excel TEXT to display dates numbers currency percentages and times inside text strings, apply format codes, combine formatted values with words, understand that TEXT returns text, test custom formats, and build dynamic status lines.

Use INDIRECT to turn text into Excel references, build cell references from another cell, reference sheet names typed in a control cell, handle sheet names with spaces, understand volatility and closed-workbook limits, and choose Tables or named ranges when better.

Use OFFSET to return values or dynamic ranges a certain number of rows and columns from a starting cell, build growing named ranges with COUNTA, understand positive and negative offsets, avoid volatility slowdowns, and fix #REF errors.

Use Excel OR to test whether any condition is true, combine OR with IF for useful outputs, compare OR with AND, nest OR inside AND, use OR in conditional formatting, and understand case-insensitive text comparisons.

Add the hidden Excel Camera tool, create live snapshots of cell ranges, build dashboard views from multiple sheets, move resize and retarget linked pictures, and fix snapshots whose source range was moved or deleted.

Use Word Read Aloud to hear documents, control playback speed and voice, troubleshoot missing or silent playback, set proofing language, compare Immersive Reader, and change system text-to-speech voices.