Creating & managing sheets in Google Sheets 2022

Google Sheets    |    Beginner
  • 11 videos | 44m 51s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 4.6 of 86 users Rating 4.6 of 86 users (86)
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. You will also learn 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

  • Discover the key concepts covered in creating & managing sheets in sheets 2022 course
    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

  • 55s
    This video outlines the key content covered in Creating & managing sheets in Sheets 2022 course including creating spreadsheets, using templates, and printing your spreadsheet. FREE ACCESS
  • 3m 21s
    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 homepages or from within a spreadsheet file. You will also be able to find your newly created spreadsheet, and learn how to rename a file. FREE ACCESS
  • Locked
    3.  Using templates
    4m 1s
    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. FREE ACCESS
  • Locked
    4.  Creating custom templates
    4m 56s
    If you use the same spreadsheet format regularly, it could be beneficial to create a template to use when creating new worksheets. You can create, use, and manage your custom spreadsheets in Google Sheets. FREE ACCESS
  • Locked
    5.  Importing a spreadsheet
    4m 38s
    Google Sheets import function allows you to transfer files from your hard-drive to your Google Sheets homepage, 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
    6.  Using online and offline spreadsheets
    4m 50s
    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. FREE ACCESS
  • Locked
    7.  Creating different versions of a spreadsheet
    3m 51s
    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
    8.  Recovering a previous version of a spreadsheet
    3m 46s
    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
    9.  Exporting spreadsheets to other file formats
    3m 27s
    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 devices. FREE ACCESS
  • Locked
    10.  Exporting your spreadsheet as a PDF file
    5m 1s
    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
    11.  Printing your spreadsheet
    6m 6s
    Once you have adjusted your document using the print preview mode, you can print it out using Google Sheets. You are able to use 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.5 of 27 users Rating 4.5 of 27 users (27)
Rating 3.9 of 21 users Rating 3.9 of 21 users (21)
Rating 4.9 of 11 users Rating 4.9 of 11 users (11)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.4 of 15 users Rating 4.4 of 15 users (15)
Rating 4.6 of 72 users Rating 4.6 of 72 users (72)
Rating 4.7 of 6 users Rating 4.7 of 6 users (6)