Formatting data in Google Sheets 2020

Google Sheets 2020    |    Intermediate
  • 9 videos | 37m 53s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 119 users Rating 4.6 of 119 users (119)
You can improve the appearance of your data by using the formatting tools in Google Sheets. Discover how to work with data types, apply color, align text, resize columns and rows, and use conditional formatting formulas.


  • Format your data
    Use different font types and effects
    Apply alignment, wrapping and rotation options
    Use font colors
    Use alternate colors
  • Apply themes
    Apply conditional formatting
    Apply advanced conditional formatting options
    Highlight data with conditional formatting options


  • 5m 38s
    The format settings for a cell, row, or column indicate what sort of data has been inserted. It is therefore easy to specify whether the contents are monetary values, dates, or percentages. Google Sheets can then automatically insert currency symbols, apply preferred date formats, and adjust the decimalization. FREE ACCESS
  • 4m 40s
    To ensure that your data can be clearly read and understood, you are going to need to know how to use the format settings. In this tutorial, you will find out how to apply different font styles, adjust the character size, and how to incorporate different text effects, such as bold, italics, and underline. FREE ACCESS
  • Locked
    3.  Aligning your data in Google Sheets 2020
    4m 37s
    In Google Sheets, you can adjust the alignment of data contained in a particular cell. As well as changing the positioning of your characters both along the horizontal and vertical axes, you can also use the wrap text function, which ensures that the text automatically appears on multiple lines within the cell. It is even possible to merge multiple cells in order to create one large cell. FREE ACCESS
  • Locked
    4.  Applying colors in Google Sheets 2020
    3m 23s
    The use of colors in Google Sheets can make your data easier to read and more attractive to consult. Colors can also be used to highlight certain cells or sections within your spreadsheet. As well as being able to change the color of your cell's contents, you can also change the background fill color of your chosen cell. FREE ACCESS
  • Locked
    5.  Using alternate colors in Google Sheets 2020
    3m 5s
    Enhance your data in a table by applying alternating colors. This feature of Google Sheets allows you to apply different fill colors to the rows of a data range or table. Alternating colors are useful to highlight headers, footers, and other data in your sheet. Learn how to apply default and custom styles, as well as remove alternating colors. FREE ACCESS
  • Locked
    6.  Using themes in Google Sheets 2020
    4m 55s
    Themes are useful for changing the appearance of your sheets. Discover how to apply theme colors to your cells and how to change the default theme of a spreadsheet in Google Sheets. You will also see how to customize a theme to enhance the display of your data and charts. FREE ACCESS
  • Locked
    7.  Using conditional formatting in Google Sheets 2020
    3m 48s
    Google Sheets features a conditional formatting tool that can be used to automatically format cells if they meet certain conditions. You can therefore choose to highlight certain entries if they are superior or inferior to a specified total. Once you have configured conditional formatting, you can export it for use in other documents. FREE ACCESS
  • Locked
    8.  Using advanced conditional formatting in Google Sheets 2020
    4m 10s
    There are a number of advanced conditional formatting options, including gradient sets, which allow you to show a range of results with different color shades. You can also use conditional formatting tools to highlight minimum, maximum, and average values. FREE ACCESS
  • Locked
    9.  Applying color to the first new entry in a list in Google Sheets 2020
    3m 37s
    The data that you have inserted into your Google Sheets spreadsheet can be organized in various ways. If you want to quickly see where a new group starts and the previous one finishes, you can create a conditional formatting rule that will automatically highlight the first value in a new group. FREE ACCESS


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.


Rating 4.5 of 51 users Rating 4.5 of 51 users (51)
Rating 3.9 of 21 users Rating 3.9 of 21 users (21)
Rating 3.2 of 6 users Rating 3.2 of 6 users (6)


Rating 4.5 of 107 users Rating 4.5 of 107 users (107)
Rating 4.4 of 161 users Rating 4.4 of 161 users (161)
Rating 4.6 of 378 users Rating 4.6 of 378 users (378)