0:00 / 11:02
 
 
 
 
 

Intermediate Google Sheets

61 CQ
10 Lessons
  • Playing
    Free
    8 CQ
    1. Conditional Formatting in Google Sheets
    A lesson with Mr. Adam Carlson
    View lesson

    Conditional formatting can make it easier to read and interpret spreadsheets. Find out how to apply font and color formatting in Google Sheets in this lesson!

    Conditional formatting can make it easier to read and interpret spreadsheets. Find out how to apply font and color formatting in Google Sheets in this lesson!

  • Playing
    6 CQ
    2. Data Validation in Google Sheets
    A lesson with Mr. Adam Carlson
    View lesson

    Keep your data clean! In this Google Sheets lesson, learn how to use data validation to restrict the type of data input, preventing errors—aka invalid input.

    Keep your data clean! In this Google Sheets lesson, learn how to use data validation to restrict the type of data input, preventing errors—aka invalid input.

  • Playing
    4 CQ
    3. Boolean Statements in Google Sheets
    A lesson with Mr. Adam Carlson
    View lesson

    Become a more efficient user of Google Sheets by learning to use Boolean statements, which return true or false values based on the data in your spreadsheet.

    Become a more efficient user of Google Sheets by learning to use Boolean statements, which return true or false values based on the data in your spreadsheet.

  • Playing
    7 CQ
    4. If, And & Or Statements in Google Sheets
    A lesson with Mr. Adam Carlson
    View lesson

    Follow along to use If, Or, and And statements in Google Sheets to more efficiently evaluate and format data in Google Sheets, and learn practical applications.

    Follow along to use If, Or, and And statements in Google Sheets to more efficiently evaluate and format data in Google Sheets, and learn practical applications.

  • Playing
    5 CQ
    5. Conditional Calculation in Google Sheets
    A lesson with Mr. Adam Carlson
    View lesson

    Learn how to use Countif() and Sumif() in Google Sheets to count the number of cells and add numerical values in a given selection, respectively.

    Learn how to use Countif() and Sumif() in Google Sheets to count the number of cells and add numerical values in a given selection, respectively.

More...