Collaborate on Excel workbooks at the same time with co-authoring
You and your colleagues can open and work on the same Excel workbook. This is called co-authoring. When you co-author, you can see each other's changes quickly—in a matter of seconds. And with certain versions of Excel, you'll see other people's selections in different colors.
Share your documents - Microsoft Support
Creating a shareable link makes it simple to share a document in an email, document, or IM. Select Share. Select Link settings if you want to change permissions. Select Copy Link and share the link however you want, like in an email, document, or IM.
Restrict changes to files in Excel - Microsoft Support
If you don't want content reviewers to accidentally change a Word document or an Excel spreadsheet, you can use formatting and editing restrictions. Note: To further restrict reviewers from making changes to your document or spreadsheet, you can make the file read-only or you can password protect it.
Check out, check in, or discard changes to files in a SharePoint ...
If you check out a file and don’t make changes to it, or you make changes that you don’t want to keep, you can simply discard the checkout, rather than saving the file. If your organization tracks versions, a new version is created each time you check a file back into the library.
Share your Microsoft 365 Family subscription - Microsoft Support
Microsoft 365 Family subscribers can share subscription benefits with up to five other people in their family group by sending an email or copying & sharing a link. Important: Sharing is only possible if the invitee joins the subscription owners' family group.
Share your Microsoft 365 Family subscription - Microsoft Support
Microsoft 365 Family subscribers can share subscription benefits with up to five other people in their family group by sending an email or copying & sharing a link. Important: Sharing is only possible if the invitee joins the subscription owners' family group.
COUNTIF function - Microsoft Support
Use COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list. In its simplest form, COUNTIF says: =COUNTIF (Where do you want to look?, What do you want to look for?) For example: =COUNTIF (A2:A5,"London") =COUNTIF (A2:A5,A4)