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 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Transcribe your recordings - Microsoft Support
The transcribe feature converts speech to a text transcript with each speaker individually separated. After your conversation, interview, or meeting, you can revisit parts of the recording by playing back the timestamped audio and edit the transcription to make corrections.
Applies To: Word for Microsoft 365, OneNote for Microsoft 365, Word for the web
How to use Remote Desktop - Microsoft Support
Learn how to use Remote Desktop in Windows. On your Windows, Android, or iOS device: Open the Remote Desktop app (available for free from Microsoft Store, Google Play, and the Mac App Store), and add the name of the PC that you want to connect to (from Step 1). Select the remote PC name that you added, and then wait for the connection to complete.
App permissions - Microsoft Support
Here's more info on what permissions allow an app to do: Access all your files, peripheral devices, apps, programs, and registry: The app has the ability to read or write to all your files (including documents, pictures, and music) and registry settings, which allows the app to make changes to your computer and settings. It can use any peripheral devices that are either attached or part of ...
Fix microphone problems - Microsoft Support
If you want to give access to desktop apps, make sure that Let desktop apps access your microphone is turned on.You can't turn off microphone access for individual apps. Others can't hear me. Try the following solutions:
Block pop-ups in Microsoft Edge - Microsoft Support
The Microsoft Edge feature that blocks pop-ups is effective in preventing websites from automatically opening a new window or tab, or a partial window on top of your current web page. This feature is turned on by default. There are many different types of pop-ups, including advertisements, notices, offers, or alerts that can appear at various times on any web page. Some can be helpful, such as ...
Applies To: Microsoft account dashboard
Turn Microsoft Defender Firewall on or off - Microsoft Support
Under Microsoft Defender Firewall, switch the setting to On.If your device is connected to a network, network policy settings might prevent you from completing these steps. For more info, contact your administrator.
Install Office 2007 - Microsoft Support
When prompted, enter the product key. You can find the product key on the sticker on the CD case or other packaging. If you need help, see Find your Product Key for Office 2007.
Applies To: Office 2007
Use the On-Screen Keyboard (OSK) to type - Microsoft Support
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.
Pin apps and folders to the desktop or taskbar - Microsoft Support
To pin apps to the taskbar. Select Start , select the arrow next to All apps, right-click the app, then select More > Pin to taskbar.