Enhancing documents in Google Sheets 2022

Google Sheets    |    Intermediate
  • 12 videos | 46m 20s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 4.8 of 19 users Rating 4.8 of 19 users (19)
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

  • 50s
    This 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 5s
    Once 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
  • Locked
    3.  Resizing your columns & rows
    4m 34s
    Ensuring 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
  • Locked
    4.  Hiding columns & rows
    2m 59s
    Google 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
  • Locked
    5.  Freezing & unfreezing columns & rows
    3m 50s
    In 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
  • Locked
    6.  Inserting an image
    4m 26s
    Google 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
  • Locked
    7.  Inserting a drawing
    3m 53s
    The 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
  • Locked
    8.  Editing your drawing
    3m 59s
    Even 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
  • Locked
    9.  Inserting a hyperlink
    4m 23s
    A 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
  • Locked
    10.  Inserting people chips
    4m 17s
    A 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
  • Locked
    11.  Inserting borders
    3m 34s
    The 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
  • Locked
    12.  Adding headers
    4m 29s
    Headers 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.

YOU MIGHT ALSO LIKE

Course Creating & Managing documents in Google Sheets 2020
Rating 4.5 of 51 users Rating 4.5 of 51 users (51)
Course Using basic formulas in Sheets 2022
Rating 4.4 of 37 users Rating 4.4 of 37 users (37)
Course Formatting data in Google Sheets 2022
Rating 4.6 of 25 users Rating 4.6 of 25 users (25)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Formatting data in Google Sheets 2020
Rating 4.6 of 119 users Rating 4.6 of 119 users (119)
Course Getting started in Google Sheets 2022
Rating 4.4 of 161 users Rating 4.4 of 161 users (161)
Course Creating & managing sheets in Google Sheets 2022
Rating 4.6 of 86 users Rating 4.6 of 86 users (86)