BlogIyo.com

Normal
0

false
false
false

MicrosoftInternetExplorer4

/* Style Definitions */
table.MsoNormalTable
{mso-style-name:”Table Normal”;
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:”";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:”Times New Roman”;
mso-ansi-language:#0400;
mso-fareast-language:#0400;
mso-bidi-language:#0400;}

Share This

Using Data Validation to input data into Excel cells can improve your productivity substantially. Surprisingly few people use the data validation feature in Excel!

Data validation is the simple process of inputting data into Excel cells using defined criteria. For example, let’s say, you need to enter the names of the employees in an Excel worksheet regularly. Why think about the spellings or try to remember all the names? You create a list and then arrange the cells in such a way that you can select the names from a drop down list. Similarly, let’s assume you need to enter the prices of items that you sell or the salary of the employees. Create a list!

Share This

Once you have data in an Excel worksheet, the next step is to extract information out of the data. For example, a teacher may need to know which students got grade A in Maths, an employer may need to know about all the employees who were absent for more than 3 days in a month or a doctor may need to know how the patient responds to a certain medicine.

Share This