Wednesday, May 22, 2019
Create a Basic Burndown Chart in Excel
How to create a basic burndown chart. Popular in Agile development, the burndown chart may also be considered a project management tool to see if a set of tasks are completed ahead of or behind schedule.
Tuesday, May 21, 2019
Create a Basic RACI Chart
If you've done project management you're probably familiar with the term RACI chart. It is also known as a Responsibility Assignment Matrix or RACI matrix. It's used to track roles and responsibilities in projects. It's quite useful as a communications tool to let people on your project team know who is doing what and who should be informed. And it's fairly easy to create in Excel, so check out the video to learn how.
Monday, May 20, 2019
Calculate Compound Interest
Did you know you can use Excel to figure out how much something is going to cost or how much money you'll get in the future assuming some fixed interest rate? It's call Future Value and this term is often used in business as well as personal finance. See this video to learn about using Excel to calculate compound interest with the Future Value (FV) formula and Excel's built in FV function.
Subscribe to:
Posts (Atom)