Ravi Sir's Cards › Excel
Travel Agency Management System in Excel (card 1 of 2)
Revision card 1 for Travel Agency Management System in Excel: Margin per adult: =D9-C9 gives ₹4,500; Booking ID: ="TR-"&TEXT(ROW()-4,"000") gives TR-001; GST: =ROUND(H5*Setup!$B$4,0) gives ₹3,063. Includes an example data table.
Read card text
What this card says
1 for Travel Agency Management System in Excel: Margin per adult: =D9-C9 gives ₹4,500
Booking ID: ="TR-"&TEXT(ROW()-4,"000") gives TR-001
GST: =ROUND(H5*Setup!$B$4,0) gives ₹3,063. Includes an
Example
data table
Learn this in the lesson: Travel Agency Management System in Excel: Tour Packages, Bookings, Payments, Balance Due and Dashboard