When working with Excel, we use 1 to signify that we are on the first sheet, unlike arrays where they are zero-indexed. We will begin searching for our data -- in this case, it is "Nebraska" -- using ...

Learn how to define, use & delete names in Excel formulas. It becomes easier to identify & comprehend data when you can add Names to it.

Microsoft Excel’s Name box is a powerful tool for its size. Use it to move around, create range names and even enter functions.

Learn how to change, edit or rename a Data Series name in Microsoft Excel Graph or Chart without editing the original row or column name.

How to Find Cells With Strikethrough in Excel. For a business leader, Microsoft Excel 2010 can be an invaluable tool for monitoring inventory, recording customer information or keeping track of ...

How can we find duplicate values across multiple columns? For this task, we’ll use two Excel helper formulas: One to concatenate the columns you’re comparing; a second to count the duplicates.

How to Give a Name to the Columns in Excel. The default method for including a column reference in an Excel formula is to use the column letter, a convention that may make it difficult to ...