September 2026

Choose between linking and embedding Excel charts in PowerPoint, paste self-contained charts or live linked charts, refresh data, fix broken links, manage file size, share decks safely, and switch methods by repasting.

Fix Microsoft Teams when it will not open freezes loads endlessly or has audio video and call issues, check service status, restart Teams, clear cache, test web Teams, update the app, adjust camera microphone permissions, and reinstall if needed.

Write Excel IF formulas with true and false results, use text and number conditions, copy formulas down, combine IF with AND or OR, use nested IF and IFS, show blanks, and know when lookups are better.

Use XMATCH to return the position of a value in Excel, search exact wildcard approximate and reverse matches, compare XMATCH with MATCH, combine XMATCH with INDEX, fix #N/A errors, and avoid binary search on unsorted data.

Wrap text in Google Sheets cells columns or whole sheets, choose Wrap Overflow or Clip, resize rows to fit data, apply wrapping on mobile, undo wrapping, and understand when clipping or overflow is useful.

Use Excel TODAY to show the current date, calculate days since or days until dates, fix serial-number formatting, compare TODAY with NOW, refresh stale dates, insert static dates, and use TODAY in conditional formatting.

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.