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.

In Teams, go to your Calendar . Select New meeting. Add people to the meeting. In the meeting invitation, select More options. Set meeting participants as presenters and co-organizers, as necessary. Go to Recording & transcript . Next to Who can record and transcribe, select an option from the dropdown menu.

Windows Android Mac. From the Microsoft Defender dashboard. Select Device details. Select Manage in Windows Security. Select Quick scan. Tips: If you want a deeper scan, instead of selecting Quick scan in step 3, select Scan options and choose the type of scan you want. For the most complete scan, run Microsoft Defender Offline.

OneDrive desktop app. To access your OneDrive settings, click or tap the OneDrive icon in the taskbar or notification area. If you don't see the OneDrive icon, OneDrive might not be running. On a PC, go to Start, type OneDrive in the search box, and then click OneDrive in the search results. You might need to click the Show hidden icons arrow ...

Select Classic Outlook and follow those steps instead. In your Google Calendar account, select My Calendars and choose the vertical ellipsis ( ⋮) to the right of the calendar name. Switch to your Outlook calendar. Below the calendar grid on the left, select Add calendar, then select Subscribe from web. Paste the copied URL into the address ...

To open the On-Screen Keyboard. Go to Start , then select Settings > Accessibility > Keyboard, and turn on the On-Screen Keyboard toggle. A keyboard that can be used to move around the screen and enter text will appear on the screen. The keyboard will remain on the screen until you close it. Note: To open the OSK from the sign-in screen, select ...

To do this. Press. Move to the Tell Me or Search field on the Ribbon to search for assistance or Help content.. Alt+Q, then enter the search term. Open the File page to use Backstage view.. Alt+F. Open the Home tab to use common formatting commands, paragraph styles, and the Find tool.. Alt+H. Open the Insert tab to insert tables, pictures and shapes, headers, or text boxes.

More resources. Learn common SharePoint Online tasks with these videos and tutorials, and get links to more training for SharePoint and Office 365.

Windows 11 automatically downloads and installs updates to make sure your device is secure and up to date. This means you receive the latest fixes and security updates, helping your device run efficiently and stay protected. To check for updates manually, select Start > Settings > Windows Update . Check for updates.

Select Start > Settings > System > Sound. In Input, select the microphone that you want to test. In Input settings, look at Input volume while speaking into the microphone. If the bar moves while you speak, your microphone is working properly. If don't see the bar moving, go to Test your microphone and select Start test.