We have discussed working with PivotTable in previous lessons. Here I am going to share a small tip about GETPIVOTDATA in PivotTable. How to get rid of GETPIVOTDATA in PivotTable. When we are making some calculations on the Pivot data …
Lesson#139: How to get rid of GETPIVOTDATA in PivotTable Read more »
Sometimes when we work in excel we forget to save the file and we exit excel. But it is possible to recover the last unsaved file very easily if needed. Here I will show you the way. How to recover …
Lesson#138: How to recover unsaved files in Excel Read more »
Now I will show you to make a formula that can count any specific character or characters in a text. This means if I write a “Banana” then this formula can count how many “a” is in that text. So …
Lesson#137: How to count any character in a text in Excel Read more »
Here I will make you learn another good and easy feature of Excel, Remove Duplicates. In this post, you will learn how to Remove Duplicates in Excel works and when and why to use them. See the above picture I …
Lesson#136: Learn how to Remove Duplicates works Read more »
In this post, I will show you to make two new functions. These are functions MAXIF and MINIF. It means this formula will show the Maximum or the Minimum value when the criteria will be matched. Here I have put …
We know about errors in excel. We face different types of errors when working in excel. Today I will discuss different types of errors and why it shows. What is #DIV/0! in Excel? Its meaning is division by zero. When …
Hello friends. I am back with another interesting lesson. How to make auto numbering formulas in Excel. I named that formula auto numbering because it helps to create automatic serial numbers. Now I am showing you these formulas with an …
In this post, I will show you the trick to make the function SUMPRODUCTIF. We have the SUMPRODUCT function in excel. But how to make a SUMPRODUCT function that follows criteria like SUMIF? Here I have made an example. Here’s …
Lesson#132: How to make the function SUMPRODUCTIF Read more »
