Look up values with VLOOKUP, INDEX, or MATCH - Microsoft Support
Here's an example of how to use VLOOKUP. =VLOOKUP(B2,C2:E7,3,TRUE) In this example, B2 is the first argument—an element of data that the function needs to work.For VLOOKUP, this first argument is the value that you want to find.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Use the Office offline installer - Microsoft Support
Step 2. Install Office. Select the Microsoft 365 folder from the virtual drive and then double-click either the Setup32.exe to install the 32-bit version of Microsoft 365, or Setup64.exe to install the 64-bit version to begin the offline installation. If you're not sure which version is right for you, see Choose the 64-bit or 32-bit version of Office. ...
Applies To: Office 2021, Office 2019, Office 2016, Microsoft 365 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, Office 365 operated by 21Vianet, Office 365 operated by 21Vianet - Small Business Admin, Office 365 operated by 21Vianet - Admin, Office 365 Germany - Enterprise, Office 365 Germany - Enterprise admin
Create installation media for Windows - Microsoft Support
To create the installation media, here's what you'll need: A PC with a reliable internet connection. The download time will vary, depending on your internet connection.
Enable and disable your touchscreen in Windows - Microsoft Support
Select the Action tab at the top of the window.Select Disable device or Enable device, and then confirm.If there's more than one HID-compliant touchscreen device listed, perform steps 2–3 for that one too.
Combine text from two or more cells into one cell
Select the cell you want to combine first. Use commas to separate the cells you are combining and use quotation marks to add spaces, commas, or other text.
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, Excel Mobile
Freeze panes to lock rows and columns - Microsoft Support
To keep an area of a worksheet visible while you scroll to another area of the worksheet, go to the View tab, where you can Freeze Panes to lock specific rows and columns in place, or you can Split panes to create separate windows of the same worksheet.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Download and install Microsoft 365 Access Runtime
The Access 365 Runtime is like previous runtimes in that all design-related UI is either removed or disabled. The Access 365 Runtime includes the Access Database Engine which contains a set of components that facilitate the transfer of data between existing Microsoft Office files such as Microsoft Office Access (*.mdb and *.accdb) files and Microsoft Office Excel (*.xls, *.xlsx, and *.xlsb ...
Applies To: Access for Microsoft 365, Access 2021, Office 2021, Access 2019, Office 2019
Find settings in Windows - Microsoft Support
Find your Windows settings in a snap! Select the Start button, then select Settings .From there, browse the categories or use search to find what you're looking for.
Installing Microsoft Defender - Microsoft Support
When you first sign into Microsoft Defender on Android, we'll walk you through a few easy steps that start with setting up web protection.During this process, we'll ask you to give Defender permission to do two things: run in the background and use the Accessibility Service.
Applies To: Microsoft Defender on Android, Microsoft Defender on iOS, Microsoft Defender on Mac, Microsoft Defender on Windows
Microsoft Teams () - Microsoft
瞭解如何在 Android、iOS、Windows 和 Mac 裝置上 (免費) ,在 Microsoft Teams 中建立、編輯和自定義群組聊天。
Applies To: Microsoft Teams, Microsoft Teams personal