Module Overview
This module focuses on collaboration and workbook sharing features in Microsoft Excel, helping learners work effectively with team members while maintaining document security and version consistency.
Learners will explore track changes, comments, workbook sharing, co-authoring and version control.
The module also covers protecting shared workbooks, sharing dashboards through SharePoint and OneDrive, and following effective collaboration practices.
These skills help participants manage shared business information, coordinate team activities and maintain control over important spreadsheets.
What Will Be Covered
9.1 Track Changes and Comments
Understanding the purpose of tracking changes in Excel.
Reviewing edits made to shared workbooks.
Adding comments and sharing feedback.
Monitoring updates made by team members.
Using comments and change tracking to improve team communication and accountability.
9.2 Sharing Workbooks and Co-Authoring
Understanding workbook sharing and co-authoring features.
Sharing Excel workbooks with team members.
Enabling multiple users to work on the same workbook.
Collaborating on spreadsheet data in real time.
Managing shared workbook access and editing activities.
9.3 Version Control and Compare Workbooks
Understanding version control in Excel.
Managing different versions of shared workbooks.
Comparing workbooks to identify changes.
Reviewing updates between document versions.
Maintaining consistency across shared business documents.
9.4 Protecting Shared Workbooks
Understanding the importance of protecting shared workbooks.
Applying protection settings to shared spreadsheet information.
Restricting unauthorised modifications.
Managing access to important workbook content.
Maintaining data security during team collaboration.
9.5 Sharing Dashboards through SharePoint or OneDrive
Understanding how SharePoint and OneDrive support workbook sharing.
Sharing Excel dashboards through cloud platforms.
Managing access to shared reporting files.
Making business dashboards accessible to relevant stakeholders.
Supporting collaborative reporting through cloud-based sharing.
9.6 Collaboration Best Practices
Understanding effective practices for shared workbook management.
Maintaining consistent file naming and organisation.
Managing access and editing permissions.
Following version management practices.
Improving communication and coordination when working with shared spreadsheets.
Skills You Will Gain
Tracking workbook changes and managing comments.
Sharing workbooks with team members.
Collaborating through real-time co-authoring.
Managing workbook versions and comparing changes.
Protecting shared spreadsheets from unauthorised modifications.
Sharing dashboards through SharePoint and OneDrive.
Applying effective workbook collaboration practices.
Learning Outcomes
By the end of this module, learners will be able to:
Track workbook changes and use comments to improve communication and accountability within teams.
Share workbooks and collaborate with colleagues through real-time editing.
Manage workbook versions and compare changes to maintain document consistency.
Protect shared business spreadsheets from unauthorised modifications and accidental changes.
Share dashboards through SharePoint and OneDrive to provide stakeholders with access to relevant business reports.
Apply collaboration best practices to improve teamwork, document management and reporting coordination.
Maintain better control over shared business information while supporting collaborative work.
Certification Alignment
This module develops workbook sharing, collaboration and document management skills that support the Microsoft Excel certification pathway. The concepts covered help learners manage shared spreadsheets, maintain document consistency and collaborate effectively in workplace environments.
Continue to the Next Module
Continue to Module 10: Advanced Tips, Tricks and Efficiency Techniques to learn how to customise the Excel interface, use advanced keyboard shortcuts, apply efficient copying and pasting techniques, manage large datasets and improve spreadsheet performance.
Still need help?
Contact us