I used knime to automate the process of generating reports for the team, this automation assign the new data to the correct team member, track the status of each invoice and send the report by email.
I develop a excel macro to extract meaningful data from a large data set, this macro was used to extract data from a 5000+ rows and 40+ columns data set. The objective was just take the data that was needed.