School college data management examples simples ideas

Drop-down List tutorial in Urdu

Drop-down lists in Excel are helpful if you want to be sure that users select an item from a list, instead of typing their own values.

1. On the second sheet, type the items you want to appear in the drop-down list.

Excel Vlookup in ms excel in Urdu

Vlookup is most widely used formula in Excel. Vlookup stands for “Vertical Lookup”. It searches the first column of a table array and then selects value in right hand side columns of table array in the same row.
Syntax:
=VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
Lookup_value: Lookup value is the value that has to be searched in the first column in left hand side of the tabl array. If lookup_value is found in the first column of the table array, it will look for the data in right hand side columns in same rows

Creating VBA Form in Excel for Data Entry

Today we will learn an advance and very useful topic in VBA Excel. We will learn to create a VBA form for data entry in MS Excel.
Although MS Excel has already great interface to work with rows and

How to link to values in another Excel 2010 worksheet or workbook - See more at: http://www.exceldigest.com/myblog/2013/06/20/how-to-link-to-values-in-another-excel-2010-worksheet-or-workbook/#sthash.UWsC96ll.dpuf

In Excel 2010 or 2007, if you want data from one worksheet to be linked to, or shown in another worksheet then follow these steps:

1. In the sheet you want to link to (source) select the cell where the value is stored.

2. Right click and select Copy.

3. In your main sheet (target), select the cell where the value is to be displayed and right click on it.

4. In the displayed context menu, under Paste Options, click on Paste Link (the last icon to the right).

5. The value in the source sheet will now be reflected in the target sheet. Notice the link to sheet1 in the formula bar.

6. Every time the source sheet is updated, the target sheet will also be updated with the new values.

7. The same procedure can be applied to link to data in another workbook.

- See more at: http://www.exceldigest.com/myblog/2013/06/20/how-to-link-to-values-in-another-excel-2010-worksheet-or-workbook/#sthash.UWsC96ll.dpuf

Add, edit, find, and delete rows by using a data form

Show All

When a row of data is very wide and requires repeated horizontal scrolling, consider using a data form to add, edit, find, and delete rows.

What do you want to do?

• Learn about data forms
• Create a data form
• Use a data form
• Add a new row of data