使用 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
Find and lock a lost Windows device - Microsoft Support
Turn on Find my device. When you set up a new device, you can decide whether to turn on or turn off the Find my device setting. If you turned it off during setup and now want to turn it on, make sure your Windows device is connected to the internet, has enough battery power so it can send its location, and that you're signed in to the device using your Microsoft account.
Applies To: Microsoft account dashboard
How to go passwordless with your Microsoft account
Going passwordless refers to removing your password and using a passwordless method to sign in instead. Passwordless solutions such as Windows Hello, the Microsoft Authenticator app, SMS or Email codes, and physical security keys provide a more secure and convenient sign-in method. While passwords can be guessed, stolen, or phished, only you can provide fingerprint authentication, or provide ...
Applies To: Microsoft account dashboard
Troubleshoot Surface Type Cover or Keyboard - Microsoft Support
You'll see the logo screen on your screen. Continue to hold the Volume Up button. Release the button when the UEFI screen appears. If you have a Windows Pro/Enterprise device (not a Windows Home device), you can then toggle off Type Cover port from the Devices menu and exit UEFI. Re-enter UEFI (press power + Volume Up) and toggle Type Cover port back on, then check if the Keyboard works in UEFI.
Snap your windows - Microsoft Support
The Snap feature is a great way to improve your productivity by sharing many app windows in a single screen. Different layouts are available with many sizes to choose from, so you can get the most from your favorite apps when you are working on specific tasks.
Getting started with Microsoft Family Safety - Microsoft Support
A family group is a set of individuals connected through the Microsoft Family Safety app on their Windows, Xbox, or mobile devices. Establishing a family group is an easy, effective way to encourage healthy online habits and manage busy schedules.
Applies To: Microsoft Family Safety
Sign in to sync Microsoft Edge across devices
When you sign in to sync to Microsoft Edge , you can easily browse the web from any of your devices, keep your favorites organized, and always pick up right where you left off.. Sign in to sync your account on your computer Setting up sync on your computer. In Microsoft Edge, select the profile image in the browser taskbar.
Play, share, and download a meeting recording in Microsoft Teams
Depending on the length of the video, generating closed captions can take several minutes. Once generated, you can watch the video in Stream and have captions displayed at the bottom of the screen.. When the caption have been created, the Generate button turns to Translate.Select Translate to change the spoken or screen language to automatically translate the captions.
Applies To: Microsoft Teams
Help with the Microsoft account recovery form
2. Fill out the form using a recognized device and location. If possible, complete the form using a device you previously used to sign into your account and at a location where you commonly use that device and that we'll recognize, such as your home or office.
Use Image Creator in Paint to generate AI art - Microsoft Support
Using Image Creator. To use Image Creator, open Microsoft Paint and select the Image Creator icon on the toolbar to see the side panel.In the text box, enter a description of the image you want to create. For example, you can type "a blue cat with a red hat" or "a landscape with mountains and a lake".