When you type a seven-or-ten-digit phone number into an Excel cell that uses the phone number format, Excel will automatically change the way the number looks so that it appears as a phone number. If ...

Functions are the driving force of any Microsoft Excel spreadsheet, generating a single value or an array of results based on certain arguments you input. However, combining—or nesting—functions ...

Most of us know how to create a chart in Excel, but it’s the chart with a little something extra that often does the best job. For instance, suppose you’re charting product favorites by age group and ...

Excel's VALUE function has only one argument: where a is the value stored as text that you want to convert into a number. This can be hard-coded inside double quotes or a reference to a cell ...

Use Excel’s Autofill to generate a series of dates Your email has been sent Microsoft Excel 2002 and 2003’s Smart Tag feature makes it easy to insert a series of dates into a worksheet. For example, ...

Excel's IF function validates a cell's contents, determining whether it meets criteria that you set. It provides no information beyond what your workbook already contains, but it analyzes the data ...

This article will be handy if you want to rename or edit the data series name in a Microsoft Excel graph or chart without changing the row or column name. The data series is the data that appears at ...