Lesson#38: AND function in Excel
AND function is used to satisfy multiple conditions. This function checks whether all arguments are TRUE …
Excel Features
Lesson#31: Current dynamic calendar for whole Year
This post is a continuation of one of my previous posts Lesson#27: How to make a …
Lesson#31: Current dynamic calendar for whole Year Read more →
Lesson#30: Modify CONDITIONAL FORMATTING by using formula
In my previous post Lesson#29: Explaining CONDITIONAL FORMATTING very simply I explained CONDITIONAL FORMATTING. In this post, I …
Lesson#30: Modify CONDITIONAL FORMATTING by using formula Read more →
Lesson#29: Explaining CONDITIONAL FORMATTING very simply
CONDITIONAL FORMATTING highlights the cells with a certain color, depending on the cell’s value. It allows …
Lesson#29: Explaining CONDITIONAL FORMATTING very simply Read more →
Lesson#10: Rotate table data from rows to column and vice versa by TRANSPOSE
You are having a table full of data and you want to convert columns to rows …
Lesson#10: Rotate table data from rows to column and vice versa by TRANSPOSE Read more →
Lesson#4: What is Data Validation in Excel?
In this post, we will learn the function DATA VALIDATION. This is very useful for making …