Office & Email

Recover deleted or missing OneDrive files from the recycle bin, use version history, restore an entire OneDrive after ransomware or sync errors, fix local sync problems, ask shared-folder owners to restore files, enable folder backup, and check storage limits.

Learn OneNote notebooks sections and pages, type anywhere on the canvas, create new notebooks sections and pages, search notes across notebooks including images and handwriting, use tags, sync through OneDrive, and share notebooks.

Fix Outlook calendar sync problems across desktop web and mobile, force manual sync, check offline status internet VPN and firewall issues, remove and re-add accounts, adjust send receive settings, refresh shared calendars, repair Office, and check time zones.

Fix Outlook cannot connect to server errors, check internet Microsoft 365 outages VPN and firewall requirements, re-enter passwords, repair accounts, disable Work Offline, use Microsoft diagnostics, verify IMAP POP settings, create a new profile, and use Cached Exchange Mode.

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.