Use the XLOOKUP function to find things in a table or range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term and return a result from the same row in another column, regardless of which side the return column is on.

If your PC is running slowly, the following suggestions might help speed things up. The tips are listed in order, so start with the first one, see if that helps, and then continue to the next one if it doesn’t.

An upgrade moves your PC from a previous version of Windows—such as Windows 7 or Windows 8.1—to Windows 10. An upgrade can take place on your existing device, though Microsoft recommends using Windows 10 on a new PC to take advantage of the latest features and security improvements.

When in the new Teams, turn on (or off) notifications by selecting Settings and more at the top of the new Teams, then selecting Settings > Notifications > Open Windows notifications settings.Find Microsoft Teams (work preview) in the apps list and set your preference.

Turn your PC off completely. To shut down, select Start and then select Power > Shut down.. Sleep. Sleep uses very little power, your PC starts up faster, and you’re instantly back to where you left off.

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.

Notes: The formatting options that appear in the Formatting tab depend on the data you have selected. If your selection contains only text, then the available options are Text, Duplicate, Unique, Equal To, and Clear.When the selection contains only numbers, or both text and numbers, then the options are Data Bars, Colors, Icon Sets, Greater, Top 10%, and Clear.

Check the Xbox services, games, and apps for any service outages.

This troubleshooter assists customers whose machines are not yet updated to the latest release, Windows 10 Version 1607. This update will initially be released only to a small set of targeted customers. This set will expand over time. Windows users can start the assistant from this article.

Note for iPhone: If you are having trouble with your iPhone import, make sure your device is unlocked and you’ve accepted the permissions. Note for Android and other devices: If you’re using an Android phone or other device and import isn’t working, you might need to change your phone’s USB settings from Charging over USB to Transfer Files or Transfer Photos.