In my previous role, I encountered a situation where we had to generate weekly sales reports manually, which was time-consuming and prone to errors. To streamline this process, I utilized Microsoft Excel's advanced features. I created a template with embedded formulas and pivot tables to automatically update and organize the data. Additionally, I used Google Apps Script to automate the data extraction from our internal database, which was then fed into the Excel template. This automation reduced the time spent on report generation by 50% and significantly improved accuracy, allowing the team to focus more on analysis and decision-making.