Look up values with VLOOKUP, INDEX, or MATCH - Microsoft Support
Here's an example of how to use VLOOKUP. =VLOOKUP(B2,C2:E7,3,TRUE) In this example, B2 is the first argument—an element of data that the function needs to work.For VLOOKUP, this first argument is the value that you want to find.
Applies To:
Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Join a meeting without an account in Microsoft Teams
Learn how to join a Microsoft Teams meeting if you don't have an account. Join a Teams meeting as a guest in the Windows app or on the web.
Applies To:
Microsoft Teams
Activate Office - Microsoft Support
Learn how to activate Office pre-installed on new Windows 10 PCs or with a new product key.
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 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, Office 2021, OneNote 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Office 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Publisher 2016, Office 2016, Microsoft 365 for home, Office for business, Microsoft 365 admin, Project for Office 365
Set up your Microsoft 365 sign-in for multi-factor authentication
By setting up MFA, you add an extra layer of security to your Microsoft 365 account sign-in. For example, you first enter your password and, when prompted, you also type a dynamically generated verification code provided by an authenticator app or sent to your phone.
Applies To:
Office for business, Microsoft 365 admin
Activer Windows - Support Microsoft
Si vous installez Windows sur un nouvel appareil ou une carte mère pour la première fois et que vous n’avez pas de clé de produit, sélectionnez Je n’ai pas de clé de produit pendant les écrans d’installation. À l’invite, entrez le compte Microsoft à utiliser pour acheter une licence numérique pour cet appareil.
Using structured references with Excel tables - Microsoft Support
In our example data, we used the name DeptSales.. Use the following rules for table names: Use valid characters Always start a name with a letter, an underscore character (_), or a backslash (\).Use letters, numbers, periods, and underscore characters for the rest of the name.
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel 2013, Excel Mobile
Location and privacy in Microsoft Edge - Microsoft Support
How Microsoft Edge interacts with operating system permissions when sharing your location with a website. Windows can use information such as your IP address, nearby Wi-Fi access points, and GPS data, if available, to estimate your precise or imprecise location coordinates and pass this info to Microsoft Edge.
Applies To:
Microsoft account dashboard
Installer et utiliser un scanneur dans Windows 10 - Support Microsoft
Dans la plupart des cas, il vous suffit de connecter le scanneur à votre appareil pour l’installer. Branchez le câble USB de votre scanneur sur un port USB disponible sur votre appareil, puis allumez le scanneur.
Switching out of S mode in Windows - Microsoft Support
On the Switch out of S mode (or similar) page, select the Get button. After you see a confirmation message on the page, you'll be able to install apps from outside of the Microsoft Store.
Update to the new Microsoft Edge - Microsoft Support
To change appearance, select Appearance and make the changes you want to your default theme, zoom, toolbar, and fonts.