Working with others on a document in Google Sheets 2020

Google Sheets 2020    |    Intermediate
  • 9 videos | 42m 55s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 10 users Rating 4.5 of 10 users (10)
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

  • Publish a spreadsheet via a link and 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

  • 5m 26s
    Google Sheets allows you to publish spreadsheet or worksheet via links or embedded code. Learn how to create a link for sharing your data and how to select the format: Web, PDF, Excel, for example. You will also learn how to create embedded code to share your entire spreadsheet. Lastly, discover how to manage the settings for published content. FREE ACCESS
  • 2m 39s
    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
    3.  Protecting your document in Google Sheets 2020
    5m 7s
    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
    4.  Sharing & presenting in Google Sheets 2020
    5m 53s
    In order to allow others to contribute to your spreadsheet, learn how to share your spreadsheets created with Google Sheets. This tutorial will show you how to find out if your document is shared, how to adjust the security level, and how to authorize individual collaborators. You will also see how to create links to access a document that can be shared by email or instant messages. FREE ACCESS
  • Locked
    5.  Adjusting sharing options in Google Sheets 2020
    4m 53s
    Sharing documents is extremely useful for collaborating with other people in your company. This tutorial will show you how to manage an individual's access and how to revoke an individual's authorization. You will also learn how to change the configuration of shareable links created in Google Sheets. FREE ACCESS
  • Locked
    6.  Working with other users on the same document in Google Sheets 2020
    4m 57s
    Google Sheets facilitates multi-user collaboration with a variety of tools. You will learn how to send an email to other collaborators to tell them you are editing the spreadsheet. See how to identify other people editing the document and how to communicate with them in real-time. Finally, discover the activity dashboard to get more details about your shared document. FREE ACCESS
  • Locked
    7.  Inserting comments in Google Sheets 2020
    5m 34s
    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
    8.  Assigning tasks in Google Sheets 2020
    4m 26s
    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
    9.  Managing comments in Google Sheets 2020
    4m 1s
    The comments pane can contain multiple issues and questions. In this tutorial, you will find out how to 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

Course Inserting & managing data in Google Sheets 2022
Rating 4.6 of 72 users Rating 4.6 of 72 users (72)
Course Sharing & collaborating in Google Drive 2023
Rating 4.3 of 7 users Rating 4.3 of 7 users (7)
Course Using basic formulas in Sheets 2022
Rating 4.4 of 37 users Rating 4.4 of 37 users (37)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course CompTIA Linux+: Shells, Variables, & Configuration Files
Rating 4.2 of 19 users Rating 4.2 of 19 users (19)
Course Marketing: The Process and Functions that Build Customer Relationships
Rating 4.5 of 438 users Rating 4.5 of 438 users (438)
Course Creating & managing sheets in Google Sheets 2022
Rating 4.6 of 86 users Rating 4.6 of 86 users (86)