Ravi Sir's Cards › Excel
School Fee Management System in Excel (card 1 of 2)
Revision card 1 for School Fee Management System in Excel: Net fee for the year: =F5-G5 gives ₹41,000; Total fee of the grade: =B8+C8 gives ₹27,000; Instalments due by the as-of date: =COUNTIF(Setup!$B$17:$B$20,"<="&Setup!$B$3) gives 3. Includes an example data table.
Read card text
What this card says
1 for School Fee Management System in Excel: Net fee for the year: =F5-G5 gives ₹41,000
Total fee of the grade: =B8+C8 gives ₹27,000
Instalments due by the as-of date: =COUNTIF(Setup!$B$17:$B$20,"<="&Setup!$B$3) gives 3. Includes an
Example
data table
Learn this in the lesson: School Fee Management System in Excel: Fee Structure, Instalments, Overdue List, Receipts and Dashboard