XLOOKUP function - Microsoft Support
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.
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
What is OneDrive? (work or school) - Microsoft Support
Training: With OneDrive, you can securely store your pictures and files, share and collaborate with others, and get to your files from anywhere - on your computer, laptop, tablet, or phone.
Applies To: OneDrive for Business, SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint Server 2016, Office for business, OneDrive (work or school), OneDrive for Mac, OneDrive for Windows
Sign-in options in Windows - Microsoft Support
Dynamic lock is a security feature that automatically locks your device when you are not around. It uses Bluetooth to pair with a phone, and locks the device when the Bluetooth signal drops below a certain level, indicating that you are no longer near your device.
Change the power mode for your Windows PC - Microsoft Support
Note: You might not be able to change the power mode when a custom power plan is selected.If you can’t set the power mode in Power & battery settings, open Control Panel, select System and Security > Power Options, then choose a Balanced power plan.
Tips to free up drive space on your PC - Microsoft Support
Swipe in from the right edge of the screen, tap Settings, and then tap Change PC settings. (If you're using a mouse, point to the lower-right corner of the screen, move the mouse pointer up, click Settings, and then click Change PC settings.)
Descargar e instalar o reinstalar Office 2019, Office 2016 u Office ...
Si esta es la primera vez que va a instalar Microsoft 365, es posible que primero tenga que realizar algunos pasos de configuración. Expanda la sección siguiente para obtener más información. Sin embargo, si va a reinstalar Microsoft 365, y ya ha canjeado una clave de producto y tiene una cuenta asociada a Microsoft 365, vaya a la sección iniciar sesión para descargar Office.
Applies To: Office 2019, Office 2016, Office 2016 for Mac, Office 2013
Turn on device encryption - Microsoft Support
In the search box on the taskbar, type Manage BitLocker and then select it from the list of results. Or, select the Start button, and then under Windows System, select Control Panel.In Control Panel, select System and Security, and then under BitLocker Drive Encryption, select Manage BitLocker. Note: You'll only see this option if BitLocker is available for your device.
Change your background in Microsoft Teams meetings
If you want to change what appears behind you in your video meeting or call, you can either blur your background, replace it entirely with any image you want, or use Teams virtual background template.And with a Teams Premium license, you can change your Teams meeting background to a branded logo or image specific to your company.
Applies To: Microsoft Teams
Repair apps and programs in Windows - Microsoft Support
Repair programs in Control Panel. Select the Advanced options link under the name of the app (some apps don't have this option). On the page that opens, select Repair if it's available.If it isn't available or doesn't fix the problem, select Reset.
Create films with a video editor - Microsoft Support
For fast and simple editing, we've added Clipchamp as the official Microsoft video editor. Microsoft Clipchamp comes preinstalled on Windows 11 devices. To open Clipchamp, go to the search box on the taskbar, type Clipchamp, and select it from the results.Or you can select Start , then select All apps and scroll down to find Clipchamp in the list of apps.