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.

Learn how the Photos app for Windows lets you view photos and videos from your PC alongside those from OneDrive, and keeps them organized by date, album, or folder.

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.

You can download free, pre-built document templates with useful and creative themes from Office when you click File > New in your Office app. Templates can include calendars, business cards, letters, cards, brochures, newsletters, resumes, cover letters , presentations, social media and much more.

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.

The easiest way to get language packs for Windows 8.1 and Windows RT is to download and install them using the Language Control Panel. Download and install additional languages to view menus, dialog boxes, and other user interface items in your preferred language.

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.

Switch voice typing languages. To switch voice typing languages, you'll need to change the input language you use. Here's how: Select the language switcher in the corner of your taskbar. Press the language switcher in the bottom right of the touch keyboard.

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.