Formatting data in Google Sheets 2022

Google Sheets 2022    |    Intermediate
  • 10 videos | 40m 3s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Google Sheets 2022 offers different formatting tools to improve the appearance of your data. First, learn how to change your cell's format and learn how to format and align data. Next, learn how to apply colors as well as use alternate colors and themes. In this course, you will also discover how to use basic and advanced conditional formatting as well as apply color to the first new entry in a list.

WHAT YOU WILL LEARN

  • discover the key concepts covered in the Formatting data in Sheets 2022 course
    format your data
    use different font types and effects
    apply alignment, wrapping and rotation options
    use font colors
  • use alternating colors
    apply themes
    apply conditional formatting
    apply advanced conditional formatting options
    highlight data with conditional formatting options

IN THIS COURSE

  • Playable
    1.  Overview: Formatting data in Sheets 2022
    50s
    This video outlines the key content covered in Formatting data in Sheets 2022 course including formatting data, applying colors, and using conditional formatting. FREE ACCESS
  • Playable
    2.  Changing your cell's data format
    4m 52s
    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… FREE ACCESS
  • Locked
    3.  Formatting data
    3m 54s
    To ensure that your data can be clearly read and understood, you are going to need to know how to use the format settings. You are able to apply different font styles, adjust the character size, and incorporate different… FREE ACCESS
  • Locked
    4.  Aligning your data
    5m
    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… FREE ACCESS
  • Locked
    5.  Applying colors
    3m 46s
    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… FREE ACCESS
  • Locked
    6.  Using alternating colors
    4m 23s
    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… FREE ACCESS
  • Locked
    7.  Using themes
    5m 4s
    Themes are useful for changing the appearance of your sheets. You are able to apply theme colors to your cells and change the default theme of a spreadsheet in Google Sheets. In addition, you can customize a theme to… FREE ACCESS
  • Locked
    8.  Using conditional formatting
    4m 21s
    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… FREE ACCESS
  • Locked
    9.  Using advanced conditional formatting
    4m 6s
    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… FREE ACCESS
  • Locked
    10.  Applying color to the first new entry in a list
    3m 47s
    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… 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.