Collaborating on a document in Google Sheets 2022

IN THIS COURSE

• 1.  Overview: Collaborating on a document in Sheets 2022
  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
• 2.  Publishing your document on the web
  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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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