This is a component of my Master Capstone project in which I use VBA and advanced Excel skills to create a functional application that solves real-world business problem: managing food orders.
Dashboard Usage and Main Functions
-
Take orders from customers.
-
Keep track of daily tasks via a simple to-do list.
-
Have an aggregated number of orders and special requests by meal, automatically updated everyday.
Tools
I used VBA to create an userform to automatically transfer order data to a dedicated database. Then data is used to generate pivot tables and charts. Finally I put everything together in 2 user interfaces, one for receptionist and one for the kitchen. I also used VBA to write smaller plugins such as to-do list, progress tracker and real-time count down clock.
Final Results
