Sharing & Collaborating on a Document in Excel 2019 for Windows

Excel 2019 (Windows)    |    Beginner
  • 7 videos | 25m 57s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 4.5 of 234 users Rating 4.5 of 234 users (234)
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 9s
    You 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 44s
    When 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
  • Locked
    3.  Managing link access & permissions in Excel 2019 for Windows
    3m 21s
    With 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
  • Locked
    4.  Saving your documents to OneDrive in Excel 2019 for Windows
    3m 53s
    OneDrive 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
  • Locked
    5.  Managing a workbook's version history in Excel 2019 for Windows
    3m 1s
    With 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
  • Locked
    6.  Commenting on a document in Excel 2019 for Windows
    3m 34s
    If 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
  • Locked
    7.  Following & tracking document changes in Excel 2019 for Windows
    4m 16s
    When 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.

YOU MIGHT ALSO LIKE

Rating 4.5 of 132 users Rating 4.5 of 132 users (132)
Rating 3.0 of 2 users Rating 3.0 of 2 users (2)
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.5 of 482 users Rating 4.5 of 482 users (482)
Rating 4.5 of 487 users Rating 4.5 of 487 users (487)
Rating 4.5 of 1588 users Rating 4.5 of 1588 users (1588)