With Power Query (known as Get & Transform in Excel), you can import or connect to external data, and then shape that data, for example remove a column, change a data type, or merge tables, in ways that meet your needs. Then, you can load your query into Excel to create charts and reports.

Get answers to all of your Microsoft Word questions. Find Word help, how-to articles, training videos, tutorials, and more.

Training: Learn how to get up and productive quickly with this Microsoft Teams Quick Start. Sign in to Teams, select Teams and Channels, reply to conversation threads, @mention someone, use emojis and stickers, and ask T-Bot questions.

Problem: The lookup value is not in the first column in the table_array argument. One constraint of VLOOKUP is that it can only look for values on the left-most column in the table array.

Know your limits Many email service providers set limits for the number of names that can be included in the To, Cc, and Bcc boxes in a message. For example, your email service provider may limit each message to a maximum of 100 email addresses. If these addresses are distributed among the To, Cc, and Bcc boxes, remember that the names in the Bcc box will count toward your total limit.

Sign out of Teams. While it's a good idea to remain signed in to continue receiving chats, notifications, incoming calls, and other activities, sometimes you might want to sign out of Teams to use another account or for other reasons.

注意: 如果知道密码，但只想更改密码，请转到“account.microsoft.com 安全”选项卡，然后选择“更改我的密码”。. 如果知道用户名和密码但已停止工作，请阅读我的用户名和密码已停止工作。

Then, create REG_SZ values in this key for each form you wish to allow scripts to run. In the above example, you would create a REG_SZ value named “IPM.Note.Custom” with empty data. When designing a form, Run This Form will run a form using the message class of the base form. So if you started designing an IPM.Note form and want to Run This Form, you will need to have IPM.Note registered.

Select a condition, and what to do with the message based on the condition. For example, to move messages with a certain title to a specific folder, select the Subject contains condition, select Move the item to folder, select or create a New folder, and then select OK.

The Snap feature is a great way to improve your productivity by sharing many app windows in a single screen. Different layouts are available with many sizes to choose from, so you can get the most from your favorite apps when you are working on specific tasks.