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
Fix your Outlook email connection by repairing your profile
Having trouble connecting to your email from Outlook on your desktop? Follow these steps to let Outlook diagnose and fix errors in your Outlook mail profile that might be causing the issue.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Office for business, Office 365 Small Business, Microsoft 365 admin
Download and install or reinstall Office 2019, Office 2016, or Office ...
From the Overview page, select Office apps and on that page, find the Microsoft 365 product you want to install and select Install. To install Microsoft 365 in a different language, or to install the 64-bit version, use the dropdown to find more options.
Applies To: Office 2019, Office 2016, Office 2016 for Mac, Office 2013
Screen mirroring and projecting to your PC or wireless display
Cast to a display from a Windows PC. You can wirelessly connect your PC to a TV, projector, or other kind of external display that supports Miracast. Turn on your TV, projector, or other display. If you're using a Miracast dongle or adapter, make sure it's plugged in to the display.
Download Microsoft Authenticator - Microsoft Support
The Microsoft Authenticator app helps you sign into your accounts when you're using two-step verification.
Fix sound or audio problems in Windows - Microsoft Support
Start by running the automated audio troubleshooter in the Get Help app. Get Help automatically runs diagnostics and takes the correct steps to fix most audio issues. Open Get Help. If the Get Help app is unable to resolve your sound or audio issue, try the possible solutions listed: Windows 11 Windows 10. 1.
Reset a forgotten Microsoft account password
Change or reset your Windows password. Accessing the account of someone who has died. Learn how to reset or change your Microsoft account password. Get help with a forgotten Microsoft account password.
Applies To: Microsoft account dashboard
Create installation media for Windows - Microsoft Support
You can use installation media (a USB flash drive or DVD) to install a new copy of Windows, perform a clean installation, or reinstall Windows. To create installation media, go to the software download website, where you'll find step-by-step instructions.
Use the Office offline installer - Microsoft Support
Use the Office offline installer to install Office 2016 or Office 2013 if you don't have an active Internet connection or you're having problems with slow speed or unreliable connections.
Applies To: Office 2021, Office 2019, Office 2016, 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, Office 365 Germany - Enterprise, Office 365 Germany - Enterprise admin
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft Support
The VLOOKUP and HLOOKUP functions, together with INDEX and MATCH,  are some of the most useful functions in Excel. Note: The Lookup Wizard feature is no longer available in Excel. 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.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016