Training: In Outlook, you can export your contacts into a .pst file to make them portable and easier to move. Watch this video to learn how.

The IFS function checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition. IFS will allow you to include up to 127 pairs of conditions (the test if something is True and the result if something is true). IFS can take the place of multiple nested IF statements.

A message that is encrypted by Microsoft 365 Message Encryption is delivered to a recipient’s inbox just like any other email message. If the recipient has Outlook 2016 and a Microsoft 365 email account, they'll see an alert about the item's restricted permissions in the Reading pane.

Automate your repetitive tasks with Office Scripts in Excel for the web. Record your actions, then replay them whenever you want. You can also edit your scripts as your workflow changes. Office Scripts are stored in the cloud, letting you update any of your workbooks as needed.

Under Message organization, choose either of the options depending on whether you want to show email grouped by conversation or as individual message.. If you select Show email grouped by conversation, under Arrange the reading pane, select either of the options: Newest on top, Newest on bottom, or Show each message separately.

Office Lens is an app for all of your Windows devices. It's a great way to capture notes and info from whiteboards, menus, signs or anything with a lot of text--and even images without text.

First, copy from cell C3 to C4:C402 the formula =RAND().Then you name the range C3:C402 Data.Then, in column F, you can track the average of the 400 random numbers (cell F2) and use the COUNTIF function to determine the fractions that are between 0 and 0.25, 0.25 and 0.50, 0.50 and 0.75, and 0.75 and 1.

Type the email address of the other mailbox that you want to open and then select Open.Or, start typing and then select Search contacts and directory to find the mailbox you want to open. Select the shared mailbox you want to open, and then select Open.Another Outlook Web App session opens in a separate window, allowing access to the other mailbox.

Excel 培训列表，从入门级别到高级技能，以及模板和其他资源。

Shapes. Video: Draw shapes Video: Format shapes Draw a shape. Wrap text around a circle or other shape. Group or ungroup shapes, pictures, or other objects. Crop a picture to fit in a shape