Lesson#68: COUNTIFS and SUMIFS function in Excel
COUNTIFS is a function to count those cells within a range which meets multiple criteria.Syntax of …
Lesson#68: COUNTIFS and SUMIFS function in Excel Read more →
Author: Pushpendu Roy Karmakar
Hi! I am Pushpendu. I am the founder and author of Excelabcd. I am little creative person, blogger and Excel-maniac guy. I hope you enjoy my blog.
Lesson#67: Count cells in Excel having values between two dates
Here I am having a list of dates. Now I will show how to count cells …
Lesson#67: Count cells in Excel having values between two dates Read more →
Lesson#66: How to take print in excel?
This post will provide you with a basic idea about how to take print in excel …
Lesson#65: Inserting Slicer and Timeline in PIvottable
Slicer and Timeline are just more interactive filters. We can show the pivot of filtered data …
Lesson#65: Inserting Slicer and Timeline in PIvottable Read more →
Lesson#64: Freeze panes must be kept in mind
Freeze Panes is a very important feature that is required in spreadsheets. It’s better to keep …
Lesson#63: COUNT, COUNTA, COUNTBLANK explaination
Here I will discuss three functions COUNT, COUNTA, and COUNTBLANK, and show their similarity or difference. …
Lesson#63: COUNT, COUNTA, COUNTBLANK explaination Read more →
Lesson#62: Making a Sine curve
Here I will show how to make a Sine curve but before that, we have to …
Lesson#61: Making a semi analog clock with pie chart
OK friends! How is everyone? Now in this post, we will learn an unusual trick to …
Lesson#61: Making a semi analog clock with pie chart Read more →
Lesson#60: Excel shows global warming
Here I have gathered 100 year’s precipitation and average temperature data from www.indiawaterportal.org. For example, I …
Lesson#59: If A=1, Z=26 then calculate the value of your name
This sheet can calculate the value of your name or any word by summing every letter …
Lesson#59: If A=1, Z=26 then calculate the value of your name Read more →