Skip to content
Write a review
UdemyExcelPaid courseBeginner levelCertificate

Excel Conditional Formatting from Basics to Formulas- SMASH! (Udemy.com)

Learn all about Conditional Formatting. From Beginner Level to Formula/Function Based Advanced Exercises

4.5
143 reviews

Created by: João Appleton Ribeiro

Last updated December 2020

icon
What you will learn

  • Highlight Cells Greater/Smaller/Between a certain Value
  • Data Bars, Color Scales, Icon Sets
  • To Use Some functions to Format your data (includes AND, IF, SUM, SUMIF, COUNTIF, VLOOKUP, MATCH and more..)
  • Highlight Top/Bottom Values & Above and below Average
  • Formula base Formating
  • Productivity
  • Presenting Information

How it compares

Against the other 355 rated Udemy courses in Excel on CourseDuck:

  • Rating4.5 out of 5higher than 39% of them
  • Reviews143#323 of 356 by number of reviews
  • Length1.8 hoursshorter than 87% of them
  • Last updatedDecember 2020earlier than 71% of them

icon
Course Description

This course is about automatically formatting your Data with Colors, Icons, Bars (and more) using the Conditional Formatting feature of Excel.
The student will learn Conditional Formatting from the very basics to formula use within the tool. Most of the topics on conditional formatting are covered: basic formatting (Equal, Greater than, Smaller than etc.), formatting with text, etc. We also cover Data Bars, Icon Sets and Color Scales. Finally a good portion of the course is dedicated to formula use within the conditional formatting.
Beginner Beginner Level product length iconTime: 1.8h

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Get the Udemy discount

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

João Appleton Ribeiro

Joao is an IT Consultant and Project/Management Controller working currently for an IT Consulting Firm. His day to day work is around Excel, Power BI and MS Project. 

Academically Joao obtained his Masters Degree in Civil Engineering and a Post-Graduation in Management Control

Loves to teach (was a privater teacher on Mathematics and Physics for a while) and is also a Tennis and Padel lover :)

icon
More Excel courses

$39.99

Free

$99.99

Free

$15.99

$119.99

All Excel courses

icon
Reviews

4.5

143 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

Write a review

By Sergio Barboza on 7/26/2021

Excelente curso, muy bien detallado desde cero a avanzado, lo recomiendo.

By Mohd Haroon Khan on 7/19/2021

Very well explained, never though conditional formatting would be of so use. You made it look easy

By Anushri Boobna on 3/2/2021

It was great with good exercises and pace. Only thing missing was explaining the use of these formulas.

By Roshir Ann Go Poyaoan on 2/13/2021

Learning and happy

By Norzikry Bin Norzufry on 1/9/2021

This course deserves more than five stars. I gain a lot of knowledge from this course. Thank you for the quick responsive message.

By Joviano Silveira on 1/8/2021

João is my big friend and extremely focus on learning. In fact, I rate the course with a maximum note because he goes direct in the point. Good luck my friend!

By Nazibullah Hossain Shourov on 1/5/2021

Great experience. Learnt many things that every employee must know for good work performance.

By Yurika Silvia on 1/4/2021

It is really good lesson and perfect instroctures from the teacher. I can do it well. really great lessons!

By João Costa on 1/4/2021

Great content for those who want to level up their Excel skills! Good fluency and a lot of exercises to practice. Looking forward for more content like this. Keep the good job!

By Gulshan Kumar Mehta on 11/27/2020

Amazing!! Instructor has a great knowledge and explain it in great way.

Showing all 10 reviews on CourseDuck

Read all 143 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 90 / 100

Excel Conditional Formatting from Basics to Formulas- SMASH!
Visit course on Udemy Write a review
  • Video Duration: icon 1.8h
  • Price: $34.99
  • Provider: icon Udemy
  • Updated: icon December 2020
  • Level: Beginner Beginner
  • Language: icon English
  • Certificate: icon Yes
30-day money-back guarantee on most paid courses

Udemy Coupon Price Tracker

Udemy price history

For any issues or feature requests please email CourseDuck's Co-Founder at mkuhlman12@gmail.com