How to sign in to or out of Outlook.com - Microsoft Support
If you can't sign in to your Outlook.com, Hotmail, Live, or MSN email account, or you're not sure how to sign in or sign out, here are some solutions.
Applies To:
Outlook.com
Redeem a gift card or code to your Microsoft account
Learn how to redeem a gift card, code, or Office product key and spend your balance at Microsoft Store online, on Windows, or Xbox.
Applies To:
Microsoft account dashboard
How to sign in to Hotmail - Microsoft Support
Hotmail is now Outlook.com. Learn how to sign in to access your Outlook.com, Hotmail, Live, or MSN email account.
Applies To:
Outlook.com
How to redeem gift cards and codes | Xbox Support
How to redeem a code on Xbox Series X|S and Xbox One. Press the Xbox button to open the guide, and then select Store. Press the View button to open the side menu, and then select Redeem. Enter the 25-character code, select Next, and then follow the prompts.
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.
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
Sign in to SharePoint - Microsoft Support
SharePoint is a browser-based app that you connect to through your web browser, like so: Go to office.com, and sign in to your work or school account. In the upper left corner of the window, select the app launcher > All apps > SharePoint.
Applies To:
SharePoint in Microsoft 365
Manage your Microsoft 365 subscription or Office product
For Microsoft 365 Family or Personal subscriptions: Select Install premium Microsoft 365 apps and follow the prompts to install or reinstall the desktop apps. On the Microsoft 365 subscription tab, select Manage. From here you can: Renew your subscription with a prepaid code or card. Learn more.
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, PowerPoint for Microsoft 365 for Mac, OneNote for Microsoft 365 for Mac, Word for the web, OneNote for the web, PowerPoint for the web, Excel 2021, Word 2021, Outlook 2021, Access 2021, Project Professional 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, Office 2021, OneNote 2021, Excel 2021 for Mac, Word 2021 for Mac, Outlook 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, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Visio Standard 2016, Office 2016, Microsoft 365 admin, Outlook on the web, Word Web App, Microsoft account dashboard, New Outlook for Windows
Where to enter your Office product key - Microsoft Support
If your purchase of Office or Microsoft 365 came with a product key, you enter your product key on one of the websites listed below for your product. After you enter your key, you can download and install Office, or you can renew your Microsoft 365 subscription. Tip: Get tech expertise with Business Assist.
Applies To:
Office 2021, Office 2021 for Mac, Office 2019, Office 2019 for Mac, Office 2016, Microsoft 365 for home, Office for business
Microsoft account security info & verification codes
For technical support, go to Contact Microsoft Support, enter your problem and select Get Help. If you still need help, select Contact Support to be routed to the best support option. Learn how to manage your Microsoft account security info and troubleshoot verification code issues.
Applies To:
Microsoft account dashboard
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. This argument can be a cell reference, or a fixed value such as "smith" or 21,000.
Applies To:
Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016