Training: Watch these videos to help your school, work, or organization use Microsoft Teams to video conference, work remotely, and become proficient using Teams.

In the Cell link box, enter a cell reference that contains the current state of the option button.. The linked cell returns the number of the selected option button in the group of options. Use the same linked cell for all options in a group.

Data sources. Your first step in setting up a mail merge is to pick the source of data you'll use for the personalized information. Excel spreadsheets and Outlook contact lists are the most common data sources, but if you don't yet have a data source, you can type it up in Word, as part of the mail merge process.

Text recognition in images is enhanced, including handwriting recognition, and overall image descriptions are better. To experience the improved experience, navigate to any image and, while the image is in focus, execute the keyboard combination "Narrator key+CTRL+d “. . An active internet connection is necessary for this feature, and Narrator settings must have the option to obtain Image ...

Total row Once you add a total row to a table, Excel gives you an AutoSum drop-down list to select from functions such as SUM, AVERAGE, and so on.When you select one of these options, the table will automatically convert them to a SUBTOTAL function, which will ignore rows that have been hidden with a filter by default.

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.

Optimizations for windowed games improves gaming on your PC by using a new presentation model for DirectX 10 and DirectX 11 games that appear in a window or in a borderless window.

Microsoft Editor is an AI-powered service that helps bring out your best writer in more than 20 languages, whether you are writing a Word doc, composing an email message, or posting on a website like LinkedIn or Facebook.

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.

Share your file with others. To invite other people to access your PowerPoint file and collaborate, take these steps: With the presentation open, select the Share button in the top right corner of the ribbon. If you have not yet stored your presentation to OneDrive or SharePoint in Microsoft 365, a message will direct you to do so.