What IF analysis Function

by on August 3, 2017

What IF analysis Function Excel has great analytical functionalities with which one can easily test different scenarios and assess its effects on the results. What IF analysis function used to create scenarios. Assume you are planning to launch a new product or project.  The first step of your planning is to assess what amount of sales […]

Name Manager in excel

by on July 10, 2017

Name Manager in excel Name Manager in Excel is an important function where we give a name to a cell or range of cells. Instead of referring cells in our formula, we refer to the name. Here, we will learn how to use the Name Manager function in excel and what’s are its benefits.  Our aim […]

excel if statement

by on May 2, 2017

excel if statement “IF” function is a logical function which returns one value if the condition is met otherwise it returns other value. Below is the list of students along with their marks. We will use the “IF function” to arrive at the number of students passed the exams. Passing criteria is 40 or more […]

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 […]