Creating & Managing documents in Google Sheets 2020

Google Sheets 2020    |    Beginner
  • 10 videos | 37m 44s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 51 users Rating 4.5 of 51 users (51)
Explore the basics of creating, saving and managing spreadsheets in Google Sheets. Discover the multiple ways and places to save your spreadsheet, including on your computer and on Google Drive. Continue by learning how to save a workbook as an Excel, CSV or HTML file. See how to manage a document's version history, and recover unsaved documents. Finally, learn how to configure your spreadsheet settings before printing or saving it as a PDF file.

WHAT YOU WILL LEARN

  • Create new spreadsheets
    Create spreadsheets with templates
    Submit a custom template to create a spreadsheet
    Upload a spreadsheet from your device
    Work with online and offline documents
  • Create a backup version of a document
    Restore a previous version of your spreadsheet
    Export a spreadsheet to other file formats
    Export a spreadsheet as a pdf file
    Configure and print your spreadsheet

IN THIS COURSE

  • 2m 45s
    Before you can begin entering data, you are going to need to know how to create a new spreadsheet file. This can be done from the Google Sheets or Drive portal pages or from within a spreadsheet file. This tutorial will also show you how to find your newly created spreadsheet, and how to rename a file. FREE ACCESS
  • 3m 57s
    As well as being able to create your own spreadsheets, Google Sheets also comes with a library of different templates that can be downloaded and edited to create new documents. These templates come preformatted and often contain data examples to help you insert your own information. Here you will find out how to use and customize these templates. FREE ACCESS
  • Locked
    3.  Creating custom templates in Google Sheets 2020
    3m 46s
    If you use the same spreadsheet format regularly, it could be beneficial to create a template to use when creating new worksheets. See how to create, use, and manage your custom spreadsheets in Google Sheets. FREE ACCESS
  • Locked
    4.  Importing a spreadsheet in Google Sheets 2020
    3m 54s
    Google Sheets import function allows you to transfer files from your hard-drive to your Google Sheets portal, in order to work on them online and share them with your colleagues. Importing the spreadsheets also converts them to the Google format, enabling you to edit files that you have created in other programs using the Google Sheets application. FREE ACCESS
  • Locked
    5.  Using online and offline spreadsheets in Google Sheets 2020
    3m 48s
    Spreadsheets in Google Sheets are stored in Google Drive, and they can be edited online. The auto-save function allows saving all changes automatically. If you are not sure of these modifications, it is possible to undo the recent actions. Google Sheets also allows offline editing, but it is necessary to activate this functionality. In this video, learn how to work with online and offline spreadsheets. FREE ACCESS
  • Locked
    6.  Creating different versions of a spreadsheet in Google Sheets 2020
    3m 35s
    The auto-save function in Google Sheets prevents you from losing any changes to your document. However, it also means that if you make any inadvertent changes to your document, they will be saved as well. To avoid this, you can create a copy of the document which you can edit without affecting the original. FREE ACCESS
  • Locked
    7.  Recovering a previous version of a spreadsheet in Google Sheets 2020
    3m 22s
    Google Sheets comes complete with a save file recovery application, which allows you to browse through the different saved files copies of a particular spreadsheet. You can even trace the different color-coded changes made to a document in chronological order and subsequently restore your preferred document version. FREE ACCESS
  • Locked
    8.  Exporting spreadsheets to other file formats in Google Sheets 2020
    2m 56s
    As long as you have an internet connection, you can access your Google Sheets documents. However, if you are working offline and want to continue editing a document, you will have to download it to your computer. Downloading your file is also useful if you want to share it with others via a USB key or other removable media device. This tutorial will show you how to download your file, and how to choose between the different document formats on offer.  FREE ACCESS
  • Locked
    9.  Exporting your spreadsheet as a PDF file in Google Sheets 2020
    4m 19s
    The PDF format in Google Sheets allows you to view your spreadsheet as it will appear when printed. As well as being an accurate representation of your document in hard copy, it is also useful if you want to share your document, particularly if the systems being used are a mixture of PCs and Macs. A PDF file is also difficult to modify, bringing an additional layer of protection to your spreadsheet.  FREE ACCESS
  • Locked
    10.  Printing your spreadsheet in Google Sheets 2020
    5m 22s
    Once you have adjusted your document using the print preview mode, you can print it out using Google Sheets. This tutorial will introduce you to the print function and the various settings that can be modified to ensure that your document appears as you want it to. 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.4 of 8 users Rating 4.4 of 8 users (8)
Rating 4.6 of 50 users Rating 4.6 of 50 users (50)
Rating 4.6 of 25 users Rating 4.6 of 25 users (25)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.6 of 72 users Rating 4.6 of 72 users (72)
Rating 4.6 of 86 users Rating 4.6 of 86 users (86)