Excel 365: Collaborate in Excel

Course description

This course demonstrates how to collaborate effectively within Excel 365, covering modern tools for communication, version control, and sharing. Learners are introduced to the differences between traditional notes and modern threaded comments, gaining insight into how threaded conversations can be used to provide feedback and context directly within a workbook. The process for inserting, replying to, and resolving comments is shown alongside options for viewing all discussions within the comment pane. The course also explores how to control the printing of comments and worksheet errors, providing users with the flexibility to customize printouts for clearer communication. Sharing options are examined in both legacy and modern contexts, with a focus on cloud-based collaboration through OneDrive and SharePoint. Users learn how to manage sharing permissions, enable co-authoring, and monitor who is accessing a shared workbook. The course also revisits legacy tools like Track Changes, showing how they can be activated and used to monitor cell-level edits—especially valuable when detailed revision history is needed. Additionally, version history within OneDrive is covered, allowing users to explore, restore, or manage previous iterations of a file without leaving Excel. Finally, learners are shown how to send copies of workbooks via email in Excel or PDF format, understanding the implications of distribution versus real-time collaboration. This course equips users with practical techniques to streamline collaboration and maintain control in shared Excel environments.

Course outline