In your school life, you have learned about average and the method to calculate it. The formula to calculate the average is very simple. You just have to add all the values in the given data and ...

As a child of the dark ages, I used the word rank to describe something that smelled rotten or suspicious. Rank in Microsoft Excel is, thankfully, totally different. In Excel, rank is a value that ...

All of you have learned the formula to calculate the compound interest in your school. Compound and simple interests are among the mathematical applications used in real life for years. At certain ...

Profit margin is one of the simplest and most widely used financial ratios in corporate finance. A company’s profit is ...

Not everyone is an Excel spreadsheet expert and you may not always know how to write the formulas you need for a given data set. If you're having trouble figuring out the right formula for your data ...

Learn how to unlock Excel’s hidden features with GROUPBY and create visually compelling, accurate reports like never before.

Fix Excel’s alphabetical month sorting issue with simple tricks. Learn how to group months chronologically using XMATCH and CHOOSECOLS.

Using Excel’s PivotTables and PivotCharts, you can quickly analyze large data sets, summarize key data, and present it in easy-to-read format. Here’s how to get started with these powerful tools.

Excel provides three functions for generating random values: RAND(), RANDARRAY(), and RANDBETWEEN(), but there’s no comparable function for generating random letters. The truth is, most of won’t need ...

How to calculate your spam index, 07/19/07: We recently wrote about some research that Peter Brockmann had done concerning spam and productivity. We invited Peter to share a few insights from the ...