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.


Wednesday, May 15, 2019

Use the SEARCH Function

If you're looking for some text string or other values within a cell you can use the Find feature in Excel. But what if you wanted to do this programatically and have it execute for every row without manual interventions. It can be done with a built in function called SEARCH...see the video to learn how to use the SEARCH function in Excel.