September 2026

Understand Excel array formulas and Ctrl Shift Enter, enter classic CSE formulas, recognize curly braces, edit array formulas correctly, compare modern dynamic arrays, use SUMPRODUCT alternatives, and fix range-size or normal-enter errors.

Fix Outlook not receiving email by checking Junk Focused Inbox filters rules sender addresses webmail sync offline mode mailbox storage repair tools IMAP subscriptions compromised forwarding rules mobile account setup and provider spam quarantine.

Fix Outlook messages stuck in Outbox, check Work Offline internet and Microsoft service status, reduce large attachments, correct recipient addresses, move stuck messages to Drafts, verify SMTP settings, repair accounts, test antivirus add-ins new Outlook and profiles.

Fix Outlook shared calendars that stop updating, force Send Receive refresh, refresh the calendar, rebuild Cached Exchange Mode, compare Outlook on the web with desktop cache, check permissions, understand shared-calendar reminders, and allow server delays.

Fix repeated Outlook password prompts by clearing saved credentials, checking MFA app passwords account lockouts and expired passwords, repairing accounts, re-registering work devices, testing new Outlook versus classic Outlook, and updating Office.

Compare nested IF and IFS in Excel, write multi-condition formulas, choose compatibility or readability, add TRUE catch-all results, avoid #N/A from IFS, understand formula order, and use lookup tables for many tiers.

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.