by admin
It is important that the data you enter in spread sheet is accurate and error free. Microsoft Excel provides a Data validation tool to ensure that the entered data follows some pre-defined standards. For Example, suppose you are creating a result card of students and you know that no subject has total marks more than 100. This means that you can set a rule that no student can get marks more than 100 in any given subject. This can be done using Data Validation in excel. Every time you violate rule, a message will appear to stop you. Click here to read more
by admin
This article assumes that you have an Excel sheet containing Address and name of peoples and you want to post a standard letter to all of these contacts. Mail Merge, a built in feature in Microsoft word allows us to do this in few simple steps. Without Mail Merge you have to manually create separate copy of letter for each contact and copy paste address information. Click here to read more
by admin
Excel Advanced Filter allows to apply complex filtration criteria. It has all capabilities of AutoFilter plus some enhanced mechanism to filter data. For example if you want to filter only those products which have “juice” in their name or if you have a criteria on the basis of result of a function, this can be achieved by Advanced Filter.
Following are some examples of Advanced Filter
Example 1
Criteria: Find all products which have “juice” in their name, the aim is to get sale of all juices on a given date.
We shall begin with data shown in figure below. Advanced filter is different from Auto Filter. In Advanced Filter, criteria are given in cells above the actual data. As you can see in picture below our data is in range from A6 to E15 but we have similar headings above the data. Doing this we have created a criteria range available from A2 to E4. Remember we must keep an empty row between our data and criteria.
Click here to read more