Every Friday it was the exact same thing. Log into DTMS, gather the data, redo calculations, and then plug answers into PowerPoint slides for the next Training Meeting. Initially this would take me around 2 hours to do, but eventually I got it down to 1 hour. What if I told you that you could do this in 5 min? Not only that, you could take the same information and with a couple clicks format it to your Company Training Meeting. Your saving grace is the PIVOT table.
PIVOT Tables are a tool in Excel that allow you to quickly analyze your data sets and make decisions off of them. I've included a YouTube example video (see below) working with weapons qualification data from DTMS. What I love most about PIVOT Tables are that once you make a PIVOT Table, you can can updated reports simply by pasting in new sets of raw data. Essentially all you have to do is set up your metrics once and you will always have your results at the push of a button. This will save Commanders/Staff Members/ Training rooms ridiculous amounts of time, allow you to streamline processes, and free up time to focus on more important things..
For more information, here's a link to a quick and easy tutorial: http://www.excel-easy.com/data-analysis/pivot-tables.html . If you've signed up for Lynda, I highly recommend taking their PIVOT Table courses. They will expand your skills so much more.
If you have thoughts on the article you just read, please leave some comments for the group. If you’d like to continue following this blog, sign up for our newsletter or add our RSS Feed to your Feedly account to know when new content is posted .