Ravi Sir's Cards › Excel
Travel Agency Management System in Excel (card 2 of 2)
Revision card 2 for Travel Agency Management System in Excel: Margin per package: =D5-E5 gives ₹38,250; Paid so far: =SUMIFS(Payments!$C$5:$C$2000,Payments!$B$5:$B$2000,A5) gives ₹64,313; Days to travel: =G5-Setup!$B$3 gives 5.
Read card text
What this card says
2 for Travel Agency Management System in Excel: Margin per package: =D5-E5 gives ₹38,250
Paid so far: =SUMIFS(Payments!$C$5:$C$2000,Payments!$B$5:$B$2000,A5) gives ₹64,313
Days to travel: =G5-Setup!$B$3 gives 5.
Learn this in the lesson: Travel Agency Management System in Excel: Tour Packages, Bookings, Payments, Balance Due and Dashboard