XLOOKUP function - Microsoft Support
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.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Add or delete notifications or reminders in Outlook
In Outlook, you have the option to: Snooze or dismiss events or tasks | Turn the notifications on or off | Add reminders to events | Add reminders to tasks | Troubleshoot notifications. Snooze or dismiss an event or task. With the reminders window, you can select to snooze calendar events and tasks, join a Teams meeting, or dismiss events and tasks.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Outlook on the web, New Outlook for Windows
Available number formats in Excel - Microsoft Support
Format. Description. General. The default number format that Excel applies when you type a number. For the most part, numbers that are formatted with the General format are displayed just the way you type them. However, if the cell is not wide enough to show the entire number, the General format rounds the numbers with decimals. The General number format also uses scientific (exponential ...
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Create a new workbook - Microsoft Support
A workbook is a file that contains one or more worksheets to help you organize data. You can create a new workbook from a blank workbook or a template. By default, a new workbook contains three worksheets, but you can change the number of worksheets that you want a new workbook to contain. You can also add and remove worksheets as needed.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016, Excel 2013
Microsoft Teams video training - Microsoft Support
Training: Watch these videos to help your school, work, or organization use Microsoft Teams to video conference, work remotely, and become proficient using Teams.
Applies To: Microsoft Teams
Welcome to your email - Microsoft Support
Change the appearance of your email. Select View.. From here, you can: Change the size of the Folder Pane.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Introduction to Outlook Data Files (.pst and .ost)
Note: In earlier versions of Outlook, IMAP accounts also used an Outlook Data File (.pst).In Outlook 2016 and Outlook for Microsoft 365, IMAP accounts use Offline Outlook Data Files (.ost). You can also use an Outlook Data File (.pst) to backup or export items from any type of email account.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Sign in to Xbox | Xbox Support
On the Choose an account screen, click the Microsoft account button.; On the Add your Microsoft account screen, enter the email address and password associated with your Microsoft account.; On the Make it yours screen, you'll have the option to make this Microsoft account your primary account. (This makes sign-in, settings, and syncing happen automatically for all other Microsoft services.)
Sync OneDrive files and folders - Microsoft Support
Work with your files in your file system. Once you're synced, you’ll see your files in File Explorer. On a Mac, your files will appear under OneDrive in the Mac Finder.. If you use more than one account, your personal files appear under OneDrive – Personal and your work or school files appear under OneDrive - CompanyName.. You can copy or move files from your computer to OneDrive right ...
Applies To: OneDrive (home or personal), OneDrive for Mac, OneDrive for Windows
How to use Surface UEFI - Microsoft Support
Note: UEFI passwords are used primarily by enterprises and IT professionals to limit the types of changes that employees can make to their devices.If you're part of an enterprise, contact your IT administrator if you have any questions or issues with your UEFI password. If you aren't part of an enterprise and choose to create a UEFI password, make sure to document your password in a safe place.