Lesson: Admission Fee in Microsoft Excel

1. Introduction

Admission Fee is one of the components used in the Course Fee calculation.

In an Excel fee sheet, admission fee can be entered separately from other charges such as course fee, prospectus fee and examination fee. These amounts can then be combined to calculate the total fee payable.

Your provided Advanced Excel notes include Admission Fee as part of the course-fee calculation practical.

2. What is Admission Fee?

Admission Fee is a fee amount included in the fee structure at the time of admission.

In an Excel fee sheet, it can be maintained as a separate item so that the complete fee structure is clear.

Simple Definition

Admission Fee is a separate fee component recorded in the course fee sheet as part of the total payable amount.

3. Example of Admission Fee

Suppose a student’s fee structure is:

Here:

Course Fee        = ₹20,000
Admission Fee     = ₹1,000
Prospectus Fee    = ₹200
Examination Fee   = ₹800

All these amounts can be included in the total fee calculation.

4. Admission Fee in Excel

Suppose the fee details are entered like this:

The Admission Fee is stored in:

B3

5. Calculating Total Fee

The admission fee can be included along with the other charges.

Using SUM Function

=SUM(B2:B5)

This adds:

Course Fee
+ Admission Fee
+ Prospectus Fee
+ Examination Fee

Result

₹20,000
+ ₹1,000
+ ₹200
+ ₹800
──────────
₹22,000

The provided notes cover the use of SUM for calculating course-fee totals.

6. Direct Addition Formula

Instead of using SUM, the individual cells can also be added directly.

=B2+B3+B4+B5

Here:

B2 → Course Fee
B3 → Admission Fee
B4 → Prospectus Fee
B5 → Examination Fee

Both approaches can be used to calculate the total.

7. Admission Fee — Practical Flow

Enter Course Fee
       ↓
Enter Admission Fee
       ↓
Enter Prospectus Fee
       ↓
Enter Examination Fee
       ↓
Calculate Total
       ↓
=SUM(B2:B5)
       ↓
Total Course Fee

8. Why Keep Admission Fee Separate?

Keeping Admission Fee as a separate entry makes the fee sheet easier to understand.

For example:

Course Fee       ₹20,000
Admission Fee     ₹1,000
Prospectus Fee      ₹200
Exam Fee            ₹800
                 ───────
Total             ₹22,000

Instead of entering only ₹22,000, each component of the total is clearly visible.

9. Admission Fee and Other Charges

Admission Fee is only one component of the overall fee calculation.

┌─────────────────────────────┐
│       COURSE FEE SHEET      │
├─────────────────────────────┤
│ Course Fee                  │
│ Admission Fee               │
│ Prospectus Fee              │
│ Examination Fee             │
│ Tax                         │
│ Discount                    │
├─────────────────────────────┤
│ Final Payable Amount        │
└─────────────────────────────┘

The exact combination of charges depends on the fee structure being prepared.

10. Important Excel Formulas

Total including Admission Fee

=SUM(B2:B5)

Direct Addition

=B2+B3+B4+B5

Admission Fee Cell Reference

=B3

Here B3 refers to the cell containing the Admission Fee.

11. Quick Revision Table

⭐ Easy Memory Trick

COURSE FEE
     +
ADMISSION FEE
     +
PROSPECTUS FEE
     +
EXAMINATION FEE
     ↓
TOTAL FEE

One-Line Definition

Admission Fee is a separate fee component entered in the Excel fee sheet and included when calculating the total course fee.