XLOOKUP function - Microsoft Support
Use the XLOOKUP function when you need to find things in a table or a range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term, and return a result from the same row in another column, regardless of which side the return column is on.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Import your favorites in Microsoft Edge - Microsoft Support
Keep your favorites here or drag them to wherever you want. You can also create, delete, or rename your favorites folders. To arrange favorites alphabetically, press and hold (or right-click) any item in the list.
Choose language settings for your keyboard, websites, and apps
Select Add a keyboard and choose the keyboard you want to add. If you don't see the keyboard you want, you may have to add a new language to get additional options. If this is the case, go on to step 4.
Free up drive space in Windows - Microsoft Support
Find out how to free up space on your device by deleting unnecessary files, uninstalling apps, and moving files to other drives.
Count how often a value occurs - Microsoft Support
The COUNTIFS function is similar to the COUNTIF function with one important exception: COUNTIFS lets you apply criteria to cells across multiple ranges and counts the number of times all criteria are met. You can use up to 127 range/criteria pairs with COUNTIFS. The syntax for COUNTIFS is: COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2],…)
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Enable virtualization on Windows - Microsoft Support
Virtualization lets your Windows device emulate a different operating system, like Android or Linux. Enabling virtualization gives you access to a larger library of apps to use and install on your device.
Sync OneDrive files and folders - Microsoft Support
Work with your files in your file system. Once you're synced, you’ll see your files in File Explorer. On a Mac, your files will appear under OneDrive in the Mac Finder.. If you use more than one account, your personal files appear under OneDrive – Personal and your work or school files appear under OneDrive - CompanyName.. You can copy or move files from your computer to OneDrive right ...
Applies To: OneDrive (home or personal), OneDrive for Mac, OneDrive for Windows
How to adjust power and sleep settings in Windows
To adjust power and sleep settings in Windows 11, select Start > Settings > System > Power & battery > Screen, sleep, & hibernate timeouts. Turn my screen off after: Select how long you want your device to wait before turning the screen off when you're not using your device, both when it's plugged in and when it's on battery power.
下载 Internet Explorer 11(脱机安装程序) - Microsoft 支持
Microsoft Edge 是 Microsoft 推荐的浏览器. 对 Internet Explorer 的支持已于 2022 年 6 月 15 日结束。 如果访问的任何网站需要 Internet Explorer 11,则可以在 Microsoft Edge 中使用 Internet Explorer 模式重新加载它。
Contact - Microsoft Support
Contact Microsoft Support. What's new. Surface Pro; Surface Laptop; Surface Laptop Studio 2