Collaborating on a document in Google Sheets 2022

Google Sheets    |    Intermediate
  • 10 videos | 43m 37s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 4.7 of 58 users Rating 4.7 of 58 users (58)
Easily share spreadsheets with your colleagues using Google Sheets collaboration features. Discover how to share documents with others via email and select the most suitable format for sharing your spreadsheet. If you prefer to release your documents to a wider audience you can publish your spreadsheet via a link or by embedding code in a blog. To work with other users in real-time, discover how to set up sharing options for individuals or to create a link available for anyone in your organization. You will also learn how to communicate and interact with other editors, for example, by adding comments or assigning tasks.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in the collaborating on a document in sheets 2022 course
    Publish a spreadsheet via a link and an embedded code
    Share a spreadsheet as an attachment via email
    Protect data ranges and sheets
    Share a spreadsheet and create shareable links
  • Manage sharing options of a spreadsheet
    Collaborate and communicate with other users
    Add comments and mention people
    Assign and manage tasks
    Manage comments and configure notifications

IN THIS COURSE

  • 51s
    This video outlines the key content covered in Collaborating on a document in Sheets 2022 course including publishing your document on the web, sharing a spreadsheet, and assigning tasks. FREE ACCESS
  • 5m 48s
    Google Sheets allows you to publish a spreadsheet or worksheet using links or an embedded code. You are able to create a link for sharing your data and select the format. You will also learn how to create an embedded code to share your entire spreadsheet. Lastly, you can manage the settings for published content. FREE ACCESS
  • Locked
    3.  Sending your document via email
    3m 15s
    You can use the integrated email function to very quickly send your Google Sheets document to other users via email. Your email is quickly created and you can adjust your email recipients and choose from different document formats, including XLSX and PDF. FREE ACCESS
  • Locked
    4.  Protecting your document
    5m 45s
    There are a number of levels of security that you can apply to your spreadsheet documents in Google Sheets. As well as being able to share your documents with collaborators (in both editable and read-only formats), you can also adjust the settings for a particular sheet within that document, so that you can maintain complete control over who has access and editing rights. FREE ACCESS
  • Locked
    5.  Sharing a spreadsheet
    5m 25s
    In order to allow others to contribute to your spreadsheet, you can share your spreadsheets created with Google Sheets. You are able to find out if your document is shared, adjust the security level, as well as authorize individual collaborators. You can also create links to access a document that can be shared by email or instant messages. FREE ACCESS
  • Locked
    6.  Adjusting sharing options
    4m 28s
    Sharing documents is extremely useful for collaborating with other people in your company. Google Sheets allows you to manage an individual's access as well as revoke an individual's authorization. You can also change the configuration of shareable links created in Google Sheets. FREE ACCESS
  • Locked
    7.  Working with other users on the same document
    5m 14s
    Google Sheets facilitates multi-user collaboration with a variety of tools. You can send an email to other collaborators to tell them you are editing the spreadsheet. In Sheets, you can easily identify other people editing the document and communicate with them in real-time. You can also use the activity dashboard to get more details about your shared document. FREE ACCESS
  • Locked
    8.  Inserting comments in your document
    4m 2s
    If there are a number of individuals working on the same spreadsheet, you may find it useful to discuss the issues arising by inserting messages. Comments can be added quickly and simply, and discussions appear in an internet forum format, allowing multiple users to post comments, and reply to the different discussion threads. Google Sheets also allows mentioning other people within your organization, even if they don't have access to the document. FREE ACCESS
  • Locked
    9.  Assigning tasks
    3m 59s
    In Google Sheets, you can assign tasks, or "action items," to your coworkers or team members by using the Comments option. You can also view tasks that other people have assigned to you and can reply to the comment and mark the task as done when it's completed. FREE ACCESS
  • Locked
    10.  Managing comments
    4m 50s
    The comments' pane can contain multiple issues and questions. You can access the full list of comments, mark comments threads as resolved, and even reopen discussions, directly from Google Sheets. If you want to keep on top of any discussion taking place within your document, you will find the notification settings extremely useful. 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 8 users Rating 4.5 of 8 users (8)
Rating 4.5 of 35 users Rating 4.5 of 35 users (35)
Rating 4.5 of 27 users Rating 4.5 of 27 users (27)