Ravi Sir's Cards › Excel
Catering Management System in Excel (card 1 of 2)
Revision card 1 for Catering Management System in Excel: Event amount: =G5*H5+I5 gives ₹42,000; Event ID: ="EV-"&TEXT(ROW()-4,"000") gives EV-001; GST: =ROUND(J5*Setup!$B$4,0) gives ₹2,100. Includes an example data table.
Read card text
What this card says
1 for Catering Management System in Excel: Event amount: =G5*H5+I5 gives ₹42,000
Event ID: ="EV-"&TEXT(ROW()-4,"000") gives EV-001
GST: =ROUND(J5*Setup!$B$4,0) gives ₹2,100. Includes an
Example
data table
Learn this in the lesson: Catering Management System in Excel: Packages, Events, Payments, Kitchen Quantities, Margin and Dashboard