Completed: 2024-10-15
Developed a dynamic Excel report that retrieves order and product details based on a selected Order ID. Utilized advanced Excel functions such as VLOOKUP, XLOOKUP, and FILTER to create a user-friendly interface. Incorporated conditional formatting to visually differentiate profit margins, enhancing the report's usability. Worked with a comprehensive dataset of over 9,000 rows, demonstrating data handling capabilities. Enabled seamless user interaction through a dropdown selection for Order IDs, updating the report dynamically.
Keywords: Xlookup,Vlookup,Filter,Dropdown,Excel,Reports
Technology: Excel