Q. I was excited to see the article about ways to calculate depreciation in Excel, especially when I saw one of them was double-declining balance (DDB). As tax professionals, we’re always trying to ...

To calculate letter grades based on a percentage score, you can use multiple nested IF statements in Excel, which can get rather complicated quickly. However, there is an easier way. Added by ...

If you track your daily earnings using an Excel spreadsheet, you can use the same spreadsheet to estimate your projected earnings over any time period. Using Excel's "AVERAGE" function, you can ...

A straight ranking result is easy using one of Microsoft Excel’s ranking functions. Calculating a conditional rank is even easier if you let an Excel PivotTable do all the work. Image: ...

Daniel Jassy, CFA, is an Investopedia Academy instructor and the founder of SPYderCRusher Research. He contributes to Excel and Algorithmic Trading. Robert Kelly is managing director of XTS Energy LLC ...