Excel's AGGREGATE function lets you perform calculations whilst ignoring hidden rows, errors, or other functions that appear in the data. It's similar to the SUBTOTAL function but provides more ...

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 ...

Finding the exact difference between two dates in Excel may not be the most used feature, but it can be a lot of fun. A classic example is working out someone’s age. It’s not as complicated as it ...

Later, we'll add an IF() function that returns a subtotal for each day. How to calculate conditional subtotals in an Excel revenue sheet Your email has been sent Adding a condition to a simple revenue ...

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 ...

To calculate the Consumer Price Index between two years in Excel, take a sum of all the amounts spent on the basket of products over those two years. Then use the following formula to find the CPI ...