Zip and unzip files - Microsoft Support
Press and hold (or right-click) the file or folder, select (or point to) Send to, and then select Compressed (zipped) folder. A new zipped folder with the same name is created in the same location.
使用 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
Create a PivotTable to analyze worksheet data - Microsoft Support
Get from External Data Source. Get from Data Model. Use this option if your workbook contains a Data Model, and you want to create a PivotTable from multiple tables, enhance the PivotTable with custom measures, or are working with very large datasets.. Get from Power BI. Use this option if your organization uses Power BI and you want to discover and connect to endorsed cloud datasets you have ...
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
Turn Windows Security on or off - Microsoft Support
Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.
Troubleshooting offline printer problems in Windows
To find out if your printer is connected to Wi-Fi, see if your printer's built-in menu has options for checking its Wi-Fi connection, or check the printer's manual for instructions about how to add it to a Wi-Fi network.
How to use Remote Desktop - Microsoft Support
Learn how to use Remote Desktop in Windows. On your Windows, Android, or iOS device: Open the Remote Desktop app (available for free from Microsoft Store, Google Play, and the Mac App Store), and add the name of the PC that you want to connect to (from Step 1). Select the remote PC name that you added, and then wait for the connection to complete.
Basic tasks in Excel - Microsoft Support
Get started with basic tasks in Excel such as opening a workbook, entering and formatting data, calculating data, and trying some quick analysis features..
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Excel video training - Microsoft Support
A list of Excel training, from entry level to advanced skills, plus templates and other resources.
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 2016
Mouse and keyboard problems in Windows - Microsoft Support
Check the device. If the device doesn't appear to work at all (no lights appear on the device when it’s plugged in, or the cursor doesn't move or doesn't appear on the screen), connect the device to another PC and make sure the device works on that PC.
Import photos and videos - Microsoft Support
Note for iPhone: If you are having trouble with your iPhone import, make sure your device is unlocked and you’ve accepted the permissions. Note for Android and other devices: If you’re using an Android phone or other device and import isn’t working, you might need to change your phone’s USB settings from Charging over USB to Transfer Files or Transfer Photos.