Client had scattered customer data from emails and needed a central order management sheet.
I built this Customer Database with Customer Name, Email, Phone, Order ID, Amount, Date and Payment Status with color-coded labels - Paid (Green), Pending (Orange), Refunded (Red).
Real estate agency needed 500+ property listings cleaned and entered into Excel for their website upload.
I organized Property ID, Address, City, Price, Bed/Bath and Status. Applied currency formatting and created filters for Available / Pending / Sold status to make searching easy.
I created this Inventory Stock Management Excel sheet with Item Code, Supplier, Quantity, Unit Cost, Total Value (with formula =Quantity*Unit Cost) and Status with conditional formatting for In Stock / Low Stock / Reorder.
I created a clean Excel sheet with Product Name, SKU, Price, Category, Stock and Status. Applied conditional formatting for Low Stock and removed all duplicates.