Ravi Sir's Cards › Excel
Beauty Parlour Management System in Excel (card 1 of 2)
Revision card 1 for Beauty Parlour Management System in Excel: Bill number: ="B-"&TEXT(ROW()-4,"000") gives B-001; Package sessions in the log: =COUNTIF(Sessions!$F$5:$F$1000,A5) gives 3; Sessions remaining: =D5-H5-I5 gives 1. Includes an example data table.
Read card text
What this card says
1 for Beauty Parlour Management System in Excel: Bill number: ="B-"&TEXT(ROW()-4,"000") gives B-001
Package sessions in the log: =COUNTIF(Sessions!$F$5:$F$1000,A5) gives 3
Sessions remaining: =D5-H5-I5 gives 1. Includes an
Example
data table
Learn this in the lesson: Beauty Parlour Management System in Excel: Packages, Sessions, Product Stock, Staff Incentive and Bills