Enhancing your documents in Google Sheets 2020
Google Sheets 2020
| Intermediate
- 10 videos | 37m 16s
- Includes Assessment
- Earns a Badge
Improve the display of your data using the insertion tools in Google Sheets. Discover how to add more columns, rows, and cells to insert more data in a worksheet. You will also learn how to manage and customize rows and columns by changing their size and applying borders. Spreadsheets in Google Sheets do not have to contain only data. Explore various methods for inserting images, including how to create, insert, and edit drawings, as well as hyperlinks. All these tools can be useful for creating first-rate headers for your documents.
WHAT YOU WILL LEARN
-
Insert and delete columns, rows and cells
Resize columns and rows
Hide and unhide column and rows
Freeze and unfreeze columns and rows
Insert, replace and manage images -
Insert and customize a word art title
Edit and save a copy of your drawing
Insert, edit and remove a hyperlink
Insert, customize and remove borders
Add, edit and customize headers
IN THIS COURSE
-
4m 12sOnce you have created your spreadsheet, you may find that you need to insert an additional column or row. Rather than deleting all your data and starting again, you can quickly and easily insert new cells into your spreadsheet. Google Sheets features a number of different tools you can use to create new columns and rows in your file. FREE ACCESS
-
4m 24sEnsuring that your spreadsheet and the data it contains are readable is extremely important. In this tutorial, you will find out how to resize your columns and rows, how to automatically set a column width to the maximum length of the data it contains, and manually specify the pixel height and width for a particular column or row in Google Sheets. FREE ACCESS
-
3. Hiding columns & rows in Google Sheets 20202m 38sTemporarily hiding columns or rows can sometimes prove extremely useful, particularly if you are working on data found at opposite ends of a large spreadsheet document. You will find out how to hide and redisplay both columns and rows in Google Sheets. FREE ACCESS
-
4. Freezing & unfreezing columns & rows in Google Sheets 20203m 2sIn order to compare particular sets of data in your spreadsheet, you can freeze rows and columns in Google Sheets. This tutorial will show you how to browse your document while at the same time keeping certain information displayed at all times. FREE ACCESS
-
5. Inserting an image in Google Sheets 20203m 42sGoogle Sheets allows you to insert images into your document. These images can be uploaded from your computer, found using the integrated Google image search engine or even accessed using the image's URL. This tutorial will show you how to insert images using the aforementioned methods. FREE ACCESS
-
6. Inserting a drawing in Google Sheets 20203m 39sThe Google Sheets drawing tool allows you to create your own diagrams and Word art text. In this tutorial, you will find out how to open the tool, create your title, and insert it into your spreadsheet. FREE ACCESS
-
7. Editing your drawing in Google Sheets 20204m 27sEven if you have finished creating and inserting your diagram, you can still make changes to it through the Google Sheets' edit tool. This tutorial will show you how to modify your diagram, how to save your changes and also how to resize your shape. FREE ACCESS
-
8. Inserting a hyperlink in Google Sheets 20205m 10sA hyperlink is a text zone that directs the user to internet-based content. Clicking on the link will open a new browser window or tab in which the content will be loaded. Find out how to insert one or more hyperlinks into your spreadsheet in Google Sheets. FREE ACCESS
-
9. Inserting borders in Google Sheets 20202m 42sThe presentation of your spreadsheet can also be improved through the use of borders. Google Sheets allows you to trace the outline of cells, rows, or even a selection of your choice. This tutorial will show you everything you need to know to begin using the border function in Google Sheets. FREE ACCESS
-
10. Adding headers in Google Sheets 20203m 20sHeaders are very important for including essential technical and author information relating to your Google Sheets document. They also allow you to automatically insert information into every page in your document. In this tutorial, you will also find out how to ensure that your column headers appear on every page of your spreadsheet. 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.
