If your business uses spreadsheets, you may find it necessary to count the number of cells containing data in a worksheet. You might also need to determine how many cells are empty or if the values of ...

Microsoft Excel 2003 is a powerful tool that business owners can use to craft presentations for clients, employees and business partners. The program allows you to take a large amount of data and use ...

Harness the power of Subtotal in Excel to count grouped items Your email has been sent Excel's Subtotal feature can render quick results when you need simple grouping calculations. Susan Harkins shows ...

The asterisk (*) is the wildcard character that represents any sequence of characters, including when there are no characters at all. It’s the most flexible of the bunch, since it can replace any ...

If you have a spreadsheet containing the stocks in a shop or something similar, and you need to count the comma-separated values in a single cell, here is how you can get the job done. There is a ...

Have you ever stared at a PivotTable, wondering how to extract deeper insights without endlessly tweaking your source data? PivotTables are incredibly powerful tools, but sometimes the default options ...

Q. Is there a quick way in Excel to calculate the number of business days in a particular period? For example, a CPA preparing payroll may need to determine how many business days he or she has to ...

Use Excel data validation to prevent duplicate values in a column Your email has been sent Prevent duplicates before they happen by combining a simple function with data validation. Excel has built-in ...