Make ID Card in MS Word Hindi ✅

Make ID Card in MS Word Hindi

How To : Convert Excel to PDF

Learn how to convert excel to pdf file without any additional software. This can be used to convert any numbers of excel files to pdf format.

Find and Delete Blank Rows in Excel

Find and Delete Blank Rows in Excel



Find and Delete Blank Rows in Excel in one time . You can find all blank rows and delete them at once in excel ! I used the 2 features of excel to delete the blank rows in excel.

How to find and delete all blank rows and delete them

1 - Use Counta formula to identify blank rows

2 - Apply filter to get all blank rows together

3 - Delete all blank rows !

 



To watch more videos and download the files visit http://www.myelesson.org

To Buy The  Full Excel Course visit . http://www.myelesson.org/product    or call 9752003788

Connect with us on Facebook - https://www.facebook.com/excelmadeasy/

Connect with us on Twitter - https://twitter.com/Excelmadeasy

IF AND OR formula in Excel Hindi ✅

Averageifs Formula in Excel

Averageifs formula in Excel is used to calculate averages based on multiple conditions so it  Returns the average of all cells that meet multiple criteria.

10 Most Used Excel Formula

These 10 most used formula in excel will help you use excel in a extremely efficient manner thus allowing you to do work in less time.

Sumifs Formula in Excel

Incase you want to do addition based on multiple conditions then Sumifs formula Sumifs formula can do the job for you.

If Formula in Excel

The IF Formula is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. In its simplest form, the IF function says:

IF(Something is True, then do something, otherwise do something else)

So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False.



Build your knowledge of IF logical tests with LinkedIn Learning. Learn how to use one of Excel's most powerful functions.



 IF function can be used to evaluate both text and values. It can also be used to evaluate errors. You are not limited to only checking if one thing is equal to another and returning a single result, you can also use mathematical operators and perform additional calculations depending on your criteria. You can also nest multiple IF functions together in order to perform multiple comparisons.



The best way to start writing an IF statement is to think about what you are trying to accomplish. What comparison are you trying to make? Many times, writing an IF statement can be as simple as thinking through the logic in your head: “what should happen if this condition is met vs. what should happen if it’s not?” You will always want to make sure that your steps follow a logical progression, or else your formula won’t do what you think it should. This is especially important when you create complex (nested) IF statements.



While Excel will allow you to nest up to 64 different IF functions, it’s not at all advisable to do so. Why?



Multiple IF statements require a great deal of thought to build them correctly and make sure that their logic can calculate correctly through each condition all the way to the end. If you don’t nest your IF statements 100% accurately, then a formula might work 75% of the time, but return unexpected results 25% of the time. Unfortunately, the odds of you catching the 25% is slim.



Multiple IF statements can become very difficult to maintain, especially when you come back some time later and try to figure out what you, or worse someone else, was trying to do.



Multiple IF statements require multiple open and closing parentheses (), which can be difficult to manage depending on how complex your formula becomes.





To watch more videos and download the files visit http://www.myelesson.org

To Buy The  Full Excel Course visit . http://www.myelesson.org/product    or call 9752003788

Connect with us on Facebook - https://www.facebook.com/excelmadeasy/

Connect with us on Twitter - https://twitter.com/Excelmadeasy