OM Logistics Limited

This is to certify that the participant has successfully completed the Advanced Excel & Power Query Training, demonstrating proficiency in advanced data analysis, automation, and reporting techniques.

During this training, the participant gained expertise in advanced Excel functions, including XLOOKUP, INDEX-MATCH, SUMIFS, array formulas, and dynamic named ranges, along with the effective use of Pivot Tables, Power Pivot, and Macros to enhance data processing and reporting capabilities. Additionally, the participant mastered Power Query, learning how to efficiently clean, transform, and automate data imports from multiple sources to streamline workflows.

The training also covered data visualization techniques, enabling the participant to create insightful and interactive dashboards using charts, slicers, and Power Pivot measures. Best practices for data management, error handling, and automation were emphasized to ensure efficiency and accuracy in data-driven decision-making.

With these advanced skills, the participant is now equipped to handle complex datasets, optimize reporting processes, and leverage automation tools to enhance business intelligence, ultimately contributing to improved productivity and strategic decision-making.