VLOOKUP Function in Excel
VLOOKUP Function in Excel VLOOKUP is the most powerful function in excel and used to search a value in another table like as we have a one table where Emp Code, Emp Name, Designation...
How to use Datedif function in excel or difference between two dates
If you want to difference between two dates like as Year, Month & Days. The syntax is given below. Datedif( start_date, end_date, unit) Unit Explanation Y Gives us number of years between two dates...
How to add current Date & Time in Excel
If you want to add current date quickly then press shortcut key “Ctrl+;” and output gives you only current Date in excel cell. If you want to add current date and time stamp then...
How to restrict value use of Data Validation
If you want to user enter value as per your criteria like price of product should be in between 50 to 150 and when user will enter wrong value then message will appear like...
How to create Drop-Down box in Excel
By
2.5.16
1 comment:
If you want to user select item from your list instead of other value you can create drop-down box in sheet. Please follow below mention steps. Create list of items which you want to...
How to Change Height & Width in excel
When you have opened multiple graphs in excel and want to align shape and size of graph please follow below mention steps. Select One Chart Hold...
How to switch workbooks in Excel
When you have opened so many workbooks in excel and want to move from one workbook to another please follow below mentioned steps. To switch from book1 (1st excel file), Book2 (2nd Excel File),...