You can use data from a Excel worksheet as the basis for a PivotTable or PivotChart. The data should be in list format, with column labels in the first row, which Excel will use for Field Names.Each cell in subsequent rows should contain data appropriate to its column heading, and you shouldn't mix data types in the same column.

Better together tip: Manage drafts from Outlook for iOS and Outlook for Android. If you use Outlook for iOS or Outlook for Android, your drafts will automatically synchronize to your mobile device.From there, you can finish messages you've started at your computer, easily add attachments from your photos or camera, or use Office Lens to capture notes from a whiteboard in a meeting.

Adding Emojis to your conversation. Below the message box are three buttons to help you insert content into your message. The emoji button opens menus where you can quickly search for what you want.

Note: If a document has been shared with you for review, you may not be able to turn off Track Changes.If you want to edit the document without tracking changes, you’ll need to either save a copy or ask the person who sent it to you to share it again with review mode turned off.

Advanced settings - This will open the classic Windows Defender Firewall tool which lets you create inbound or outbound rules, connection security rules, and see monitoring logs for the firewall. Most people won't want to dig into it that deeply; adding, changing, or deleting rules incorrectly can cause your system to be more vulnerable or can cause some apps not to work.

The toolkit checks for updates and checks different parts of your Surface. You can skip the tests that don't apply to your issue. Tests include:

Note: No data will be lost by unlinking and re-linking your OneDrive, your local folders are just disconnected from the cloud for a short while.Any changes made while you're unlinked will be synced once re-linking is complete.

In this example, the formula in cell D2 says: IF(C2 = 1, then return Yes, otherwise return No)As you see, the IF function can be used to evaluate both text and values.It can also be used to evaluate errors.You are not limited to only checking if one thing is equal to another and returning a single result, you can also use mathematical operators and perform additional calculations depending on ...

View previous versions of a file. If your file is stored in OneDrive or SharePoint in Microsoft 365, you can go back to a previous version of file.

To check on the recall in classic Outlook. After submitting a recall request, usually less than 30 seconds later, you will get an email notification with the subject "Message Recall Report for message [original message subject]".