Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
Filter by using advanced criteria - Microsoft Support
Using the equal sign to type text or a value. Because the equal sign (=) is used to indicate a formula when you type text or a value in a cell, Excel evaluates what you type; however, this may cause unexpected filter results.To indicate an equality comparison operator for either text or a value, type the criteria as a string expression in the appropriate cell in the criteria range:
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Change your app recommendation settings in Windows
Next to Choose where to get apps, select one of the available options.To see recommendations, select Anywhere, but let me know if there's a comparable app in the Microsoft Store.. To stop seeing app recommendations, select Anywhere.
XLOOKUP function - Microsoft Support
Use the XLOOKUP function to find things in a table or 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 2021, Excel 2021 for Mac, Excel 2019, Excel 2016, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Turn Microsoft Defender Firewall on or off - Microsoft Support
Under Microsoft Defender Firewall, switch the setting to On.If your device is connected to a network, network policy settings might prevent you from completing these steps. For more info, contact your administrator.
Create a presentation in PowerPoint - Microsoft Support
Training: Watch and learn how to create a PowerPoint presentation, add/format text, and add pictures, shapes, and/or charts.
Applies To: PowerPoint for Microsoft 365, PowerPoint 2021, PowerPoint 2019, PowerPoint 2016
Use voice typing to talk instead of type on your PC
To Insert this. Say this ' 撇 號 . 上 標 點 . 略 縮 號 -減 號 . 連 字 號 ! 感 歎 號 . 驚 嘆 號 # 井 字 號 $ 美 元 符 號 % 百 分 號
Find your IP address in Windows - Microsoft Support
For Wi-Fi connection. Select Start > Settings > Network & internet > Wi-Fi and then select the Wi-Fi network you're connected to.
Restore or reset Surface for Windows - Microsoft Support
Next to Reset this PC, select Reset PC and choose an option:. Keep my files—Reinstalls Windows 11 but keeps your personal files and any apps that came with your PC.This option removes changes you made to settings, as well as apps and drivers you installed.
April 9, 2024—KB5036893 (OS Builds 22621.3447 and 22631.3447)
Windows 11, version 23H2 ; July 25, 2024—KB5040527 (OS Builds 22621.3958 and 22631.3958) Preview; July 9, 2024—KB5040442 (OS Builds 22621.3880 and 22631.3880)
Back up your folders with OneDrive - Microsoft Support
Set up PC folder backup. Open OneDrive settings (select the OneDrive cloud icon in your notification area, and then select the OneDrive Help & Settings icon then Settings.). Open OneDrive settings (select the OneDrive cloud icon in your notification area, and then select the OneDrive Help and Settings icon then Settings.)
Applies To: OneDrive for Business, Microsoft 365 admin, OneDrive (work or school), OneDrive (home or personal), OneDrive for Mac, OneDrive for Windows