Creating & Managing documents in Google Sheets 2020

Google Sheets 2020    |    Beginner
  • 10 videos | 37m 44s
  • Includes Assessment
  • Earns a Badge
Likes 91 Likes 91
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

  • Playable
    1.  Creating spreadsheets in Google Sheets 2020
    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… FREE ACCESS
  • Playable
    2.  Using templates in Google Sheets 2020
    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… 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… 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… 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,… 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… 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.… 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… 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… 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.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 50 Likes 50  
Likes 3624 Likes 3624  
Likes 112 Likes 112