Use Excel Conditional Formatting to Enhance Data Analysis Premium class

John Smith

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
34 Videos (1h 13m)
    • What Is Conditional Formatting?

    • More Examples of Using Conditional Formatting

    • Excel Knowledge Prerequisites Before Taking This Course

    • How to Remove Conditional Formatting

    • Greater Than

    • Less Than

    • Between

    • Equal To

    • Text That Contains

    • A Date Occurring

    • Duplicate Values/Unique Values

    • Top and Bottom X Amount of Items Conditional Formatting

    • Top and Bottom X% of Items Conditional Formatting

    • Above and Below Average Conditional Formatting

    • Gradient and Solid Data Bar Fills

    • Introduction and Explanation of Icon Sets

    • Directional Icon Sets

    • Shapes and Indicator Icon Sets

    • Ratings Icon Sets

    • Conditional Formatting Based on a Specific Cell (Highly Recommended)

    • Using Conditional Formatting In Filters

    • Order of Conditional and How to Change It

    • Introduction to Creating Your Own Custom Conditional Formatting Rules

    • Before Creating Custom Formulas You Need to Know How to Lock Rows and Columns

    • Highlight Cells Containing Time Information Using Formulas

    • Creating Custom Icon Set Ranges

    • Highlighting the Whole Row Based on a Column

    • Dynamic Way of Selecting Whole Row Based on a Cell

    • Comparing Values In Two Columns Using Formulas

    • Comparing Two Different Lists For Matches or Mismatches

    • Changing Colours of Alternating Rows Using Formulas in Conditional Formatting

    • Finding Duplicates Using Formulas in Conditional Formatting

    • Finding Duplicates Using Criteria From Two Columns

    • Using Conditional Formatting to Find Discrepancies


About This Class

What is conditional formatting and why is it useful for you?

Conditional formatting allows the user to format a group of cells based on one or multiple criteria. This means that you do not have to format the cells manually and you can let Excel do all the work for you! Also, if there is change in the data Excel will automatically change the formatting, if the cell will now meet a different criteria.

Most frequently I use conditional formatting to allow me visualize the data, meaning that I can start analyzing the data before even looking at the values themselves. This means that you can increase your productivity working with Excel to a high degree using conditional formatting.

You can preview the introduction lectures in order to see some of the applications of conditional formatting in order to get a better understanding how it can be used.

About this course:

In this course I show everything step-by-step, meaning that I will be showing each single button that I press. By doing this I want to make sure that you memorize all the steps and can apply conditional formatting in your own Excel spreadsheets.

This course is designed for a beginner/intermediate level. You need to have Excel fundamentals, meaning that you will have to know how to open an Excel file, save it and other similar fundamentals. However, you do not need to have an advanced knowledge of Excel. The most advanced part of this course is when I will be teaching you to use formulas to make a condition. However, I will explain each formula in depth, meaning that you do not have to worry that you will not understand it.

However, if you are an advanced Excel user, you might still want to go through the course in order to refresh your knowledge and possibly learn a couple of new tips.

By the end of this course you will be able to:

  • Become more productive with Excel and save time
  • Enhance the data analysis capabilities with conditional formatting
  • Learn how to use conditional formatting
  • Perform multiple conditional formatting rules to the same group of cells
  • Use conditional formatting to highlight group of cells
  • Use conditional formatting top and bottom rules
  • Use conditional formatting icons to highlight cells
  • Use conditional formatting based on text rather than simply numbers
  • Learn how to use formulas in conditional formatting
  • Create various custom rules using formulas
  • Edit existing conditional formatting rules
  • Impress your manager, colleagues and clients

Other benefits from taking this course:

  • You will get lifetime access to this course
  • This course is frequently reviewed and you will get access to the new lectures for free
  • My help is available to you, if you get stuck or have a question






I have been an online entrepreneur since 2010 using various methods of earning money online. I have multiple YouTube channels, tried working with affiliate marketing, consultant on Internet, Forex, selling e-books and an online teacher on Udemy. I love to share my own experiences both from my entrepreneur life and also when I was working in one of the largest corporations in the world (see my CV below).


YouTube: Over 5 million viewers on my main channel, increasing by 100,000 viewers per month. I have several other channels, which are training related.

My CV:

I finished my BSc Business and Management in one of the top UK universities with a first class degree. After getting the degree, I worked in one of the major corporation that is in Fortune 500. Hence, I am familiar to the corporate culture and the daily life of working in major corporations.

While working for the corporation I have come across many different people that I had to work with. I have also had the opportunity to attend many different business trips in various countries with different cultures, which has allowed me to understand how differently business operations are carried out in different countries.

Right now I work online as an entrepreneur, which has been mentioned before.