When you want to get the smallest or the largest number from an array then it’s just using the function MAX and MIN. But if you want to get the Kth largest or Kth smallest then there are more two …
Lesson#69: LARGE and SMALL function in Excel | Get the Kth largest or Kth Smallest Read more »
COUNTIFS is a function to count those cells within a range which meets multiple criteria.Syntax of the function is COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…) criteria_range1 – This is the first range to evaluate. criteria1 – The criteria to be used on criteria_range1. criteria_range2 – …
Lesson#68: COUNTIFS and SUMIFS function in Excel Read more »
Here I am having a list of dates. Now I will show how to count cells in Excel having values between two dates. So I made here a list of months from Jan-18 to Dec-18. Then I have put this …
Lesson#67: Count cells in Excel having values between two dates Read more »
This post will provide you with a basic idea about how to take print in excel properly. First, you have to select the area which you want to print as I have shown in the picture above. Then you have …
Slicer and Timeline are just more interactive filters. We can show the pivot of filtered data by clicking on them. Clicking on PivotTable shows the PivotTable TOOLS tab. There you have to click on the Insert Slicer. It will show a …
Lesson#65: Inserting Slicer and Timeline in PIvottable Read more »
Freeze Panes is a very important feature that is required in spreadsheets. It’s better to keep it always in mind. It allows you to freeze rows or columns or both when you are scrolling down or scrolling right throughout the …
Here I will discuss three functions COUNT, COUNTA, and COUNTBLANK, and show their similarity or difference. COUNT COUNTA COUNTBLANK Description The COUNT function counts the number of cells that contain numbers The COUNTA function counts the number of cells that …
Lesson#63: COUNT, COUNTA, COUNTBLANK explaination Read more »
Here I will show how to make a Sine curve but before that, we have to learn two functions SIN and RADIANS. What is the function of SIN? SIN returns the sine of degree which is given in radian format …
OK friends! How is everyone? Now in this post, we will learn an unusual trick to make a semi-analog clock with Pie Chart. Let’s see. First I have made a 3X3 table for the hour, minute, and second of the …
Lesson#61: Making a semi analog clock with pie chart Read more »
Here I have gathered 100 year’s precipitation and average temperature data from www.indiawaterportal.org. For example, I have chosen the city Nagpur which is in the state of India, Maharashtra. I have a column beside the precipitation data to make the …