Download a free Patient Registration Excel Sheet Template to easily record and manage patient registration details. This ready-to-use Excel template helps hospitals, clinics, and healthcare centers organize patient names, contact details, registration dates, patient IDs, doctor information, and other essential records in a simple and structured format.
Key Features :
- S.No.
- Registration ID
- Registration Date
- Patient Name
- Gender
- Date of Birth
- Age
- Mobile Number
- Blood Group
- Address
- City
- Emergency Contact
- Visit Type
- Department
- Doctor
- Registration Status
- Remarks
- Dashboard
- KPI Card
- Pie Chart
- Bar Chart
Formulas :
Age
=IF(F7=””,””,DATEDIF(F7,TODAY(),”Y”))
Other Gender =COUNTIF(‘Patient Registration’!E5:E1000,”Other”)
New Visits =COUNTIF(‘Patient Registration’!M5:M1000,”New”)
Follow-up Visits =COUNTIF(‘Patient Registration’!M5:M1000,”Follow-up”)
Emergency Visits =COUNTIF(‘Patient Registration’!M5:M1000,”Emergency”)
Active Registrations =COUNTIF(‘Patient Registration’!P5:P1000,”Active”)
Pending Registrations =COUNTIF(‘Patient Registration’!P5:P1000,”Pending”)
Orthopedics =COUNTIF(‘Patient Registration’!N5:N1000,D6)
Dermatology =COUNTIF(‘Patient Registration’!N5:N1000,D7)
Pediatrics =COUNTIF(‘Patient Registration’!N5:N1000,D8)
Gynecology =COUNTIF(‘Patient Registration’!N5:N1000,D9)
ENT =COUNTIF(‘Patient Registration’!N5:N1000,D10)
Neurology =COUNTIF(‘Patient Registration’!N5:N1000,D11)
Other =COUNTIF(‘Patient Registration’!N5:N1000,D12)
