How to use COUNTIF Function

by on May 2, 2017

Countif Function COUNTIF formula counts the number of cells within a range based upon the single criteria/condition. It’s work similar to sumif function with the only change is that sumif function sums the numbers while countif count it. In the above, we want to calculate the total number of employees attended the office, the total […]

Conditional Formatting to Find Top 5 Numbers

by on May 2, 2017

Conditional formatting In the previous article, we explore the way how to use conditional formatting to highlight a cell value based upon a single condition. If you have not read it yet, you can do so by clicking here. In this article, you will learn how to use conditional formatting to find Top 5 Numbers […]

How to Use AND function in Excel

by on May 2, 2017

AND Function AND function in excel will return TRUE if all the conditions are met otherwise it will return FALSE. With the help of an example, it will be more clear to you. We have a list of students along with their Marks for the three papers. Passing criteria as you can see is 50 […]

Basics of Excel Charts

by on May 2, 2017

Basics of Excel Charts In the previous article, we prepare the bar chart from our data. In this article, we will provide tips on how to change the settings of your chart according to your needs and requirements. Basics of Excel Charts is the first step to learn about charts and from there you can […]