Creating & managing sheets in Google Sheets 2022

IN THIS COURSE

• 1.  Overview: Creating & managing sheets in Sheets 2022
  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
• 2.  Creating spreadsheets
  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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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