TEXT function - Microsoft Support
Note: The TEXT function converts numbers to text, which may make it difficult to reference in later calculations.It’s best to keep your original value in one cell, and then use the TEXT function in another cell. Then, if you need to build other formulas, always reference the original value and not the TEXT function result.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016
Create and use modern pages on a SharePoint site
Learn how to add a page to a SharePoint Online site. Add web parts. Web parts are the building blocks of your page. For more information on the different types of web parts and how to use them, check out Using web parts on pages.. If you have the content pane enabled:
Applies To: SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint in Microsoft 365, Microsoft 365 admin, SharePoint operated by 21Vianet
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 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016, Excel Web App, Excel for Windows Phone 10
Restrictions and limitations in OneDrive and SharePoint
Notes: To rename a file or folder in Windows, select it and press F2. To rename a file or folder on a Mac, select it and press the 'return' key. Some organizations don't yet support # and % in names. If you're a global admin or SharePoint admin in Microsoft 365, see Enabling # and % Support on the SharePoint blog to learn how to allow these characters.
Applies To: SharePoint Server 2019, SharePoint in Microsoft 365, Microsoft 365 admin, OneDrive (work or school), OneDrive (home or personal), OneDrive (work or school) operated by 21Vianet, OneDrive for Mac, OneDrive for Windows, SharePoint in Microsoft 365 Small Business, SharePoint operated by 21Vianet
Add a Gmail account to Outlook for Windows - Microsoft Support
If you need instructions for adding an email account using advanced settings, go to Use advanced setup to add a POP or IMAP email account in Outlook for PC. Outlook won't accept my password. If Outlook won’t accept your password and you know you’re using the right password for your Gmail account, you might have an older version of Outlook that doesn't currently support this faster Gmail ...
Applies To: Outlook for Microsoft 365, Outlook 2024, Outlook 2021, Outlook 2019, Outlook 2016, New Outlook for Windows
COUNTIF function - Microsoft Support
Argument name. Description. range (required). The group of cells you want to count. Range can contain numbers, arrays, a named range, or references that contain numbers. Blank and text values are ignored. Learn how to select ranges in a worksheet.. criteria (required). A number, expression, cell reference, or text string that determines which cells will be counted.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016
Get the Xbox Insider Hub app
Info: Basic information about the preview, including eligibility requirements.; Announcements: The latest news about the preview, including release notes, scheduled play times, and contests.; Activities: Quests: Scenarios that you can step through and provide feedback about the experience.Complete quests to earn XP. Surveys: A quick way for you to send feedback to developers about a preview ...
Copy and paste using the Office Clipboard - Microsoft Support
The Office Clipboard allows you to copy up to 24 items from Office documents or other programs and paste them into another Office document. For example, you can copy text from an email message, data from a workbook or datasheet, and a graphic from a presentation, and then paste them all into a document.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, Publisher for Microsoft 365, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, Outlook for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, Excel 2024, Outlook 2024, PowerPoint 2024, Access 2024, Excel 2024 for Mac, Word 2024 for Mac, Outlook 2024 for Mac, PowerPoint 2024 for Mac, Excel 2021, Word 2021, PowerPoint 2021, Access 2021, Publisher 2021, Excel 2021 for Mac, Word 2021 for Mac, Outlook 2021 for Mac, PowerPoint 2021 for Mac, Excel 2019, Word 2019, PowerPoint 2019, Access 2019, Publisher 2019, Excel 2016, Word 2016, PowerPoint 2016, Access 2016, Publisher 2016
Use Internet Explorer in Windows 10 - Microsoft Support
Internet Explorer 11 support ended on June 15, 2022. We recommend you use Microsoft Edge for a faster, more secure and more modern web browsing experience.
Use the Project or Roadmap app in Teams - Microsoft Support
Add a Project or Roadmap tab to a Teams channel. When you add a tab using the Project or Roadmap app, you can either add an existing project or roadmap, or create a new one.