IF function – nested formulas and avoiding pitfalls
Multiple IF functions can be nested together to allow for multiple criteria. The Excel IF function statement allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if True or False.
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel Web App, Excel for Windows Phone 10
Free Excel for the web templates - Microsoft Support
Tip: If you don’t like the name of the template (usually Book 1), click the name in the Excel for the web title bar at the top of the page and type a different name.
Applies To:
Excel for the web
POP, IMAP, and SMTP settings for Outlook.com
If you're trying to add your Outlook.com account to Outlook or another mail app, you might need the POP, IMAP, or SMTP settings. You can find them below or by viewing them in your Outlook.com settings.. Outlook and Outlook.com may be able to detect your account's mailbox settings automatically, but for other non-Microsoft accounts, you may need to contact your email provider for their settings.
Applies To:
Outlook for Microsoft 365, Outlook for Microsoft 365 for Mac, Outlook 2021, Outlook 2021 for Mac, Outlook 2019, Outlook 2019 for Mac, Outlook 2016, Outlook Web App for Office 365, Outlook Web App for Office 365 Small Business, Outlook on the web, Outlook.com, Outlook Web App for Office 365 operated by 21Vianet, Outlook Web App Light, New Outlook for Windows, Outlook for Android, Outlook Mail for Windows 10, Outlook on the web for Exchange Server 2016, Outlook on the web for Exchange Server 2019, Outlook Web App
Office Help & Training
Get help and training for Office products, such as Word, Excel, PowerPoint, and Outlook. Learn tips and tricks, troubleshoot issues, and access online resources.
Use Magnifier to make things on the screen easier to see
If you are using a mouse, select Start > Settings > Accessibility > Magnifier.Select View, and then open the Keep the mouse pointer or Keep the text cursor drop-down menu, and select how Magnifier behaves when the mouse pointer or text cursor move around the screen. This is something you should experiment with to see which combination works best for you.
Connect to a projector or PC - Microsoft Support
When you're in a conference room and need to project, connect your PC using one of the cable connectors in the room, press the Windows logo key + P, and then choose one of the four options:. PC screen only.
Resolve sync issues in Mail and Calendar apps in Windows 10
Turn off third-party security software. Third-party firewalls or antivirus software might prevent you from syncing your email and calendar events.
Applies To:
Calendar for Windows 10, Mail for Windows 10
Set up Outlook 2003 for POP or IMAP access to your email account ...
We would like to show you a description here but the site won’t allow us.
Use the web version of Outlook like a desktop app
Use Outlook in the new Microsoft Edge. In Microsoft Edge, sign in to your Outlook on the web or Outlook.com account.
Applies To:
Outlook Web App for Office 365, Outlook Web App for Office 365 Small Business, Outlook on the web, Outlook.com, Outlook on the web for Exchange Server 2019
Fix File Explorer if it won't open or start - Microsoft Support
Learn how to troubleshoot File Explorer problems in Windows. To open File Explorer in Windows 10, select its icon on the taskbar, press the Windows logo key + E on your keyboard, or select Start > Documents (directly beneath your user icon).. Here are some things to try if File Explorer won't open.