The COLUMN function returns the column number of the given cell reference. For example, the formula =COLUMN (D10) returns 4, because column D is the fourth column.

In Excel, you can format numbers in cells for things like currency, percentages, decimals, dates, phone numbers, or social security numbers.

Learn how to use the percentage formula in Excel to find the percentage of a total and the percentage of change between two numbers. Try it now!

Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter.

Find Microsoft Excel help and learning resources. Explore how-to articles, guides, training videos, and tips to efficiently use Excel.

Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers. For example, you can enter the following formula to count the numbers in the …

How to use the MATCH function in Excel to search for a specified item in a range of cells, returning the relative position of that item in the range.

Look up data in Excel to find data in a list and verify that it's correct. Then, perform calculations or display results with the values returned. Use the VLOOKUP, HLOOKUP, INDEX, MATCH, and …

If you want to include logical values and text representations of numbers in a reference as part of the calculation, use the AVERAGEA function. If you want to calculate the average of only the …

Excel for the web offers access keys, keyboard shortcuts to navigate the ribbon. If you've used access keys to save time on Excel for desktop computers, you'll find access keys very similar …