Excel Conditional Formatting Basics – The built in Features

2 Likes Comment

Learn how to make Excel format cells at your terms !

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

Info Tutorials/Courses

Includes
  • 1 hour on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
  • [Size: 253.4 MB]

Download Tutorials/Courses

Download Link Google Drive Download Link Google Drive 2

 Download Link OneDrive Download Mirror Links

Password : freetuts.download

About the Author: Ho Thi Phuong Thao

I am Ho Thi Phuong Thao, 26 years old. Graduated from Van Hien University with excellent grades. With 4 years of experience in teaching English and many other subjects. I am an English teacher of American English Center in Vietnam. By loving the teacher and sharing the knowledge widely with everyone, I establish the freetuts.download website to help people download completely free courses in all areas of their lives. I hope to receive the donation from readers. Once again sincerely thank you

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

error: Content is protected !!