Import or export text (.txt or .csv) files - Microsoft Support
Import a text file by opening it in Excel. You can open a text file that you created in another program as an Excel workbook by using the Open command. Opening a text file in Excel does not change the format of the file — you can see this in the Excel title bar, where the name of the file retains the text file name extension (for example, .txt or .csv).
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Encrypt email messages - Microsoft Support
When you need to protect the privacy of an email message, encrypt it. Encrypting an email message in Outlook means it's converted from readable plain text into scrambled cipher text.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
What is: Multifactor Authentication - Microsoft Support
How does multifactor authentication work? Let's say you're going to sign into your Microsoft account or work or school account, and you enter your username and password.If that's all you need then anybody who knows your username and password can sign in as you from anywhere in the world!
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 2021, Excel 2021 for Mac, Excel 2019, Excel 2016, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Microsoft 365 Training
Get productive quickly with Microsoft 365 videos and tutorials. Explore Microsoft 365 training guides and tips to collaborate with anyone, anywhere.
Convert numbers stored as text to numbers - Microsoft Support
Most of the time, Excel will recognize this, and you'll see an alert next to the cell where numbers are being stored as text. If you see the alert:
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel Web App
Block pop-ups in Microsoft Edge - Microsoft Support
The Microsoft Edge feature that blocks pop-ups is effective in preventing websites from automatically opening a new window or tab, or a partial window on top of your current web page. This feature is turned on by default. There are many different types of pop-ups, including advertisements, notices, offers, or alerts that can appear at various times on any web page. Some can be helpful, such as ...
Applies To: Microsoft account dashboard
Open and find items in an Outlook Data File (.pst)
Expand the top level of the Outlook data file in the Outlook Navigation pane to see the subfolders in the file. Click each subfolder to see the contents.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Use voice typing to talk instead of type on your PC
To Insert this. Say this ' 撇 號 . 上 標 點 . 略 縮 號 -減 號 . 連 字 號 ! 感 歎 號 . 驚 嘆 號 # 井 字 號 $ 美 元 符 號 % 百 分 號
Microsoft .NET Framework 4.7.2 offline installer for Windows
Issues that are fixed in this update. The following issues are fixed for .NET Framework 4.7.2. SQL Server (SQL) Fixes an issue in which the .NET Framework API SqlConnection.ConnectionString property is used to set a null or empty connection string. In this situation, a Null Reference Exception (NRE) occurs when you use the API together with .NET Framework 4.7.2.