Cumulative preferred stocks ensure skipped dividends are paid before common dividends. Calculate owed dividends by annual rate x par value, divided by quarters, multiplied by missed payments. In ...

As a spreadsheet software program, Microsoft Excel has many useful features for a small business's productivity. Chief among these is the ability to use formulas to make various calculations with the ...

If you are using Microsoft Excel to manage numerical data, at some point you're inevitably going to display percentages. Doing so can give you a new insight, or make summarizing heaps of data a bit ...

When you're working with a spreadsheet, duplicate data can sometimes make its way in and cause all sorts of problems. In this how-to, we demonstrate two methods of using Microsoft Excel for ...

Variance is a useful analytical tool when it comes to measuring data, and helps you to calculate the range of numbers in a set of data. This is handy for a multitude of reasons, from calculating ...

Are you wondering how to calculate z-score in Excel? If so, you’ve landed on the right page. In statistics, a z-score tells us how far a data point is from the mean. While Excel still doesn't have an ...

If you’ve been combining multiple data sources, you can quickly end up with duplicate rows or cells in Excel. Whether it’s due to an accidental copy and paste or a typing error, this can be ...

It can be beneficial in many situations to display the difference between two numbers as a percentage. Doing so helps to put a change into a more understandable format for the average reader. In this ...