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.

Add or subtract dates. For an overview of how to add or subtract dates, see Add or subtract dates. For more complex date calculations, see Date and time functions.. Add or subtract time. For an overview of how to add or subtract time, see Add or subtract time.For other time calculations, see Date and time functions.. Need more help?

Microsoft 365 helps you manage and share your work schedule. New features allow you to specify more details about your work schedule: from where you’re working (remotely or in office) and whether you work different hours on different days. In addition, you’ll be able to schedule meetings with others based on their work location and view work location on people’s contact cards.

You can use a simple formula to sum numbers in a range (a group of cells), but the SUM function is easier to use when you’re working with more than a few numbers. For example =SUM(A2:A6) is less likely to have typing errors than =A2+A3+A4+A5+A6. Here’s a formula that uses two cell ranges: =SUM(A2:A4,C2:C3) sums the numbers in ranges A2:A4 and C2:C3.

A basic profile consists of one or more email accounts and a storage file. A private individual might have an Internet email account, such as a POP3 account, while corporate workers might have a Microsoft Exchange account. Accounts of other types (including IMAP4 and HTTP accounts) can be added to any profile, and so can additional storage files (such as an Archive.pst file for keeping older ...

Count the number of rows, columns, or cells in Excel by using the status bar at the bottom of the Excel screen. You can also customize the status bar.

Get started in Microsoft Teams (free). If you're just getting started, use the articles below to get yourself, friends, and family started on Microsoft Teams for personal use.

The Xbox Series X console comes with a 2-meter Ultra High Speed HDMI cable that supports HDMI 2.1 features, including 4K gaming at 120Hz. Be sure to position your console within 2 meters of your TV so this cable will reach.

Depending on your hardware, you may use the Windows Logo Key + PrtScn button as a shortcut for print screen. If your device does not have the PrtScn button, you may use Fn + Windows logo key + Space Bar to take a screenshot, which can then be printed.. To locate your screenshots, open File Explorer from the taskbar. On the side navigation pane, select the Pictures folder, and select Screenshots.

To find Sync settings, select Start , then select Settings > Accounts > Sync your settings . Choose from settings such as language preferences, passwords, and color themes. If you turn on Other Windows settings, Windows also syncs some device settings (for things like printers and mouse options), File Explorer settings, and notification preferences.