AND function is used to satisfy multiple conditions. This function checks whether all arguments are TRUE then it returns TRUE. Syntax of that function is AND(logical1, logical2, ….) Example: Here I have shown an example where the values of the …
This post is a continuation of one of my previous posts Lesson#27: How to make a calendar in excel without VBA. I will show how to modify this calendar a little more and make it a current dynamic calendar for …
Lesson#31: Current dynamic calendar for whole Year Read more →
In my previous post Lesson#29: Explaining CONDITIONAL FORMATTING very simply I explained CONDITIONAL FORMATTING. In this post, I will show how to modify CONDITIONAL FORMATTING by using a formula. 1st you have to select the area where you want to apply CONDITIONAL …
Lesson#30: Modify CONDITIONAL FORMATTING by using formula Read more →
CONDITIONAL FORMATTING highlights the cells with a certain color, depending on the cell’s value. It allows you to distinguish those cells of the given criteria in the spreadsheet. This is a very essential feature of excel. In this post, I …
Lesson#29: Explaining CONDITIONAL FORMATTING very simply Read more →
You are having a table full of data and you want to convert columns to rows or vice versa. Excel has a feature that is TRANSPOSE which allows pasting rows as columns and columns as rows. For Example, I have …
Lesson#10: Rotate table data from rows to column and vice versa by TRANSPOSE Read more →
In this post, we will learn the function DATA VALIDATION. This is very useful for making proper data entry. I will give a good example of where we can use it. I made a report card format in another sheet, …