Use the XLOOKUP function when you need to find things in a table or a 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.

Sign in using two-step verification or security info; Create app passwords in Security info (preview) Set up a phone call as your verification method

Tip: If you have a Microsoft 365 Family subscription, people you've shared the subscription with can also set up a personalized email address with your connected domain.After you've set up your domain, people you've shared with will see an option to add a personalized email address in the premium features section of Outlook settings.

To zip (compress) files. In the search box on the taskbar, type file explorer, and then select it from the list of results.Right-click the file you want to zip, and then select Send to > Compressed (zipped) folder.. To decompress files. Open File Explorer and find the compressed folder.

When you need to protect the privacy of an email message, encrypt it. Encrypting an email message in Outlook means it's converted from readable plain text into scrambled cipher text.

By default, the Encrypt connection check box is selected to signify that Power Query connects to your database using an encrypted connection. If you do not want to connect using an encrypted connection, clear this check box, and then click Connect.. If a connection to your SQL Server is not established using an encrypted connection, Power Query prompts you to connect using an unencrypted ...

Training: Watch these videos to help your school, work, or organization use Microsoft Teams to video conference, work remotely, and become proficient using Teams.

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.

The following shows an intro with lower case Roman numerals. You can use any other format instead. Select between the intro and the body of the document and go to Layout > Breaks > Next Page.

To reset your PC, go to Start > Settings > System > Recovery .Next to Reset this PC , select Reset PC.Then, select Keep my files, choose cloud or local, change your settings, and set Restore preinstalled apps? to No.. Open Recovery settings