Excel Conditional Formatting Master Class

Learn how to use Conditional Formatting in Excel! Take your knowledge and skills to the next level.

Over 1000 people have taken this course!

When you see conditional formatting in Excel for the first time, you are amazed, to put it mildly. If Excel formatting makes your spreadsheets visually pleasant, conditional formatting in Excel makes them infinitely more powerful and useful. In this easy-to-follow Excel course, you will not only learn the basics of conditional formatting in Excel, but also become comfortable with more advanced conditional formatting techniques, such as conditional formatting based on text, conditional formatting based on another cell, conditional formatting based on a date, or on a range of dates, as well as conditional formatting with formulas, range-based conditional formatting rules and more. This Excel conditional formatting course will quickly build your Excel skills. It will serve you well as an Excel conditional formatting tutorial that takes your productivity to the next level.

When you take this course, you will benefit from over 3 hours of high-quality video material, so you can quickly improve your Excel skills. After you enroll and complete this course, you will have acquired various carefully selected conditional formatting tips and tricks.

This course is designed with a conditional formatting problem-solving approach in mind. The majority of these high-quality video lessons first introduce and define a specific, real-life problem and then provide an elegant conditional formatting based solution, so you can apply the newly-acquired skills immediately.

After you have taken this course, you will:

1) Become more productive in Excel.

2) Enhance your conditional formatting skills.

3) Save time with conditional formatting at work.

4) Make your spreadsheets more dynamic with conditional formatting.

5) Impress your boss, your colleagues, and your clients.

6) Improve your data analysis capabilities with conditional formatting.

7) Become comfortable with conditional formatting formula based rules.

This Excel course is one of the Easy Excel With Igor series. The other high quality Excel tutorials include:

"Microsoft Excel Without Pain" that helps you quickly build your foundation skills in Excel;

"Data Manipulation In Excel" allowing you to save up to 90% of time when using Excel for certain data management tasks;

"Excel Pivot Tables Data Analysis Master Class" that takes you step by step to mastering pivot tables data crunching skills;

"Microsoft Excel Charts Master Class" that builds your skills in creating your skills in Excel charts and graphs.

Learning Tips
Conditional Formatting Based On Text - Problem Definition
Text-Based Conditional Formatting Rules - Solution
Less Than, Greater Than, Equal To - Problem Definition
Less Than, Greater Than, Equal To - Solution
Date-Based Conditional Formatting (Date Occurring) - problem definition
Conditional Formatting Based On Dates (Date Occurring) - Solution
Highlight Duplicates - Problem Definition
Highlight Duplicates - Solution
Top-Bottom - Problem Definition
Top-Bottom - Solution
Data Bars, Icon Sets, Color Scales - Introduction
Data Bars, Icon Sets, Color Scales - Solution
Copy And Clear Rules
Some Useful Points On The Default Conditional Formatting Rules
Custom Conditional Formatting Rules - Overview Of Tools
Icon Sets In Excel Based On Specific Numbers
Displaying Icon Sets In Another Column
Icon Sets Based On A Formula
Icon Sets Triggered By Percents And Percentiles
Custom Data-Bar Rules
First Formula-Based Conditional Formatting Example - Problem Definition
First Formula-Based Conditional Formatting Example - Solution
Timesheet With Conditional Formatting - Problem Definition
Timesheet - Solution
Timesheet - One More Solution
Conditional Formatting Based On VLOOKUP - Problem Definition
VLOOKUP in Excel Conditional Formatting - Solution
Alternating Row Color With Conditional Formatting
Use Conditional Formatting To Highlight Row And Column - Problem Definition
Highlight Row And Column - Solution
Secret Message With Conditional Formatting
Thank you!!!

What's included

  • 34 Video Lessons

  • Works on all devices
  • Certificate of completion

Igor Ovchinnikov