Excel Conditional Formatting Basics - The built in Features (Udemy.com)

Learn how to make Excel format cells at your terms !

( 44 Reviews )

Created by: Abdelrahman Abdou

Produced in 2018

What you will 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)

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 90 / 100

Course 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 this course is for:

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

Time: 1h

Instructor Details

Abdelrahman Abdou

4.5 Rating
44 Reviews

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.5 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 !

Excel Basics (2017)

4.9 (15 Reviews)

Provider: YouTube
Time: 12h

Free

Microsoft Excel - Online Tutorial for Beginners (2010)

0.0 (0 Reviews)

Provider: Chandoo.org
Time: 1h 30m

Free

Excel Power Pivot and Power Query For Dummies

Excel Power Pivot and Power Query For Dummies (2016)

0.0 (0 Reviews)

Provider: Amazon

$14.53

More Courses

More courses by Abdelrahman Abdou

Excel Dashboards : Build a Dashboard from Scratch!

Excel Dashboards : Build a Dashboard from Scratch! (2018)
4.7 (98 Reviews)

- Provider: Udemy
- Time: 8.5h

$11.99

All courses by Abdelrahman Abdou

Reviews

4.5

44 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Heinzollerketchup Puketch

not that what i have expected

By Aimad Akian En Nahas

no entiendo el ingles

By Vanessa Flanagan

nice and clear

By Waqar Ahmad

Learning oppertunity

By Lucas Facheti

Curso muito bom!

By Csontos Belle

Very informative and concise! Easy to follow and listen to.

By Haboub Smail

i understant this coure thank you so much

By Steven Ha

Super short and to the point.

Introductory level.

By ãƒžã‚¹ã‚«ãƒ¯ ã‚·ã‚²ãƒ«

Very good to review what conditional format can do!

By Bobbie Smith

Amazing explanations, I really learned a lot. Thank you.

By Gregoire Aubaret

All conditional formatting methods are clearly explained.

By Timothy Pearson

It's incredibly basic, literally just an explaination of how a single tool within excel works. To his credit that is what he advertised, won't recommend it however.