Creating & Managing documents in Google Sheets 2020
Google Sheets 2020
| Beginner
- 10 videos | 37m 44s
- Includes Assessment
- Earns a Badge
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 45sBefore 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 57sAs 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
-
3. Creating custom templates in Google Sheets 20203m 46sIf 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
-
4. Importing a spreadsheet in Google Sheets 20203m 54sGoogle 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
-
5. Using online and offline spreadsheets in Google Sheets 20203m 48sSpreadsheets 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
-
6. Creating different versions of a spreadsheet in Google Sheets 20203m 35sThe 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
-
7. Recovering a previous version of a spreadsheet in Google Sheets 20203m 22sGoogle 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
-
8. Exporting spreadsheets to other file formats in Google Sheets 20202m 56sAs 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
-
9. Exporting your spreadsheet as a PDF file in Google Sheets 20204m 19sThe 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
-
10. Printing your spreadsheet in Google Sheets 20205m 22sOnce 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.
