I’m starting a series on dashboards because I think creating sexy dashboards is a critical skill every marketer needs to know. It’s going to be a long series — but by the time we’re finished, you’ll ...

The PMT function is an Excel Financial function that returns the periodic payment for an annuity. The formula for the PMT function is PMT(rate,nper,pv, [fv], [type]). The NPV function returns the net ...

This article will be handy if you want to rename or edit the data series name in a Microsoft Excel graph or chart without changing the row or column name. The data series is the data that appears at ...

Functions are the driving force of any Microsoft Excel spreadsheet, generating a single value or an array of results based on certain arguments you input. However, combining—or nesting—functions ...