Enhancing your documents in Google Sheets 2020

Google Sheets 2020    |    Intermediate
  • 10 videos | 37m 16s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 13 users Rating 4.5 of 13 users (13)
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 12s
    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
  • 4m 24s
    Ensuring 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
  • Locked
    3.  Hiding columns & rows in Google Sheets 2020
    2m 38s
    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. You will find out how to hide and redisplay both columns and rows in Google Sheets. FREE ACCESS
  • Locked
    4.  Freezing & unfreezing columns & rows in Google Sheets 2020
    3m 2s
    In 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
  • Locked
    5.  Inserting an image in Google Sheets 2020
    3m 42s
    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 even accessed using the image's URL. This tutorial will show you how to insert images using the aforementioned methods. FREE ACCESS
  • Locked
    6.  Inserting a drawing in Google Sheets 2020
    3m 39s
    The 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
  • Locked
    7.  Editing your drawing in Google Sheets 2020
    4m 27s
    Even 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
  • Locked
    8.  Inserting a hyperlink in Google Sheets 2020
    5m 10s
    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 in which the content will be loaded. Find out how to insert one or more hyperlinks into your spreadsheet in Google Sheets. FREE ACCESS
  • Locked
    9.  Inserting borders in Google Sheets 2020
    2m 42s
    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. This tutorial will show you everything you need to know to begin using the border function in Google Sheets. FREE ACCESS
  • Locked
    10.  Adding headers in Google Sheets 2020
    3m 20s
    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. 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.

YOU MIGHT ALSO LIKE

Rating 4.5 of 27 users Rating 4.5 of 27 users (27)
Rating 4.5 of 8 users Rating 4.5 of 8 users (8)
Rating 4.6 of 25 users Rating 4.6 of 25 users (25)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.4 of 15 users Rating 4.4 of 15 users (15)
Rating 4.3 of 39 users Rating 4.3 of 39 users (39)
Rating 4.7 of 6 users Rating 4.7 of 6 users (6)