Learn Excel Conditional Formatting with 7 Practical Problems
4.5 (71 ratings)
8,934 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn Excel Conditional Formatting with 7 Practical Problems to your Wishlist.

# Learn Excel Conditional Formatting with 7 Practical Problems

Learn Excel Conditional Formatting features (both common rules and formula based) to visualize the insight of your data.
4.5 (71 ratings)
8,934 students enrolled
Created by Kawser Ahmed
Last updated 6/2016
English
English [Auto-generated]
Current price: \$10 Original price: \$40 Discount: 75% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
• 1.5 hours on-demand video
• 3 Articles
• 1 Supplemental Resource
• Access on mobile and TV
• Certificate of Completion
What Will I Learn?
• Learn how to use Excel Conditional Formatting Rules.
• Learn how to Create Formula Based Conditional Formatting rules.
• And learn how to manage rules and locate conditionally formatted cells in a worksheet.
View Curriculum
Requirements
• Microsoft Office Software installed in your computer.
Description

Teaching 11 Courses on Excel and Data Analysis!

OVER 25,000 visitors visit my blog ExcelDemy dot com every month!!

OVER 15,000 successful students have already taken my online courses since November, 2015 with 375 total Reviews!!!

Course Updated:  Nov 01. 2016

Visualizing data is the core idea of all type of data analyzing. Excel conditional formatting is a very useful Excel tool to visualize numeric data. And Microsoft has updated this tool in every version of Excel. In this Excel conditional formatting crash course, we will discuss conditional formatting features using Excel 2013 version.

Let’s discuss now what you will learn from this course.

1. High Light Cells Rules: At first you will learn how to highlight cells using conditional formatting rules.
2. Top/Bottom Rules: Then you will work with Top/Bottom conditional formatting rules.
3. Then you will use data bars.
4. Then you will work with Color Scales and Icon sets.
5. Formula based conditional formatting rules: Using formulas in conditional formatting rules will give you huge benefit to visualize data in unique ways. I have used total 7 practical examples to teach you formula based conditional formatting rules. And I have added some relevant practice problems with every lecture. If you watch the lectures and practice the problems, I can guarantee, you will be an expert in using formulas in conditional formatting rules.
6. Then I have showed you how to manage conditional formatting rules.
7. And finally I have showed you how to locate conditional formatting cells in a worksheet.
8. Here is not the end of the course. Time to time, I shall add more lectures to the course that will teach you how to face real life data visualization using Excel conditional formatting rules.

So, if you are interested to learn Excel conditional formatting features with real life problems, then this course is for you. Thanks for reading. Enjoy the course!

Who is the target audience?
• This course is meant for intermediate level Excel users who are familiar with the general concepts of Excel features.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
20 Lectures
01:21:37
+
Welcome to the Course! Enhance Data Insights Using Excel Conditional Formatting
5 Lectures 13:22

What you will get from this Excel lecture:

1. You will be welcomed to the course. The instructor of this course is thankful to you that you have enrolled into this course.
2. You will know which versions of Microsoft Excel has been used to create this course. You will also get idea which versions you can use to follow this course.
3. You will have an idea how to use this course to get the best from it.
Preview 01:56

What you will get from this Excel lecture:

1. This is the download section of the whole course. You will get all the working files, practice problems, Video Index Dashboard, Excel keyboard shortcuts PDF, and other Excel resources in one place.
2. You will also get an idea how to instantly contact me when you face an Excel or Course related problem.
01:02

1. You will get a list of websites where you can solve Excel related real life problems. If you cannot solve a problem, follow how other experts in the community solve that problem.
2. Learn from trying to solve an Excel problem or learn from others who solve problems.
List of sites where you can practice Excel problems
00:45

This video is actually about UDEMY platform. You will lea

1. How to enter the course.
2. How to use the platform to best view the course.
3. There are several options in the platform. Without knowing them in details, you cannot expect to best use of the course.
Preview 06:58

In this video, you will see how you can get the certificate of your completion of the course.

How to Review this Course and Obtain Your Certificate of Completion
02:40
+
Conditional Formatting - Mastering Excel Conditional Formatting
5 Lectures 33:06

In this video lecture:

1. You will learn how to highlight some cells using conditional formatting based on the following rules:
1. Greater than
2. Less than
3. Between
4. Equal to
5. Text that contains
6. A Date Occurring
7. And Duplicate Values
2. You will also learn how to use the New Formatting Rule dialog box to work with more rules.
Highlight Cells Rules - Highlight Cells Rules on Basis of Rules
09:11

In this video lecture:

1. You will learn how to highlight cells using conditional formatting Tot/Bottom Rules like:
1. Top 10 Items
2. Top 10%
3. Bottom 10 Items
4. Bottom 10%
5. Above Average
6. And Below Average
Preview 04:21

In this video lecture:

1. You will learn how to conditionally format cells using Data Bars.
2. You will learn how to show Data Bars in many ways.
3. You will also learn how to show negative values differently.
Data Bars: Using Data Bars to Format Cells
11:01

In this video lecture:

1. You will learn how to format cells conditionally using Color Scales.
2. You will also learn how to create customized color scales using New Formatting Rule dialog box.
Color Scales: Using Color Scales to Format Cells
04:32

In this video lecture:

1. You will learn how to create icon sets conditional formats.
2. You will also learn how to create custom type icon sets.
Icon Sets: Using Icon Sets to Format Cells
04:01
+
Formula Based Excel Conditional Formatting Rules
7 Lectures 27:35

In this video lecture:

1. You will learn how to format cells using formula based conditional formatting.
2. You will learn about ISTEXT(...) Function.
3. And you will learn again how to use Absolute Referencing in formulas.
Formula-Based Rules & Understanding Relative and Absolute References
05:36

In this video lecture:

1. You will learn how to highlight the weekends from some dates using formula based conditional formatting.
2. And you will practically use two functions: WEEKDAY() and OR() functions.
Preview 03:51

In this video lecture:

1. You will learn how to highlight a whole row using formula based conditional formatting.
2. And you will work with Absolute, Relative and Mixed Cell Referencing again in this video.
Highlighting a Specific Row Using Formula Based Conditional Formatting
03:44

In this video lecture:

1. You will learn how to highlight alternating rows using formula based conditional formatting.
2. You will use MOD() and ROW() functions to build the formula.
Highlighting Alternative Rows Using Formula Based Conditional Formatting
03:14

In this video lecture:

1. You will learn how to create a Checker Board using formula based conditional formatting.
2. You will use MOD() and ROW() functions again in this video tutorial.
Creating Checker Board Shading in a Range
03:17

In this video lecture:

1. You will learn how to shade alternating rows of a range using formula based conditional formatting.
2. You will use INT(), MOD() and ROW() functions to build the formula.
Grouping Rows: Using Formula Based Conditional Formatting
04:25

In this video lecture:

1. You will learn how to hide the data of a cell based on the data of another cell. To do this, you will use formula based conditional formatting.
2. You will use COUNT() function to build the formula.
Showing Total Row When All the Data are Entered in a Range
03:28
+
Managing Excel Conditional Formatting Rules
2 Lectures 05:47

In this video lecture:

1. You will learn how to manage the conditional formatting rules in great details. You will learn:
1. How to Edit Rules
2. How to Delete Rules
3. How to create New Rules.
4. And how to move up and move down existing Rules.
Manage Rules - How to Edit and Delete Existing Rules
03:03

In this video lecture:

• You will learn how to locate cells that have conditional formatting rules.
Locating Cells that Contain Conditional Formatting in a Worksheet
02:44
+
1 Lecture 01:53

Want to get an in-depth knowledge of Microsoft Excel? Join my Advanced Excel 2013 Training + Build a Pro Excel Template course for 50% Off. Or join my Data Analysis in Excel with Statistics: Get Meanings of Data course for 50% Off.

Bonus Lecture: A Special Offer for You!
01:53
 4.4 Average rating 1,568 Reviews 41,325 Students 11 Courses
Founder ExcelDemy.com | Data Analyst

Love to see you here!

I am Kawser Ahmed, father of two beautiful angels (Marissa and Arissa), a full-time data analysis blogger (using Excel & other tools), corporate Excel trainer, & entrepreneur.

I love to make courses in the combination of both theory and practice.

Monthly 30,000 Excel users visit my Excel blog ExcelDemy (follow the website link in the profile).

I love to learn and teach (teaching from my eighteen)!

Visit my blog!

You will find plenty of useful posts, articles, video tutorials, and important Excel resources.

What I love most is: add some value to people around me, believe me!

Here are some of my working areas:

• 1. Corporate Budgeting, Planning & Forecasting
• 2. Mission-critical financial processes
• 3. Month-end close processes
• 4. Big Data Analysis using Excel
• 5. Company Reports (Sales, Marketing, Administrative)
• 6. Large Projects using Excel VBA
• 7. Dashboard Design using Excel
• 8. And Basic Accounting

I am always around you to help and support!

Just knock me!