In this tutorial you will learn how to use lookup function in excel. Lookup function is use to search data in work sheet of microsoft excel. It is very powerful feature of microsoft excel by which search of data is very easy in excel sheet. You can type it like as following. =LOOKUP(Value, Range ofRead more »

In this tutorial you will learn use named range in excel. Use of named ranges make your excel sheet and formulas or functions convenient. So management of formulas be easy and time saving in microsoft excel. First you need to select the cells for which you define a name.After define a name select the cellRead more »

In this tutorial you will learn about how to use absolute cell reference in excel. Absolute cell reference is the address of cell with $ sign. It is beneficial in copying formula from on place and paste that formula to another place in microsoft excel. Because if you did not use absolute cell reference inRead more »

In this tutorial you will learn why and how to use goal seek in excel. By using goal seek you can find the values of result about which you are not sure. Goal seek is powerful feature of microsoft excel and it helps in analysis. use goal seek in excel example:- Create a spread sheetRead more »

In this tutorial you will learn how to use custom named range in excel. Custom named ranges are used in microsoft excel for define a constant value.E.g. the value of PI be constant, G be the gravitational constant and g be the standard gravity etc. use custom named range in excel example:- Create a spreadRead more »

In this tutorial you will lean how to use pivot table in excel. Pivot table is use to display information in the format of report. By using pivot table information display on the sheet in efficient manner. For increase the readability of Data convert it into tabular form through the pivot table. Pivot table provideRead more »

In this tutorial you will learn how to use scenarios in excel. Scenarios are same as data tables but slightly different from data tables in microsoft excel. This option is under the what if analysis menu of tool panel of data menu in microsoft excel. Scenarios are useful for the management of the budget andRead more »

In this tutorial you will learn that how to use data table in excel. Use Data table in excel for evaluation of the changing results of the cells values which use in formula. If you are designing a sheet for the company that gives loan to clients so then data table is very useful forRead more »

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 »

« Previous PageNext Page »