VLOOKUP function - Microsoft Support
Argument name. Description. lookup_value (required). The value you want to look up. The value you want to look up must be in the first column of the range of cells you specify in the table_array argument. For example, if table-array spans cells B2:D7, then your lookup_value must be in column B.. Lookup_value can be a value or a reference to a cell.. table_array (required)
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016
Send large files with Outlook - Microsoft Support
Compress the file. When you compress, or zip, your file, it decreases its size, and it might decrease it enough to fit within the Outlook size limits for attachments.The following articles describe how to compress and extract files for different Windows operating systems.
Applies To: Outlook for Microsoft 365, Outlook 2024, Outlook 2021, Outlook 2019, Outlook 2016
Change the refresh rate on your monitor in Windows
Battery Life: Lowering your refresh rate can save battery power by reducing the amount of energy your display consumes.This can be useful when you are using a laptop or tablet and want to extend your battery life.
Phone Link help & learning
Introducing Microsoft Phone Link Our evolution of the former Your Phone app brings a new name to the user experience. With the new Phone Link on your Windows PC and the new Link to Windows app on your Android device, accessing your mobile apps and content has never been easier!
Location and privacy in Microsoft Edge - Microsoft Support
How Microsoft Edge interacts with operating system permissions when sharing your location with a website. Windows can use information such as your IP address, nearby Wi-Fi access points, and GPS data, if available, to estimate your precise or imprecise location coordinates and pass this info to Microsoft Edge.
Applies To: Microsoft account dashboard
Microsoft account security info & verification codes
Notes: You can add up to 10 different ways to verify sign-in, choosing from: An email address or phone number. It doesn't have to be yours - you just need to be able to access it if you want to use it to verify your account.
Applies To: Microsoft account dashboard
Browsing history on the privacy dashboard - Microsoft Support
Why am I not seeing all my data on the privacy dashboard? To learn more about why you might not be seeing all of your data, see View your data on the privacy dashboard.. Legacy version of Microsoft Edge
How to add an account in OneDrive - Microsoft Support
To add a personal or work/school account to OneDrive on your pc. Open OneDrive settings (select the OneDrive cloud icon in your notification area, and then select the OneDrive Help and Settings icon then Settings.)
Applies To: OneDrive for Business 24, OneDrive for Business, OneDrive (work or school), OneDrive (home or personal), OneDrive (work or school) operated by 21Vianet, OneDrive for Mac, OneDrive for Windows
Add flair to your email with emojis - Microsoft Support
In the Windows emoji picker, you can either scroll through the list, use the category icons at the top or bottom of the emoji picker, or type a keyword to search for the emoji you want.
Applies To: Outlook for Microsoft 365, Outlook 2024, Outlook 2021, Outlook 2019, Outlook 2016
Troubleshooting verification code issues - Microsoft Support
When you see a message asking you to make sure you can receive a verification code, verify or add new security info. You can skip it for 24 hours at a time, but after seven days from the first notice you'll have to verify or add new security info before you can sign in again.
Applies To: Microsoft account dashboard