Tuesday, May 28, 2019

Use VLOOKUP to Find the 2nd Match (or nth Match)

If you are familiar with the VLOOKUP function it's a great tool to lookup values in a range or table. However it will only bring back the first instance of the looked up value. What if you wanted the second instance of the value or even have all the instances of the value brought back? This could be done by using a helper column and the COUNTIF function. Watch the video to see how it's done!

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.