Free Course

Master Conditional Formatting in Google Sheets

Transform your Google Sheets with color-coding and custom rules to highlight trends, track performance, and make data more engaging and accessible for students, parents, and colleagues.
Write your awesome label here.
Empty space, drag to resize
skill level

  • Intermediate

Format

  • Online, self-paced

PD HOURS AWARDED

  • 0.5

Number of quizzes

  • 1

Empty space, drag to resize

About this course

Take your spreadsheets to the next level and unlock the power of data visualization with this online course on conditional formatting in Google Sheets. Through conditional formatting, you'll learn how to highlight trends, categorize information, and draw attention to key figures, all with just a few clicks. Imagine being able to instantly spotlight important student data, track performance trends, or create dynamic visuals that make reports and presentations more compelling.

Join us to discover how conditional formatting can transform your data and give you a new level of control over the insights in your spreadsheets. 

Your new superpowers

  • Easily understand and interpret data at a glance
  • Explore the default conditional formatting rules in Sheets
  • Create conditions based on text, date, & numerical value
  • Color code data with either single colors or color scales
Empty space, drag to resize

Course Lessons

Created by

Emily Pool

Emily Pool (she/her) is an LTC Instructional Technology Coach serving the Adams and Pike county regions. In this role, Emily strives to help teachers get excited about, engaged with, and enriched by educational technology – especially when it comes to bridging the gap between potential and implementation.