使用 VLOOKUP、INDEX 或 MATCH 查找值 - Microsoft 支持
使用 vlookup、hlookup 和其他函数（如 index 和 match）根据您输入的值搜索和查找数据。 本文将让您快速回顾 vlookup，然后链接到更多内容。
Applies To:
Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Getting started with the new Outlook for Windows
Not sure which version you're currently running, see What version of Outlook do I have? Classic Outlook on Windows. If your accounts are supported in the new Outlook for Windows, you'll see a toggle in the upper right of classic Outlook to Try the new Outlook.. Selecting this toggle will download the new app and let you switch to the preview.
Applies To:
New Outlook for Windows
Add a printer or scanner in Windows - Microsoft Support
Wait for it to find nearby printers, then locate the one you want to use, and select Add device.If you want to remove the printer later, select it, and then select Remove.
Filter junk email and spam in Outlook - Microsoft Support
When you mark email as junk, you can report the message to Microsoft to help improve the accuracy of the junk email filter. To set junk email reporting options, select Settings > Mail > Automatic processing > Junk email reporting.. Specify when to send junk email reports
Applies To:
Office for business, Office 365 Small Business, New Outlook for Windows, Outlook on the web for Exchange Server 2016, Outlook on the web for Exchange Server 2019
OneDrive help & learning
Explore OneDrive support, help, and learning resources. Learn how to protect your important files, documents, and memories with OneDrive.
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
Sign in and start apps from the My Apps portal - Microsoft Support
Download and install the My Apps Secure Sign-in Extension. Download and install the My Apps Secure Sign-in Extension, if you're prompted. This extension helps you use your desktop browser to use single sign-on with your organization's cloud apps.
LOOKUP function - Microsoft Support
Vector form. The vector form of LOOKUP looks in a one-row or one-column range (known as a vector) for a value and returns a value from the same position in a second one-row or one-column range.. Syntax. LOOKUP(lookup_value, lookup_vector, [result_vector]) The LOOKUP function vector form syntax has the following arguments:. lookup_value Required.A value that LOOKUP searches for in the first vector.
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
Fix your Outlook email connection by repairing your profile
On the Email tab, choose your account (profile), and then choose Repair.
Applies To:
Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Office for business, Office 365 Small Business, Microsoft 365 admin
Manage cameras with Camera settings in Windows 11
Note: Some cameras won't appear in the Camera settings page.These include infrared (IR) cameras used for Windows Hello Face authentication, cameras using DirectShow technology (like many apps provided by DSLR or action camera manufacturers so their devices can be used as webcams), and proprietary cameras that aren't managed by Windows—such as industrial cameras and many networked cameras.