The discussion of macros was one of the topics that caught my attention from this past week’s session. I like the idea of being able to have code in a task to repeat itself, without the extra repetitive work required. Macros have been a feature of excel that I have been needing to learn for years but have just not taken the time to fully understand them. In a few of my past roles, I have had to input repetitive data and/or information, into Excel, where the use of a macro would have been extremely beneficial. As useful as macro coding is, I have decided not to use it in this week’s assignment as I have still had trouble in understanding how to completely code it.
As I write this blog, I was reflecting on the previous class session and some of its information and how I can use it for work. Data merging is one that sticks out in my mind. As a quality engineer within the automotive supply chain, I deal with lots of supplier and their respective defects. The ability to have this data in a spreadsheet for each supplier and merge the data to be able to understand defect commonalities between each, could be highly useful and a huge time savings. I believe this will also allow my department to have better visibility of our suppliers.
Gregory's Look Into Analytics 