Office & Email

Fix Word not responding freezes, wait before force quitting, recover unsaved documents from Document Recovery AutoRecover ASD and WBK files, start Word in safe mode, disable add-ins, repair Office, rename Normal.dotm, use Open and Repair, improve AutoRecover and AutoSave, and reduce large-document freezes.

Fix Microsoft Word when it will not open, clear stuck WINWORD processes, start in safe mode, disable add-ins, install updates, run Quick Repair or Online Repair, rename Normal.dotm, reinstall Office if needed, and use Open and Repair for one bad document.

Use Power Query in Excel to import clean and reshape repeat data, open the Power Query Editor, remove columns fix data types remove duplicates and blanks, close and load, refresh queries, append or merge data, and edit applied steps.

Start writing Excel VBA macros by enabling Developer, opening Visual Basic Editor, inserting a module, writing a Sub procedure, using MsgBox Range and variables, saving as XLSM, stepping through code with F8, handling macro security, and learning from recorded macros.

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 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 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 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.