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 interpret the parts of complex formulas. Microsoft ...

Numbers affect your business's success, and Excel helps you manage your numbers. Whether your spreadsheets contain sales figures or employee names, you may need to need to count values in a ...

You can split cells into columns in Excel using the "Text to Columns" tool. Excel gives you two ways to split cells into columns: using delimiters, or using a manual fixed width. Splitting cells into ...

Drop-down lists in Microsoft Excel (and Word and Access) allow you to create a list of valid choices that you or others can select for a given field. This is especially useful for fields that require ...

Design is best, but when you're stuck with an existing data structure, it helps to know how to work around trouble. Susan Harkins explains. Excel sheets grow — sometimes by adding new functionality, ...