Course Overview
Teacher
I've been a science teacher for 7 years now, teaching in both Illinois (my home state) and Minnesota (my adopted home). When not running after my two small children, I enjoy listening to audiobooks and podcasts while cleaning up after my two small... View ProfileDetails
- Total Time 1 hr, 52 min
- Lessons 10
- Attachments 25
- Exercises 35
-
61 CQ
10 Lessons in This Course
-
15 minFREEAnalytics lesson 1Free8 CQ
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!
with Mr. Adam CarlsonConditional 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!
-
11 minAnalytics lesson 26 CQ
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.
with Mr. Adam CarlsonKeep 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.
-
6 minCareer Growth lesson 34 CQ
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.
with Mr. Adam CarlsonBecome 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.
-
12 minlesson 47 CQ
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.
with Mr. Adam CarlsonFollow 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.
-
8 minlesson 55 CQ
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.
with Mr. Adam CarlsonLearn how to use Countif() and Sumif() in Google Sheets to count the number of cells and add numerical values in a given selection, respectively.
-
9 minlesson 65 CQ
Follow along to learn how to use the Count(), CountA(), CountBlank(), and CountUnique() formulas to count the number of cells in a range in Google Sheets.
with Mr. Adam CarlsonFollow along to learn how to use the Count(), CountA(), CountBlank(), and CountUnique() formulas to count the number of cells in a range in Google Sheets.
-
10 minCareer Growth lesson 76 CQ
This Google Sheets lesson demonstrates how to use the Split and Concatenate functions to separate or combine strings of data between columns in a spreadsheet.
with Mr. Adam CarlsonThis Google Sheets lesson demonstrates how to use the Split and Concatenate functions to separate or combine strings of data between columns in a spreadsheet.
-
12 minCareer Growth lesson 87 CQ
Go beyond the basics of Google Sheets by learning how to use dynamic sorting and filtering functions : Sort(), Filter(), Transpose(), and Unique()
with Mr. Adam CarlsonGo beyond the basics of Google Sheets by learning how to use dynamic sorting and filtering functions : Sort(), Filter(), Transpose(), and Unique()
-
11 minlesson 96 CQ
Join this Google Sheets lesson to learn how to use Vlookup, Hlookup, and Index/Match functions to search for specific data in spreadsheets.
with Mr. Adam CarlsonJoin this Google Sheets lesson to learn how to use Vlookup, Hlookup, and Index/Match functions to search for specific data in spreadsheets.
-
13 minAnalytics lesson 107 CQ
Creating graphs can be a time-consuming process, but not with Google Sheets Explore feature! Follow along to to create and customize graphs in this lesson.
with Mr. Adam CarlsonCreating graphs can be a time-consuming process, but not with Google Sheets Explore feature! Follow along to to create and customize graphs in this lesson.
-
621 min6-part Teaching Skills course14 CQ
This course from educator Mr. Adam Carlson covers how to make an interactive worksheet using Google Sheets and a few formulas that will help you and your students track their work quickly and easily.
with Mr. Adam CarlsonThis course from educator Mr. Adam Carlson covers how to make an interactive worksheet using Google Sheets and a few formulas that will help you and your students track their work quickly and easily.
-
1154 min11-part Teaching Skills course35 CQ
Google Forms is a simple yet powerful program with many applications. This course explains how to create, edit, submit, and grade Google Forms, complete with customized layouts, fonts, and templates!
with Mr. Adam CarlsonGoogle Forms is a simple yet powerful program with many applications. This course explains how to create, edit, submit, and grade Google Forms, complete with customized layouts, fonts, and templates!
-
13133 min13-part Productivity course72 CQ
Google Sheets is a free, powerful, cloud-based alternative to Microsoft Excel that integrates with Google Drive. Discover how to make the most of it with this beginner’s course from Mr. Adam Carlson.
with Mr. Adam CarlsonGoogle Sheets is a free, powerful, cloud-based alternative to Microsoft Excel that integrates with Google Drive. Discover how to make the most of it with this beginner’s course from Mr. Adam Carlson.
-
12 minBiology lesson7 CQ
Learn about artificial selection: how humans use the variation that nature provides in order to shape life, typically for creating domesticated food supplies.
with Mr. Adam CarlsonLearn about artificial selection: how humans use the variation that nature provides in order to shape life, typically for creating domesticated food supplies.
-
865 min8-part Productivity course37 CQ
Your time is precious! In this course, business analyst and trainer Bruce Wade provides expert tips to maximize your earning potential and work-life balance by effectively managing your time.
with Bruce WadeYour time is precious! In this course, business analyst and trainer Bruce Wade provides expert tips to maximize your earning potential and work-life balance by effectively managing your time.
-
737 min7-part Personal Growth course22 CQ
In this course for professionals, discuss the habits of the world's most successful people, and learn how to cultivate these healthy habits yourself by applying productivity strategies to your life.
with Vladimir RaykovIn this course for professionals, discuss the habits of the world's most successful people, and learn how to cultivate these healthy habits yourself by applying productivity strategies to your life.
-
527 min5-part Personal Growth course16 CQ
Productivity is about producing positive results in your life! Although strategies are needed for this kind of personal development, it's really about getting the right things done in a timely way.
with Vladimir RaykovProductivity is about producing positive results in your life! Although strategies are needed for this kind of personal development, it's really about getting the right things done in a timely way.
-
16218 min16-part Management course118 CQ
Does your device come with Microsoft Office 365? In this comprehensive course, get familiar with all the helpful apps this productivity program offers, from Mail to Skype for Business.
Does your device come with Microsoft Office 365? In this comprehensive course, get familiar with all the helpful apps this productivity program offers, from Mail to Skype for Business.
-
2281 min22-part Personal Growth course52 CQ
Need a bit of inspiration to help you lead a more productive life? Entrepreneurs and business owners alike benefit from this productivity course full of tips to improve time management and planning.
with Matt BernsteinNeed a bit of inspiration to help you lead a more productive life? Entrepreneurs and business owners alike benefit from this productivity course full of tips to improve time management and planning.