Office & Email

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 INDEX MATCH as a flexible VLOOKUP alternative, look left or right, match two criteria, use two-way INDEX MATCH, count matches with COUNTIF or COUNTIFS, and troubleshoot #N/A errors.

Use PowerPoint Presenter View with a second monitor or single screen, show speaker notes timer next slide and tools privately, fix wrong-display issues, present in online meetings, swap displays, and troubleshoot display detection.

Use IFERROR to replace Excel formula errors with blanks zeros or messages, wrap formulas and lookup formulas, use IFNA for lookup-only misses, nest fallbacks, avoid hiding real problems too early, and troubleshoot raw error codes.

Use Excel Flash Fill to split combine or reformat data from typed examples, trigger Flash Fill manually, enable automatic Flash Fill on Windows, handle inconsistent source patterns, know when formulas are better, and compare Text to Columns.

Use Excel Goal Seek to work backward from a desired formula result, choose set cell target value and changing cell, fix convergence failures, compare Goal Seek with Solver, preserve original inputs, and avoid disconnected changing cells.

Use HLOOKUP for horizontally arranged lookup tables, understand lookup value table array row index and exact match, fix #N/A and #REF errors, rank numbers with RANK or RANK.EQ, handle ties, and compare INDEX MATCH and XLOOKUP alternatives.

Use dollar signs in Excel formulas to lock cell references, switch between relative absolute and mixed references with F4, use named ranges, lock lookup tables, repair copied formulas, and know when absolute references matter.

Unsubscribe from newsletters in Outlook with the built-in unsubscribe button or sender links, block suspicious senders, use Sweep or Clean Up, understand CAN-SPAM expectations, and know when not to click unsubscribe links.

Update Word tables of contents after editing, refresh the full TOC or page numbers only, fix missing headings, use F9 shortcuts, update fields before printing, and recognize TOCs converted to plain text.