Pair a Bluetooth device in Windows - Microsoft Support
In quick settings: To find the quick setting for Bluetooth, select the Network, Sound, or Battery icons ( ) next to the time and date on the right side of your taskbar.Select Bluetooth to turn it on. If it's turned on without any Bluetooth devices connected, it might appear as Not connected . If you don't see Bluetooth in quick settings, you might need to add it.
VLOOKUP function - Microsoft Support
Argument name. Description. lookup_value (required). The value you want to look up. The value you want to look up must be in the first column of the range of cells you specify in the table_array argument. For example, if table-array spans cells B2:D7, then your lookup_value must be in column B.. Lookup_value can be a value or a reference to a cell.. table_array (required)
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
Sign in to SharePoint - Microsoft Support
In the upper left corner of the window, select the app launcher > All apps > SharePoint Tip: If you don't see the SharePoint app under All apps, use the Search box near the top of the window to search for SharePoint.
Applies To: SharePoint in Microsoft 365
How to sign in to or out of Outlook.com - Microsoft Support
To get support in Outlook.com, click here or select Help on the menu bar and enter your query. If the self-help doesn't solve your problem, scroll down to Still need help? and select Yes.. To contact us in Outlook.com, you'll need to sign in.
Applies To: Outlook.com
Turn off, disable, or uninstall OneDrive - Microsoft Support
OneDrive is built in to some versions of Windows and can't be uninstalled. But you can hide it and stop the sync process, so it stays hidden. To do this, turn off all the OneDrive settings and remove the OneDrive folder from File Explorer.
Applies To: OneDrive for Business, SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint in Microsoft 365, Office for business, 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 admin center, SharePoint in Microsoft 365 Small Business, SharePoint operated by 21Vianet
Freeze panes to lock rows and columns - Microsoft Support
To keep an area of a worksheet visible while you scroll to another area of the worksheet, go to the View tab, where you can Freeze Panes to lock specific rows and columns in place, or you can Split panes to create separate windows of the same worksheet.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Download free, pre-built templates - Microsoft Support
Find and download free templates to create documents like calendars, business cards, letters, greeting cards, brochures, newsletters, or resumes.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, Project Online Desktop Client, Publisher for Microsoft 365, Excel 2021, Word 2021, PowerPoint 2021, Access 2021, Project Professional 2021, Project Standard 2021, Publisher 2021, Excel 2019, Word 2019, PowerPoint 2019, Access 2019, Project Professional 2019, Project Standard 2019, Publisher 2019, Excel 2016, Word 2016, PowerPoint 2016, Access 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Visio 2010, InfoPath 2013
Create, edit, or delete a contact list or contact group in Outlook
You can right-click the contact group and select Delete from the menu or click the group, then select Delete from the Ribbon.. Contacts are not deleted, only the contact list.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Outlook on the web, Outlook.com, New Outlook for Windows
Upgrade Windows Home to Windows Pro - Microsoft Support
Important: The following steps apply only to devices currently running an activated copy of Windows 11 Home.If you’re not activated, we recommend you activate Windows 11 Home first. For more info, see Activate Windows.
Using IF with AND, OR, and NOT functions in Excel
Examples. Following are examples of some common nested IF(AND()), IF(OR()) and IF(NOT()) statements in Excel. The AND and OR functions can support up to 255 individual conditions, but it’s not good practice to use more than a few because complex, nested formulas can get very difficult to build, test and maintain.
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