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
Format a date the way you want - Microsoft Support
When you enter some text into a cell such as "2/2", Excel assumes that this is a date and formats it according to the default date setting in Control Panel.Excel might format it as "2-Feb".If you change your date setting in Control Panel, the default date format in Excel will change accordingly.
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
Pin an app to the taskbar - Microsoft Support
From the Start menu or apps list, press and hold (or right-click) an app, then, if available, select Pin to taskbar .
Using email in Outlook on the web - Microsoft Support
Get help with signing in, changing passwords, creating and sending mail, deleting mail, creating folders, and more in Outlook on the web.
Applies To: Outlook.com, Outlook on the web for Exchange Server 2016
Archive in Outlook for Windows - Microsoft Support
Note: If you have a message open in its own window instead of the Reading pane, the Backspace key will not archive the message. You have to close the message and view it in the Reading pane for the Backspace keyto archive the message. When the message is open in a new window, the only way to archive the message is by using the Archive button on the ribbon.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, New Outlook for Windows
About Office: What version of Office am I using?
Under Product Information, you'll find your Office product name and, in some cases, the full version number.. 1 - Product name, such as Microsoft 365 ProPlus or Office Home and Student.. 2 - Version number, which includes version, build number, and the type of installation such as Click-to-run or Windows Store.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, OneNote for Microsoft 365, Publisher for Microsoft 365, Visio Plan 2, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, Outlook for Microsoft 365 for Mac, OneNote for Microsoft 365 for Mac, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Project Professional 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, Office 2021, OneNote 2021, Word 2021 for Mac, Outlook 2021 for Mac, PowerPoint 2021 for Mac, OneNote 2021 for Mac, Office 2021 for Mac, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Project Professional 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Office 2019, Excel 2019 for Mac, Word 2019 for Mac, Outlook 2019 for Mac, PowerPoint 2019 for Mac, OneNote 2019 for Mac, Office 2019 for Mac, Excel 2016, Word 2016, PowerPoint 2016, Access 2016, OneNote 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Visio Standard 2016, Office 2016, OneNote for Mac, Microsoft 365 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, Office 365 operated by 21Vianet, Office 365 operated by 21Vianet - Small Business Admin, Office 365 operated by 21Vianet - Admin, Project Online, InfoPath 2013
Share files and folders in OneDrive (personal) - Microsoft Support
It’s always good to stay on top of the content you’ve shared with friends, family, and collaborators. OneDrive makes it easy. Simply log into your account at OneDrive.com, and in the left-side navigation area, you’ll see a view called Shared.. This view lets you quickly see all of your content that’s shared, especially the content that you’ve shared with others.
Applies To: OneDrive (home or personal), OneDrive for Mac, OneDrive for Windows
Get started with PowerPoint for the web - Microsoft Support
With PowerPoint for the web you create presentations right in your browser. Create and save your presentations in your OneDrive, and edit and share them online.
Applies To: PowerPoint for the web
What Microsoft 365 business product or license do I have? - Microsoft ...
Note: This topic is for Microsoft 365 for business.If you have an Office for home product and you're looking for where to install Microsoft 365, see Install or reinstall Office on a PC or Mac.To see what Office for home products you have a license for, sign in with your Microsoft account to Services & subscriptions.
Applies To: Office for business, Office 365 Small Business, Microsoft 365 admin, Office 365 Germany - Enterprise
Stay protected with Windows Security - Microsoft Support
Tip: If you're a Microsoft 365 Family or Personal subscriber you get Microsoft Defender, our advanced security software for Windows, Mac, iOS, and Android, as part of your subscription.Learn more at Getting started with Microsoft Defender.