Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Excel Conditional Formatting - From Beginners to Advanced

Simon Sez IT via YouTube

Overview

Coursera Plus Annual Sale: All Certificates & Courses 25% Off!
Learn to enhance spreadsheet visualization through a comprehensive 15-minute tutorial on Excel's conditional formatting features. Master techniques from basic cell highlighting to advanced rule creation, with hands-on practice using downloadable exercise files. Progress through six key sections covering highlight cells, icons, blanks, checkboxes, rule selection, and custom rule creation. Develop skills to automatically format cells based on their values, identify trends, spotlight exceptions, and improve data readability. Follow along with timestamped sections to focus on specific formatting techniques or work through the entire tutorial to build a complete understanding of Excel's dynamic formatting capabilities.

Syllabus

00:00:00 - Highlight Cells
00:03:22 - Icons
00:06:47 - Blanks
00:07:55 - Checkboxes
00:10:29 - Select Rule
00:12:05 - Create Rule

Taught by

Simon Sez IT

Reviews

Start your review of Excel Conditional Formatting - From Beginners to Advanced

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.