Lesson#140: Color cells if cell value found in another column – Conditional formatting
Here I will make a formula in Conditional Formatting. This formula will color cells if the …
Lesson#140: Color cells if cell value found in another column – Conditional formatting Read more →
Lesson#139: How to get rid of GETPIVOTDATA in PivotTable
We have discussed working with PivotTable in previous lessons. Here I am going to share a …
Lesson#139: How to get rid of GETPIVOTDATA in PivotTable Read more →
Lesson#138: How to recover unsaved files in Excel
Sometimes when we work in excel we forget to save the file and we exit excel. …
Lesson#138: How to recover unsaved files in Excel Read more →
Lesson#137: How to count any character in a text in Excel
Now I will show you to make a formula that can count any specific character or …
Lesson#137: How to count any character in a text in Excel Read more →
Lesson#136: Learn how to Remove Duplicates works
Here I will make you learn another good and easy feature of Excel, Remove Duplicates. In …
Lesson#136: Learn how to Remove Duplicates works Read more →
Lesson#135: MAXIF and MINIF with function IF
In this post, I will show you to make two new functions. These are functions MAXIF …
Lesson#134: Excel errors and why it shows
We know about errors in excel. We face different types of errors when working in excel. …