In my previous role as a Data Quality Coordinator, I extensively used Microsoft Excel's advanced functions to streamline our data reporting processes. For instance, I utilized PivotTables to analyze large datasets efficiently. By organizing data into meaningful summaries, I was able to track key metrics such as the frequency of data discrepancies and their resolution timelines. This helped in identifying patterns and areas that required attention, ultimately improving our data quality. Additionally, I leveraged Power Query to automate data cleaning tasks. This involved transforming raw data into a structured format, which significantly reduced manual effort and ensured consistency in our reports. These tools not only optimized our reporting process but also enhanced our decision-making capabilities by providing accurate and timely insights.