Advanced Usage Of Conditional Formatting In Microsoft Excel

Advanced Usage Of Conditional Formatting In Microsoft Excel
Published 11/2024
MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz

What you’ll learn

What is conditional formatting

How to use highlight cell rules in conditional formatting with example

How to use top or bottom rules in conditional formatting with example

The usage of data bars in conditional formatting with example

The usage of color scales in conditional formatting with example

How to use icon sets in conditional formatting with example

Multiple criteria based conditional formatting related MS Excel formulas and functions

How to use Multiple criteria based conditional formatting with two real practical examples demonstrate by instructor

Advanced usage of conditional formatting in MS Excel

Requirements

A computer or laptop

No prior MS Excel knowledge is needed.

Microsoft Excel should installed in your computer or laptop

Description

Overview

Section 1: Chapter-01 Introduction to Conditional Formatting

Lecture 1 Introduction

Section 2: Chapter-02 Highlight cells rules

Lecture 2 Highlight cells rules

Section 3: Chapter-03 Top or bottom rules

Lecture 3 Top or bottom rules

Section 4: Chapter-04 Data bars

Lecture 4 Data bars

Section 5: Chapter-05 Color scales

Lecture 5 Color scales

Section 6: Chapter-06 Icon Sets

Lecture 6 Icon Sets

Section 7: Chapter-07 New rules , Clear rules and Manage rules

Lecture 7 New rules , Clear rules and Manage rules

Section 8: Ch-08 MS Excel function for multiple criteria based conditional formatting

Lecture 8 Year ,Month and Day Functions in MS Excel

Lecture 9 AND ,OR, Data validation in MS Excel

Lecture 10 Relative and absolute reference in MS Excel

Section 9: Chapter-09 Multiple Criteria based conditional formatting Practice File -01

Lecture 11 Practice File -01 – Introduction

Lecture 12 Practice File -01 – Apply conditional formatting

Lecture 13 Practice File -01 – Apply Data validation

Lecture 14 Practice File -01 – Create clear all button

Lecture 15 Practice File -01 – Answers of Q3 & Q4 & Q5 & Q6 & Q7

Lecture 16 Practice File -01 – Answer of Q8

Lecture 17 Practice File -01 – Answer of Q9

Lecture 18 Practice File -01 – Answer of Q10

Section 10: Chapter-10 Multiple criteria based on conditional formatting Practice File -02

Lecture 19 Practice File -02 – Introduction

Lecture 20 Practice File -02 – Apply conditional formatting

Lecture 21 Practice File -02 – Apply Data validation

Lecture 22 Practice File -02 – Create clear all button

Lecture 23 Practice File -02 – Answers of Q3 & Q4

Lecture 24 Practice File -02 – Answers of Q5 & Q6 & Q7

Lecture 25 Practice File -02 – Answer of Q8

Lecture 26 Practice File -02 – Answers of Q9 & Q10

The Excel user who wants to work with confidently & clearly,The Excel user who wants to gain a deep understanding about conditional formatting in MS Excel,The Excel user who is looking for enhance their knowledge of MS Excel Conditional formatting and Improve their productivity in efficiently and effectively to the next level,Student willing to learn advanced conditional formatting,MS Excel users