Ravi Sir's Cards › Excel
Beauty Parlour Management System in Excel (card 2 of 2)
Revision card 2 for Beauty Parlour Management System in Excel: Expiry date: =F5+G5 gives 30-11-2026; Product used by services: =SUMIFS(Sessions!$J$5:$J$1000,Sessions!$I$5:$I$1000,A5) gives 7.00; Closing stock: =E5-G5 gives 7.00. Includes an example data table.

Read card text
What this card says
2 for Beauty Parlour Management System in Excel: Expiry date: =F5+G5 gives 30-11-2026
Product used by services: =SUMIFS(Sessions!$J$5:$J$1000,Sessions!$I$5:$I$1000,A5) gives 7.00
Closing stock: =E5-G5 gives 7.00. Includes an
Example
data table
Learn this in the lesson: Beauty Parlour Management System in Excel: Packages, Sessions, Product Stock, Staff Incentive and Bills