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
Use a proxy server in Windows - Microsoft Support
If you don’t want to use the proxy server when you visit certain websites, enter the ending of the website address in the exception list (for example, *.contoso.com). For multiple websites, type each website address and separate the addresses with a semicolon (for example: *.contoso.com; *.adatum.com).The * is a wildcard so any website addresses that end with the website address listed will ...
Get started with SharePoint - Microsoft Support
See Share SharePoint files or folders in Microsoft 365 or Video: Share documents in SharePoint Server.. Share sites. If you have site owner permissions, select >Site permissions, select Add members, and then select Add members to group or Share site only.Fore more information, see Share a site.. Create a team site. If you're using Microsoft 365, you can create a site from the SharePoint start ...
Applies To: SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint Server 2016, SharePoint Server 2013 Enterprise, SharePoint in Microsoft 365, Office for business, Office 365 Small Business, Microsoft 365 admin, SharePoint Foundation 2013, SharePoint in Microsoft 365 Small Business
Windows help and learning
Find help and how-to articles for Windows operating systems. Get support for Windows and learn about installation, updates, privacy, security and more.
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 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Get started with PowerPoint for the web - Microsoft Support
With PowerPoint for the web you create presentations right in your browser. Create and save your presentations in your OneDrive, and edit and share them online.
Applies To: PowerPoint for the web
Use voice typing to talk instead of type on your PC
To Insert this. Say this ' 撇 號 . 上 標 點 . 略 縮 號 -減 號 . 連 字 號 ! 感 歎 號 . 驚 嘆 號 # 井 字 號 $ 美 元 符 號 % 百 分 號
Troubleshoot installing Office - Microsoft Support
The issues you encounter when trying to install Microsoft 365, or Office 2021, 2019, or 2016 and how you fix them depends on whether your product is part of an Office for home or Office for business plan.. In addition, with Office for business plans only admins responsible for managing Microsoft 365 in their organization can do certain tasks. Therefore, admins should view the issues and ...
Applies To: Office 2024, Office 2024 for Mac, Office 2021, Office 2021 for Mac, Office 2019, Office 2016, Microsoft 365 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, Microsoft 365 for Mac
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
Sync SharePoint files and folders - Microsoft Support
Both options allow essentially the same thing—you can access files on your local computer in File Explorer or Finder. However, adding OneDrive shortcuts allows content to be accessed on all devices, whereas sync is related to a specific device.
Applies To: SharePoint in Microsoft 365