使用 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
See what's on the Start menu - Microsoft Support
Get started. To pin your favorite apps to the Start menu, select and hold (or right-click) the app you want to pin. Then select Pin to Start .. To group your apps into folders, simply drag an app on top of another with mouse or touch or highlight the app with your keyboard and use the Ctrl + Shift + <Left or Right arrow> keyboard shortcut.. Your apps and programs—right at your fingertips
Troubleshoot the Teams Meeting add-in in Outlook for Windows
The Teams Meeting add-in lets you schedule a Teams meeting from Outlook. The add-in is available for Outlook on Windows, Mac, web, and mobile, and should be automatically installed if you have Microsoft Teams and either Office 2016, Office 2019, or Office 2021 installed on your Windows PC.
Applies To: Outlook 2021, Outlook 2019, Outlook 2016
Change mouse settings - Microsoft Support
To speed up the process of selecting a choice when a dialog box appears, under Snap To, select the Automatically move pointer to the default button in a dialog box check box.(Not all programs support this setting. In some programs, you'll need to move the mouse pointer to the button you want to click.)
Set up an authenticator app as a two-step verification method
Note: If you receive a prompt asking whether to allow the app to access your camera (iOS) or to allow the app to take pictures and record video (Android). select Allow so the authenticator app can access your camera to take a picture of the QR code in the next step.If you don't allow the camera, you can still set up the authenticator app as described in Manually add an account to the app.
Connect your PC to your Xbox One console - Microsoft Support
Note: if you need to find your console's name, on the console, press the Xbox button to open the guide, and then select Profiles & system (your account icon) > Settings > System > Console info.If you need to find its IP address, in Settings, choose General > Network settings > Advanced settings.
Get help with your Microsoft account - Microsoft Support
Billing & payments. Your dashboard is also where you can: Buy, renew, or cancel a subscription.
Applies To: Microsoft account dashboard
Use your Windows PC as a mobile hotspot - Microsoft Support
Turn your Windows PC into a mobile hotspot by sharing your internet connection with other devices over Wi-Fi. You can share a Wi-Fi, Ethernet, or cellular data connection.
Switch between languages using the Language bar
For more information about adding additional editing languages and keyboard layouts see Change the language Office uses in its menus and proofing tools.. Using the Language bar to Switch Keyboard Layouts. When you switch a language by using the Language bar, the keyboard layout changes to the keyboard for that language.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, Project Online Desktop Client, Publisher for Microsoft 365, Visio Plan 2, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Project Professional 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, OneNote 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Project Professional 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Visio Standard 2016
Change the power mode for your Windows PC - Microsoft Support
Note: You might not be able to change the power mode when a custom power plan is selected.If you can’t set the power mode in Power & battery settings, open Control Panel, select System and Security > Power Options, then choose a Balanced power plan.