Excel Conditional Formatting Basics - The built in Features
4.3 (72 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
11,785 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel Conditional Formatting Basics - The built in Features to your Wishlist.

Add to Wishlist

Excel Conditional Formatting Basics - The built in Features

Learn how to make Excel format cells at your terms !
4.3 (72 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
11,785 students enrolled
Created by Abdelrahman Abdou
Last updated 8/2016
English
Price: $50
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • 1 Article
  • 6 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Understand what conditional formatting in Excel is and how it works
  • Use conditional formatting built in features in Excel
  • Use the Highlight Cell Rules to highlight cells by comparing the cells' value to another value
  • Use Conditional Formatting to Highlight dates based on their occurrence Yesterday, Today, Last Week, Last Month
  • Use Conditional formatting to Highlight Duplicates in a range of Cells
  • Highlight the top % or bottom % in a range of values
  • Highlight values above and below average in a range of values
  • Use Data Bars for conditional formatting and understand its different options
  • Use Icon sets (Traffic lights) for conditional formatting and understand its different options (Number, Formula, Percent, and Percentile)
View Curriculum
Requirements
  • The will to learn !
  • Students will need to have Excel 2007/2010/2013/2016 installed on their computer
  • Students will need to be familiar with the Excel user interface and need to have written a few formulas
Description

Conditional formatting is one of the best ways to visualize your data by coloring the cells that meet a certain criteria or add different shapes to those cells and allows you to see the different colors of the rainbow in your data.

In this course, you will learn the basics of conditional formatting in Excel and how to use the built in features.

The course is designed to get you up and running with conditional formatting in 1 hour.

If you want to learn the basics of conditional formatting, then this course is for you.

Course doesn't include conditional formatting using formulas as this is an advanced topic in conditional formatting.

So Let's see what you'll learn from this course:

  • Introduction to conditional formatting, what it is and what it does.
  • Highlight Cell rules : Highlighting cells based on the comparison of their value to another value, highlighting dates, and highlighting duplicates in a data set.
  • Top/Bottom Rules: Conditionally formatting the top or bottom % of the data and values above or below average.
  • Using Data Bars in conditional formatting.
  • Using Icon sets (Creating Traffic Lights conditional formatting).
  • Using Color scales for conditional formatting.
Who is the target audience?
  • Excel users who want to understand conditional formatting in Excel and use Excel's built in features for conditional formatting
  • If you're an intermediate user in conditional formatting then you might learn some new things on this course
  • If you're an experienced user in conditional formatting then this course is NOT for you
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 14 Lectures Collapse All 14 Lectures 01:08:44
+
Introduction
3 Lectures 12:02

A lecture discussing the course objectives.

Preview 04:41

An Introduction to the concept of Conditional formatting

Preview 03:15

A lecture Explaining the difference between applying conditional formatting using Excel's built in features Versus Using formulas for conditional formatting

Preview 04:06
+
Conditional formatting using Excel's built in features
11 Lectures 56:50

First Lecture on Highlight Cell rules option in conditional formatting

Highlight Cell Rules ( Part 1)
03:32

Second Lecture on Highlight Cell rules option in conditional formatting

Highlight Cell Rules (Part 2)
02:55

A lecture Explaining the Top/Bottom Rules option in conditional formatting.

Example file is attached to this lecture

Top/Bottom Rules
04:26

A lecture Explaining how to use Data Bars for Conditional Formatting

Example file is attached to this lecture

Using Data Bars for Conditional Formatting
09:30

An Introduction lecture for conditional formatting using Icon sets.

Example file is attached to this lecture.


Icon Sets - Introduction
04:03

A lecture explaining using the Number option in Icon sets conditional formatting.

Example file is attached to the Introduction lecture for Icon sets.

Icon Sets - Number Option
05:42

A lecture explaining using the Formula option in Icon sets conditional formatting.

Example file is attached to the Introduction lecture for Icon sets.

Icon Sets - Formula Option
06:15

A lecture explaining using the Percent option in Icon sets conditional formatting.

Example file is attached to the Introduction lecture for Icon sets.

Icon Sets - Percent Option
05:58

A lecture explaining using the Percentile option in Icon sets conditional formatting.

Example file is attached to the Introduction lecture for Icon sets.

Icon Sets - Percentile Option
07:28

In This Lecture, Students will learn how to color scales for conditional formatting.

Example files are attached to this lecture.

Color Scales
06:23

Bonus Lecture-Learn how to create Interactive Dashboards Using Microsoft Excel !
00:38
About the Instructor
Abdelrahman Abdou
4.2 Average rating
233 Reviews
13,756 Students
3 Courses
Teaching 13000+ Students across 146 Countries !

Hi, I'm Abdelrahman and I'm an Excel Lover :)

I have a Bachelor's Degree in Chemical Engineering.

I Worked as MIS and Reporting Analyst in Vodafone International Services In Egypt for 3 years.

I have more than 5 Years of Experience in Excel including building Dashboards and VBA.

I have created numerous dashboards in my company and automated tens of reports.

I love learning new things and my main learning method is through self-learning by watching video tutorials.

I love Excel and I'm trying to share the love with everyone else !