In my previous role as an MIS Executive at VectraDigi Technologies, I encountered a situation where I needed to automate the generation of weekly sales reports. The process was initially manual, involving repetitive data entry and formatting tasks, which was time-consuming and prone to errors. To streamline this, I utilized advanced Excel features such as pivot tables and macros. I created a macro that automatically pulled data from various sheets, consolidated it, and updated the pivot tables to reflect the latest figures. Additionally, I used Google Apps Script to automate the emailing of these reports to the relevant stakeholders every Monday morning. This automation not only saved significant time but also improved the accuracy and consistency of our reporting process.