Developed an Excel dashboard for tracking sales orders, organizing order data, monitoring order status, and analyzing requested quantities. The project included data organization, filters, KPI summaries, and visual charts to improve data comprehension and support informed decision-making.

Accounts Payable (AP) Invoice Automation:

The project automates the Accounts Payable process by consolidating separate financial data files.

Using Excel’s VLOOKUP function, it links a central summary sheet (AP_Summary.xlsx) with two source workbooks to automatically fill in missing information. It reads the Vendor ID to pull the matching company name from Vendor_Master.xlsx. It reads the Invoice Number to pull the correct billing total from Invoice_Register.xlsx. This process eliminates manual cross-referencing, cuts down on data entry errors, and instantly creates a unified financial dashboard for efficient invoice tracking and accurate bookkeeping.