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.

The IFS function checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition. IFS will allow you to include up to 127 pairs of conditions (the test if something is True and the result if something is true). IFS can take the place of multiple nested IF statements.

What are passkeys? Passkeys are a replacement for your password. With passkeys, you can sign into your Microsoft personal account, or your work/school account using your face, fingerprint, or PIN.

To open the Start menu—which contains all your apps, settings, and files—you can do any of the following: On the center or left end of the taskbar, select the Start icon.

Training: Watch and learn how to create a PowerPoint presentation, add/format text, and add pictures, shapes, and/or charts.

Some sites are built to work with Internet Explorer and have functionality that isn't supported by modern browsers such as Microsoft Edge. If you need to view one of these sites, you can use Internet Explorer Mode in Microsoft Edge.

Using Authenticator as a way to sign in. If you have turned on passwordless, two-step, or multi-factor authentication for your account, use the following steps to sign-in:

Update RECENT GAMES: Once you have used the shortcut and launched Xbox Cloud Gaming (Beta) at least once, it will appear in the RECENT GAMES section (again, within the desktop Steam client) with a blank background.Just as before, right-click, select Manage > Set custom artwork, navigate to your artwork and select Xbox_Cloud_Gaming_Capsule.jpg.

Import a text file by opening it in Excel. You can open a text file that you created in another program as an Excel workbook by using the Open command. Opening a text file in Excel does not change the format of the file — you can see this in the Excel title bar, where the name of the file retains the text file name extension (for example, .txt or .csv).

Expand the top level of the Outlook data file in the Outlook Navigation pane to see the subfolders in the file. Click each subfolder to see the contents.