August 25th in Functions by Excelbud .

SUMIF Function in Excel

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

August 16th in Functions by Excelbud .

HLOOKUP Function in Excel

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

August 13th in Basic Help by Excelbud .

Add Command to the Quick Access Toolbar in Excel

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

August 5th in Functions by Excelbud .

Concatenate Function

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.

July 22nd in Functions by Excelbud .

Excel VLOOKUP

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.

 Page 5 of 7  « First  ... « 3  4  5  6  7 »