Create installation media for Windows - Microsoft Support
You can use installation media (a USB flash drive or DVD) to install a new copy of Windows, perform a clean installation, or reinstall Windows. To create installation media, go to the software download website, where you'll find step-by-step instructions.
Activate Office - Microsoft Support
Select your version of Microsoft 365 below to learn how to activate Microsoft 365. Activate Microsoft 365 or a non-subscription version of Office. Activate Office that's pre-installed on a new Windows device. Activate an Office purchase or offer that's included on a new Windows device.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, OneNote for Microsoft 365, Publisher for Microsoft 365, Visio Plan 2, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, Office 2021, OneNote 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Office 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Publisher 2016, Office 2016, Microsoft 365 for home, Office for business, Microsoft 365 admin, Project for Office 365
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft Support
The VLOOKUP and HLOOKUP functions, together with INDEX and MATCH,  are some of the most useful functions in Excel. Note: The Lookup Wizard feature is no longer available in Excel. Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE) In this example, B2 is the first argument —an element of data that the function needs to work.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Pin apps and folders to the desktop or taskbar - Microsoft Support
To pin apps to the taskbar. Select Start , select the arrow next to All apps, right-click the app, then select More > Pin to taskbar. If the app is already open on the desktop, press and hold (or right click) the app's taskbar icon, and then select Pin to taskbar.
Ways to install Windows 11 - Microsoft Support
Create Windows 11 installation media. On the Windows 11 software download page, select Create tool now and follow the instructions to install Windows 11. Warning: Microsoft recommends against installing Windows 11 on a device that does not meet the Windows 11 minimum system requirements.
Fix sound or audio problems in Windows - Microsoft Support
Fix your audio drivers. Hardware problems can be caused by outdated or malfunctioning drivers. Make sure your audio driver is up to date and update it if needed. If that doesn't work, try uninstalling the audio driver (it will reinstall automatically).
Windows Update Troubleshooter - Microsoft Support
If you get an error code while downloading and installing Windows updates, the Update Troubleshooter can help resolve the problem. Select Start > Settings > System > Troubleshoot > Other troubleshooters. Next, under Most frequent, select Windows Update > Run.
How to check if your device meets Windows 11 system requirements after ...
Installing Windows 11 on devices that don't meet minimum system requirements. If you changed your hardware in order to upgrade to Windows 11 and the system is not recognizing the change in a timely manner, this article explains how to initiate the assessment manually.
Uninstall Office from a PC - Microsoft Support
The following steps describe how to uninstall Microsoft 365 products on a PC (laptop, desktop, or 2-in-1). For Mac, see Uninstall Office for Mac. Tip: Uninstalling Microsoft 365 only removes the Microsoft 365 applications from your computer, it doesn't remove any files, documents, or workbooks you created using the apps.
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
使用 VLOOKUP、INDEX 或 MATCH 查找值 - Microsoft 支持
VLOOKUP 和 HLOOKUP 函数,以及 INDEX 和 MATCH 是 Excel 中一些最有用的函数。. 注意: Excel 中不再提供“查找向导”功能。. 下面是如何使用 VLOOKUP 的示例。. =VLOOKUP (B2,C2:E7,3,TRUE) 在此示例中,B2 是第一个 参数,即函数运行所需的数据元素。. VLOOKUP 第一个参数是要查找的 ...
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016