Monday, May 27, 2019

Convert Time in Excel (Days to Hours, Hours to Minutes, etc)

Have you ever wanted to convert time into something more useful?  No this is not a way to make you bend the space time continuum or turn you into some Einstein.  However if you've got some start and end times and wanted to do some comparison of days, weeks or even years, there is a function in Excel called CONVERT that will help you out a lot.  After learning this, you'll almost feel like you could bend time or maybe just have some kind of super power (at least in Excel).  Check out the video to learn it.

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.