Microsoft Excel : How to Use the VLookUp Function 
VLOOKUP is a Microsoft Excel function that will look up a value in a row based on the value searched on in the first column of that row. This function can be used directly in Excel or in a macro or Visual Basic program using VBA (Visual Basic for Applications). 
























Microsoft Excel 2010 : Calculating the Mode (part 1) 
The mean gives you a measure of central tendency by taking all the actual values in a group into account. The median measures central tendency differently, by giving you the midpoint of a ranked group of values. The mode takes yet another tack: It tells you which one of several categories occurs most frequently. 

Microsoft Excel 2010 : Calculating the Median 
The median of a group of observations is usually, and somewhat casually, thought of as the middle observation when they are in sorted order. And that’s usually a good way to think of it, even if it’s a little imprecise. 











Microsoft Excel 2010 : SUBTOTAL Function, Subtotal Tool 
The SUBTOTAL function is very useful, but if you have a large dataset it can be time consuming to insert all the Total rows. When your dataset is large, use the Subtotal tool from the Data tab in the Outline group. This tool will group the sorted data, applying the selected function. 

Microsoft Excel 2010 : Using Formulas  Troubleshooting Formulas 
It can be frustrating to enter a formula and have it either return an incorrect value or an error. An important part of solving the problem is to understand what the error is trying to tell you. After you have an idea of the problem you’re looking for, you can use several tools to look deeper into the error. 







Microsoft Excel 2010 : Analyzing Data by Using Descriptive Statistics 
Experienced business people can tell a lot about numbers just by looking at them to see if they "look right." That is, the sales figures are about where they’re supposed to be for a particular hour, day, or month; the average seems about right; and sales have increased from year to year. 


Microsoft Excel 2010 : Varying Your Data to Get a Desired Result by Using Goal Seek 
When you run an organization, you must track how every element performs, both in absolute terms and in relation to other parts of the organization. Just as you might want to reward your employees for maintaining a perfect safety record and keeping down your insurance rates, you might also want to stop carrying products you cannot sell. 


Microsoft Excel 2010 : Defining an Alternative Data Set 
When you save data in an Excel worksheet, you create a record that reflects the characteristics of an event or object. That data could represent the number of deliveries in an hour on a particular day, the price of a new delivery option, or the percentage of total revenue accounted for by a delivery option. 

