Enhancing documents in Google Sheets 2022
Google Sheets
| Intermediate
- 12 videos | 46m 20s
- Includes Assessment
- Earns a Badge
- CPE
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
-
Discover the key concepts covered in the enhancing documents in sheets 2022 course
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 and use people chips
Insert, customize and remove borders
Add, edit and customize headers
IN THIS COURSE
-
50sThis video outlines the key content covered in Enhancing documents in Sheets 2022 course including inserting rows & columns, editing your drawing, and adding headers. FREE ACCESS
-
5m 5sOnce 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
-
3. Resizing your columns & rows4m 34sEnsuring that your spreadsheet and the data it contains are readable is extremely important. You are able to resize your columns and rows, 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
-
4. Hiding columns & rows2m 59sGoogle Sheets allows you to hide and redisplay both columns and rows. Temporarily 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. FREE ACCESS
-
5. Freezing & unfreezing columns & rows3m 50sIn order to compare particular sets of data in your spreadsheet, you can freeze rows and columns in Google Sheets. You can browse your document while simultaneously keeping certain information displayed at all times. FREE ACCESS
-
6. Inserting an image4m 26sGoogle 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 accessed using the image's URL. FREE ACCESS
-
7. Inserting a drawing3m 53sThe Google Sheets drawing tool allows you to create your own diagrams and WordArt text. You can insert a drawing, create and customize WordArt titles, and use the WordArt title in a sheet. FREE ACCESS
-
8. Editing your drawing3m 59sEven if you have finished creating and inserting your diagram, you can still make changes to it through the Google Sheets' edit tool. You are able to modify your diagram, save your changes and resize your shape. FREE ACCESS
-
9. Inserting a hyperlink4m 23sA 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 where the content will be loaded. In Google Sheets, you can insert URLs, email addresses, and links into a cell. FREE ACCESS
-
10. Inserting people chips4m 17sA people chip connects cells in a spreadsheet to your contacts. In Sheets, you can add individuals or groups to your spreadsheet and then reveal details, such as their email, to easily contact them. FREE ACCESS
-
11. Inserting borders3m 34sThe 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. FREE ACCESS
-
12. Adding headers4m 29sHeaders 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. You are also able 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.
