01 Advance Excel - Attendance Sheet

   टीप : Smart-phone मध्ये  screen Rotate केल्यास file accurate दिसेल.

Advance Excel-Excel-2013 

This Topic

Attendance Sheet

Guide (Location Path to apply format) 

 Line = View -- > show -- >griddles

 Date = Home -- >Fill -- > Series -- > ( step value (1) ( stop value (31)

 Colum size = ( all select row 1 to 31) format --- >Colum width -- >size = (2) ok

Format

Sr.no   |  Student Name 1,2,3, to 31   |   Total (P)   |    Total (A)   |      Percentage

Formula

 Total “P” = Countif(select all row 1 to 31,”p”) Enter

 Total “A” = Countif(select all row 1 to 31,”A”) Enter

 Percentage = Total P /27*100