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.

This version of Microsoft Photos app offers a convenient and user-friendly way to view, import, organize, edit, and share photos and videos on Windows devices. Users can also utilize the new Photos app to access media files stored on OneDrive and iCloud.

Here are some ways to deal with phishing and spoofing scams in Outlook.com. Spoof Intelligence from Microsoft 365 Advanced Threat Protection and Exchange Online Protection help prevent phishing messages from reaching your Outlook inbox.

Find settings in Windows. 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. Most apps have their own settings. In the app, select Settings to make app-specific changes.

You can change the capitalization, or case, of selected text in a document by selecting a single button on the Home tab called Change Case. Note: For information on automatic capitalization rules, see Choose AutoCorrect options for capitalization, spelling, and symbols. Change case.

To resolve this, see Troubleshoot problems with the Windows Media Player app. 0xC00D1163. This error may occur when there are issues with digital rights management (DRM) for protected content. If you're unsure about the error code, refer to the error types below and the instructions to resolve it.

Alarms and timers work even if the app is closed or your device is locked. If you see a warning that notifications only show if the device is awake, make sure your device doesn’t go to sleep (Go to Start > Settings > System > Power & sleep to adjust your device’s sleep settings).

If you're having problems accessing Outlook.com, you can see the status of Microsoft Office Online Services at the Service Health portal. If you're having problems sending or receiving email, read how to Fix Outlook.com email sync issues . Last updated: 2 April 2024.

COUNTIF function. Use COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list. In its simplest form, COUNTIF says:

Splits text strings by using column and row delimiters. The TEXTSPLIT function works the same as the Text-to-Columns wizard, but in formula form. It allows you to split across columns or down by rows. It is the inverse of the TEXTJOIN function .