Ravi Sir's Cards › Excel
Photography Studio Management System in Excel (card 1 of 2)
Revision card 1 for Photography Studio Management System in Excel: Total: =J5+K5 gives ₹97,940; Booking ID: ="PS-"&TEXT(ROW()-4,"000") gives PS-001; GST: =ROUND(J5*Setup!$B$4,0) gives ₹14,940. Includes an example data table.
Read card text
What this card says
1 for Photography Studio Management System in Excel: Total: =J5+K5 gives ₹97,940
Booking ID: ="PS-"&TEXT(ROW()-4,"000") gives PS-001
GST: =ROUND(J5*Setup!$B$4,0) gives ₹14,940. Includes an
Example
data table
Learn this in the lesson: Photography Studio Management System in Excel: Packages, Bookings, Date Clash Check, Delivery Tracking and Dashboard