Microsoft Excel: Excel Conditional formatting master(Excell)
3.9 (134 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
14,629 students enrolled

Microsoft Excel: Excel Conditional formatting master(Excell)

Became in a master of Excel. Microsoft Excel 2010, 2013, 2016, Excel 2019 and Office 365 (conditional, formulas, data)
3.9 (134 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
14,629 students enrolled
Created by Denis Kulikov
Last updated 6/2020
English
English [Auto]
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Conditional formatting in Microsoft Excel (advance) (Excell)
  • Conditional formatting interface in Microsoft Excel
  • Rules and rules managing in Microsoft Excel Conditional formatting
  • Basic Conditional formatting sets ( Top 10, bottom 10, Average, date, text and etc.) in Microsoft Excel
  • Formulas  and Custom settings in Microsoft Excel conditional formatting (AND etc.)
  • How to do a conditional formatting on a whole row or column in Microsoft Excel
  • Formatting skills (different types of formatting, how to highlight and hide information by using formatting) in Microsoft Excel
Requirements
  • You have to have Internet
  • You have to have PC or MacBook
  • You have to have Microsoft Excel or access to Google Spreadsheets
Description

*** Microsoft Excel: Excel Conditional formatting master (Excell) course access includes project files, quizzes & homework exercises, 1-on-1 instructor support, LIFETIME access and a money-back guarantee!***

LAST UPDATE - 05/10/2020

__________

FULL MICROSOFT EXCEL: EXCEL CONDITIONAL FORMATTING MASTER COURSE DESCRIPTION:

Microsoft Excel nowadays is an absolutely essential tools for life. The truth is that, Excel is a really powerful, and dynamic data performing software .And one of the powerful tools there - is Conditional formatting and Data visualization. Absolutely everyone could get their life on a new level after studying this Microsoft Excel: Exel Conditional formatting master (Excell) course and applying this knowledge in their lives.

This Microsoft Excel: Excel Conditional formatting master (Excell) course provides you with all the tools and instruments which you need, to understand each of the aspects of Conditional formatting and Data visualization.

I am sure it is not so important to remember each of the functions, more essential is how to understand how Microsoft Excel "thinks" and know where you could find explanation of function which do you need.


Thats why my Microsoft Excel: Excel Conditional formatting master (Excell) course consists of very individual  and simple explanations of each of the functions, which I placed separately. In this case if you forget some function you could come back to my video course and refresh all information in your memory.

__________

We will be raising such topics as: 

  • Conditional formatting interface in Microsoft Excel

  • Rules and rules managing in Microsoft Excel Conditional formatting

  • Basic Conditional formatting sets ( Top 10, bottom 10, Average, date, text and etc.)  in Microsoft Excel

  • Formulas  and Custom settings  in Microsoft Excel conditional formatting (AND etc.)

  • How to do a conditional formatting on a whole row or column in Microsoft Excel.

  • Formatting skills (different types of formatting, how to highlife and hide information by using formatting) in Microsoft Excel

  • And more...

Just check a couple of reviews on my Microsoft Excel: Excel - from Beginner to Advanced (Full Excel course)

  • Amazing course!! There's so much to do with Excel that i couldnt imagine. Now im able to use it not only better in my work, but also for personal stuffs, even for gaming! Thanks a lot!!!!!


  • Nice lectures.I have learned amazing stuff about excel.


  • IT WAS A GOOD EXPERIENCE FOR ME AND IT HELPED ME IN MANY WAYS.


  • it's very good , i benefit from every minute in this course

    and intructor is be graet

    thank to him


My suggestion to you..

If you really want to understand all features and aspects ( such as formulas and functions, data visualization, data analysis, conditional formatting, charts and etc.)in Excel.... Just try this excellent course...

You could use next Software to learn this course:

Windows:

  • Microsoft Excel 2007

  • Microsoft Excel 2010

  • Microsoft Excel 2013

  • Microsoft Excel 2016

  • Microsoft Excel 2019

  • Microsoft Excel 2020

Macbook:

  • Microsoft Excel 2011

  • Microsoft Excel 2016

And all upper Microsoft Excel version of software



__________

NOTE: 

Microsoft Excel: Excel - from Beginner to Advanced (Full Excel course) includes downloadable resources and project fileshomework and course quizzeslifetime access and a 30-day money-back guarantee.

This Microsoft Excel : from Beginner to Advanced (Full course) were created on Microsoft Excel for Macbook 2016

Who this course is for:
  • People who interested in Microsoft Excell
  • People who want to start study Excel and have no any experience in it
  • Excel users who have basic skills but want to be BETTER
  • Anyone who want to expand their analytics skills, work more efficiently with data
  • Anyone who want to take their career to a new level
  • entrepreneurs, marketers, office workers,
  • Students, who want to develop their skills, and make their labor and life more effective
Course content
Expand all 23 lectures 02:13:05
+ Microsoft Excel ( Conditional formatting) - Introduction
3 lectures 22:34

In this Lecture I will show you, How to work with Conditional formatting Rules manager in Microsoft Excel.

We will:

talk about rules and their structure;

Edit;

Delete;

Change order of rules


I will be use Microsoft Excel 365 for Macbook in this lesson

Preview 06:08
How to work with formatting : Microsoft Excel ( Conditional formatting)
05:37
+ Basic cells formatting rules : Microsoft Excel ( Conditional formatting)
6 lectures 32:25
Less then and greater then : Microsoft Excel ( Conditional formatting)
06:32
Between and equal to : Microsoft Excel ( Conditional formatting)
05:26
Duplicate value : Microsoft Excel ( Conditional formatting)
04:49
Text contains : Microsoft Excel ( Conditional formatting)
07:10
Data occurring : Microsoft Excel ( Conditional formatting)
05:08
+ Top and bottom rules : Microsoft Excel ( Conditional formatting)
3 lectures 14:57
Top and bottom 10 Items : Microsoft Excel ( Conditional formatting)
04:49
Top and bottom 10 % : Microsoft Excel ( Conditional formatting)
05:06
Above and below average : Microsoft Excel ( Conditional formatting)
05:02
+ Colores formatting : Microsoft Excel ( Conditional formatting)
3 lectures 17:01
Color scales : Microsoft Excel ( Conditional formatting)
04:45
Data bars : Microsoft Excel ( Conditional formatting)
06:43
Icon sets : Microsoft Excel ( Conditional formatting)
05:33
+ Advance level : Microsoft Excel ( Conditional formatting)
7 lectures 44:26
Conditional formatting based on more then one criteria (formula AND) : Microsoft
05:33
Flexible formatting : Microsoft Excel ( Conditional formatting)
06:55
How to select row or column : Microsoft Excel ( Conditional formatting)
09:50
How to hide values by conditional formatting : Microsoft Excel ( Conditional )
08:04
How to apply Conditional formatting on a different sheet (COUNIF formula) Excel
02:59

Lets check hoe do you understand this lesson

How to apply Conditional formatting on a different sheet (COUNIF formula) Excel
1 question