使用 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
What's new in Access 2021 - Microsoft Support
Access 2021 lets you build and share a database in seconds. You supply the information and Access does the rest, making it easy to create and structure your data.
Applies To: Access 2021
How to set up and use Indic Phonetic keyboards
Click on the + icon labelled and add the preferred Indic language (by selecting into the search box and select it – for example “Hindi” and click on the next button and install the Indic language on the device, which will then return to the Language page).
Create a shareable link - Microsoft Support
Training: Learn how to create a shareable link to make it easy to share files in a document, email, or IM.
Applies To: Office for business
Block or unblock senders in Outlook - Microsoft Support
Notes: If you have existing lists of safe names and addresses, you can move that information into Outlook. Click Import from File and browse for the list file that you want. To create a file that uses your current list, click Export to File and then specify where you want the new file saved.. To change a name on the list, click the name that you want to change and then click Edit.
Applies To: New Outlook for Windows
How to download and install the latest printer drivers
If Windows Update finds an updated driver, it will download and install it, and your printer will automatically use it. If a device driver couldn’t be installed automatically, there may be an optional driver available that your printer can use.
Change the Normal template (Normal.dotm ) - Microsoft Support
Make any changes that you want to the fonts, margins, spacing, and other settings. You can use the same commands and features that you use to change a document — but remember that any changes that you make to Normal.dotm will be applied to documents that you create in the future.
Applies To: Word for Microsoft 365, Word 2021, Word 2019, Word 2016, Word 2013
Enable TPM 2.0 on your PC - Microsoft Support
How to enable TPM. If you need to enable TPM, these settings are managed via the UEFI BIOS (PC firmware) and vary based on your device. You can access these settings by choosing: Settings > Update & Security > Recovery > Restart now. From the next screen, choose Troubleshoot > Advanced options > UEFI Firmware Settings > Restart to make the changes.
Connect to a Wi-Fi network in Windows - Microsoft Support
Whether you're at home, work, or out and about, chances are you'll find a Wi-Fi network that you can connect to for internet access. Select the Network, Sound, or Battery icons ( ) on the far right side of the taskbar to open quick settings. The Disconnected icon appears when you’re not connected.
Get help with a digital code or gift card | Xbox Support
All Xbox digital codes are 25 characters long, include both numbers and letters, and are formatted in five blocks of five characters (xxxxx-xxxxx-xxxxx-xxxxx-xxxxx).