Sharing & Collaborating on a Document in Excel 2019 for Windows
Excel 2019 (Windows)
| Beginner
- 7 videos | 25m 57s
- Includes Assessment
- Earns a Badge
- CPE
Excel 2019 enables one to easily share documents via email or upload them to OneDrive and SharePoint for team collaboration. During this course, you will learn how to share your spreadsheet, or send it as a .xls or .pdf in Excel. You will learn how to set its editing permissions and send a link. Other topics include how to view your shared documents and save your Excel documents online with OneDrive, so that collaborators can check out a document to prevent others from working on it at the same time. Explore how to coordinate document modification to allow collaborators to make comments, and track document changes. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Sharing & Collaborating on a Document Exercise as well as the associated materials in the Resources section.
WHAT YOU WILL LEARN
-
Send your spreadsheet via email in excel 2019
Share your workbook via a link in excel 2019
Manage link access and permissions in excel 2019
Save your files to onedrive in excel 2019 -
Manage an excel 2019 workbook's version history
Comment on a spreadsheet in excel 2019
Follow and track document changes in excel 2019
IN THIS COURSE
-
4m 9sYou can use the integrated email function to very quickly send your Excel spreadsheet to other users via email. Your email is quickly created and you can adjust your email recipients and choose from different document formats, including XLS and PDF. FREE ACCESS
-
3m 44sWhen using Excel, you can share your workbooks via a link. You will not only see how to share a file via a link but how to choose the editing permissions as well. You will also see how to view your shared files in Excel. FREE ACCESS
-
3. Managing link access & permissions in Excel 2019 for Windows3m 21sWith Excel, you can change the editing permissions for a link to be more restrictive or open, depending on your preferences. You will see how to modify the editing permissions and manage access to the shared link. FREE ACCESS
-
4. Saving your documents to OneDrive in Excel 2019 for Windows3m 53sOneDrive is a service offered by Microsoft which is used to store files online. It can be used to access your documents from any location with an internet connection. This service can be accessed directly via Excel. FREE ACCESS
-
5. Managing a workbook's version history in Excel 2019 for Windows3m 1sWith Excel, you can manage a workbook's version history by opening a different version of the workbook and checking it out so no one else can edit it at the same time as you. FREE ACCESS
-
6. Commenting on a document in Excel 2019 for Windows3m 34sIf there are multiple individuals working on your spreadsheet, you may find the comment tool a useful way of collaborating and coordinating your additions and modifications. You can use the comment tool to leave notes or questions attached to particular data entries in your Excel spreadsheet. These comments can be visualized by every user with access to the shared document. FREE ACCESS
-
7. Following & tracking document changes in Excel 2019 for Windows4m 16sWhen there are lots of individuals working on the same shared document, it is vital that you can all keep track of the changes that have been made. In Excel, you can use the track changes tool to make sure that any changes that are made are highlighted in the document. These changes can then be viewed, accepted and rejected on an individual basis. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
