Learn how to redeem a gift card, code, or Office product key and spend your balance at Microsoft Store online, on Windows, or Xbox.

Fix Bluetooth problems in Windows. If you run into problems trying to connect to a Bluetooth device, here are some troubleshooting steps to try. Note: For general info about how to connect a Bluetooth device to your PC, see Pair a Bluetooth device in Windows.

Use Remote Desktop on your Windows, Android, or iOS device to connect to a Windows 10 PC from afar. Here's how to set up your PC to allow remote connections and then connect to the PC you set up.

Sign in to SharePoint. 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.

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.

Sending a message. If you haven't already set up messages, do the following: On your PC, in the Phone Link, select Messages. To start a new conversation, select New message. Enter the name or phone number of a contact. Select the person you want to send a message to.

Find your Windows settings in a snap! Select the Start button, then select Settings . From there, browse the categories or use search to find what you're looking for. Windows 11 Windows 10. Tips: Most apps have their own settings. In the app, select Settings to make app-specific changes.

Find your files in Windows 10 using one of these methods. Search from the taskbar: Type the name of a document (or a keyword from it) into the search box on the taskbar. You'll see results for documents across your PC and OneDrive under Best match.

Get help and support, whether you're shopping now or need help with a past purchase. Contact Microsoft Support. Find solutions to common problems, or get help from a support agent.

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.