In this tutorial you will learn how to use conditional cell format in excel. Microsoft excel providing powerful features of formatting of cells, sheets and fonts etc. So conditional format can be used in result sheet for representation of results in effective way. You can use it in the result sheet of students, result sheetRead more »

In this tutorial you will learn that how to use sumif function in excel. SUMIF function is same like as COUNTIF function but having different number of arguments. You can use sumif function for calculating the total of values for some condition. E.G. use it when you want to check how much payment paid orRead more »

In this tutorial you will learn why and how to use countif function in excel. By countif function you can count the cells having required value. If you want to check from student marks sheet how many students are passed the exam you need to use countif function. Also you can find how many studentsRead more »

In this tutorial you learn how to use if function in excel. If function is use for perform calculation on condition. We can use it for decision making in excel sheet. By using it you can find win or loose candidate, pass or fail student, paid or unpaid bill. Basically it check the given conditionRead more »

In this tutorial you will learn that how to use financial function in excel. You can calculate loan payments by using the PMT function. Syntax of PMT function is as following. PMT(rate, nper, pv, fv, type) where rate is interest rate, nper is number of payments for loan, pv is present value, fv is futureRead more »

In this tutorial you will learn how to use time function in excel and why use time function. Time function is one of the built in functions of excel. This is used for representation of time. Time function is write as following. =TIME(hour,minutes,seconds) Find time by giving the hours, minutes and seconds. Also can findRead more »

In this tutorial you will learn that how to use average function in excel for calculating average of values. Average is value arithmetic mean value that is calculate by adding all values and divided by no of values as summation of values/no of values. Excel provide powerful feature for calculating average of values in differentRead more »

In this tutorial you will learn how to use date function in excel. If you have to manage the record of students so you need to have to give some importance to date e.g. you have stored record of students that are enrolled. So you want to search age when student enrolled. So this isRead more »

In this tutorial we will learn how to use product function in excel. In earlier tutorials you learn how to multiply values of two cells in excel. For multiplication earlier use =First cell reference* Second cell reference Like =A1*B1 If want to multiply the values of A1,A2,A3,A4,A5,A6,A7 and A8 so according to earlier tutorials. =A1*A2*A3*A4*A5*A6*A7*A8Read more »

In this tutorial we will learn how to use sum function in excel. In earlier tutorial you see that we use sum function but that was basic. Now some advancement use of sum function. First use sum function as following =Sum(first cell reference: second cell reference) like =Sum(A1:B1). If you want to add consecutive cellsRead more »

Next Page »