Search function in excel

1. VLOOKUPVLOOKUP function is used to find the value based on readings in the tablereferences are determined based on the number column (the data are arranged vertically).Forms of Writing= VLOOKUP (Criterion;Table_referral;No_Column_Table_referral; Rangelookup)Example:= VLOOKUP (C3; $ F $ 3: $ G $ 7; 2; TRUE)= VLOOKUP (C3, Table 1; 2; 1)2. HLOOKUPHlookup function is used to find the value based

Making Calendar Automatic with MS Excel

How to make Calender with excel 97|2000|2002|2003|2007MS Excel. At this time our tips will make the function array1. Write a function that you see in the picture carefully (if not visible, click the image to enlarge). Or you copy the formula above list.2. Select the whole cell results from B4: H93. Press F2, press CTRL + SHIFT + ENTER ExcelTags: Microsoft Office, making calender, tips excel,

a quick way to enter today's date

Many user of Microsoft excel typing today's date manually. it is not wrong, but less efficient. especially if you are a people who often forget the date.There are two ways in which more efficient to enter today's date into cell excel data. the first way: press CTRL and ; in the cells that we want. Second way is enter the formula = TODAY () and then press enter. before you made the date, make sure

The first day with microsoft office excel

The improvement of technology really make the human life be easy and easy, but only the man it self perhaps can not use the technology rightly. one of the very important technology that always and every day that we use it is Microsoft office word, Microsoft office excel. the first day with Microsoft may we feel it very difficult, yea..but when we have know the benefit of it, we begin to work hard