Summary of What I Did

• Data validation to ensure correct data formats (e.g., dates, phone numbers)
• Dropdown for Item(s) Purchased and Payment Method to standardize entries
• VLOOKUP for the Price of the Item(s) Purchased 
• Conditional formatting to see who the customers are purchasing more than P30,000.00
• PRODUCT for Total Amount of Item(s) Purchased times Quantity
• Sorting of Customer Names in Alphabetical Order
• Wrapping text to make the entries readable
• Protected ranges to safeguard formulas while keeping data entry frictionless
• Clean currency formatting throughout for readability
• Use of Filter to allow easy searching and filtering of the data