Merge Cells in Excel
Merging cells in an Excel spreadsheet is extremely useful. By merging cells, you can greatly enhance the look and feel of a spreadsheet.
The following example will demonstrate to use this feature.
Check boxes in Excel
Quick Overview
Unknown to many excel users, you can easily set up check boxes in Excel. You can use these check boxes to total a list of data by selecting various boxes.
The following Excelbuddy.com video demonstrates what this tutorial will accomplish.
The following tutorial will show you how to accomplish this task by creating an auto-totaling grocery list.
Hide Columns in Excel
Quick Overview
The Hide Column feature in Excel is a very easy to use and handy trick. From a personal standpoint, I find myself hiding columns quite frequency in order to clean up the spreadsheet.
AutoSum function in Excel
Quick Overview
The AutoSum Function is by far one of the most useful features in all of Excel. Just about every spreadsheet can benefit from incorporating the AutoSum function.
Lets Begin
To begin, let’s start with a list of data we are looking to sum.
[Read the rest of this entry...]
SUMIF Function in Excel
The SUMIF function adds cells specified in range by a certain condition or criteria.
The Syntax for SumIF Function:
=sumif(range,criteria,[sum_range])
Range: A range is a range of cells you want to apply a specific criteria against.
Criteria: The criteria determines which cells to add.
Sum_range: Cells to sum.
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.
Add Command to the Quick Access Toolbar in Excel
Adding a command to the Quick Access Toolbar is quite easy in Microsoft Excel 2007.
- Click the arrow to the right of the “Quick Access Toolbar” and then click “More Commands” as shown below.
[Read the rest of this entry...]
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.
The example is this tutorial will demonstrate how to combine an area code in column “A” with a phone number in column “B.” We will also be including the dash mark [Read the rest of this entry...]
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.
COUNTIF Function – Cell Counting Tips
There are various methods used to count cells in Excel. We will be utilizing the COUNT function.
- The COUNTIF function is used to count cells in a range given a certain criteria.
The examples listed below show how to properly use the COUNT function in Excel. In every example, the data range that will need to be changed is titled “range.”