The SUMIF function adds cells specified in range by a certain condition or criteria.

HLOOKUP stands for horizontal lookup. The difference between HLOOKUP and VLOOKUP is that HLOOKUP searches for data in rows instead of columns.

Adding a command to the Quick Access Toolbar is quite easy in Microsoft Excel 2007.

Excel’s concatenate function is used to combine character strings from multiple cells. This function can be extremely useful if you need to perform a manual task on a large list of data.

VLOOKUP in excel stands for vertical lookup. This simple function is extremely useful if you have large lists of data. With this function, you can easily search through a list of data and match specific criteria. In the example below, we will use this function to match a batting average with a specific player.