Intermediate Google Sheets

61 CQ
10 Lessons
Previous...
  • 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...
  • Recommended Recommended
  • History & In Progress History
  • Browse Library
  • Most Popular Library

Get Personalized Recommendations

Let us help you figure out what to learn! By taking a short interview you’ll be able to specify your learning interests and goals, so we can recommend the perfect courses and lessons to try next.

Start Interview

You don't have any lessons in your history.
Just find something that looks interesting and start learning!

Comments
500 characters max