Microsoft Excel allows you to crunch massive quantities of data easily through the use of functions. Sometimes you need to know the number of actual data points without counting blank cells.

The below example shows how to perform a similar, though not identical, cell match in Microsoft Excel without specifying the exact match string. A partial cell match means that the cell contains a ...

How to reference cells with the COUNTIF function in Excel Your email has been sent Use COUNTIF to count values in a range that meet a certain condition and return a specified number to the cell ...

Use INDEX and MATCH for simple database queries in Excel The bigger your spreadsheet, the more you need these, which you can combine with SUM, AVERAGE, and MAX to refine your searches.

How to Split the Number From the Street Address in Excel. Ideally, any Microsoft Excel spreadsheet that contains names and addresses breaks up each category of information into separate columns ...

The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

You may want to multiply cells or numbers in Microsoft Excel to analyze data. Here's what you need to know to do it.

Trying to make all of the text or words fit properly in your Excel spreadsheet? Learn how to make text fit in Excel with our tutorial.

Conditional formatting highlights key information in a spreadsheet so it’s easy to see at a glance. This beginner’s guide gets you started using conditional formatting.

If you need to find the cube and cube root in Excel, please read through this article. We have shared the easiest methods.