Check Student Result
| S.no | Code | Conduction Date | Name | Course Name | Marks | Test Type | Total | Obtained | Admission Date | Date Of Birth | Father's Name | Date Of Joining | Subject | Fees |
|---|
Downloads – Important Information
Click on the links below to access important study materials, shortcut lists, and financial documents provided by BPA Educators.
Budget 2023 Highlights
DownloadImportant Tally Shortcuts
DownloadTally Ledger List
DownloadImportant Access Shortcuts
DownloadIncome Tax Calculator (FY 2021-22)
DownloadImportant MS Word Shortcuts
DownloadTDS Chart Rate (FY 2022-23)
DownloadImportant Busy Shortcuts
DownloadGoogle Drive Shortcuts
DownloadImportant Excel Shortcuts
DownloadCompliance Calendar (FY 2022-23)
DownloadIncome Tax Calculator (FY 2022-23)
DownloadToday's Birthdays
Activities Of the Month
Activities Marks
Batch Launches
Exam Records
Student Placements
Certificates Issued
Excel & Financial Formulas — BPA Educators
A structured, learning-wise list of all important Excel formulas with structure and explanation — categorized for easy reference and practical learning.
Basic Formulas
| Formula | Structure | Explanation |
|---|---|---|
| AVERAGE | =AVERAGE(A2:A10) | Returns the average (mean) of values in the given range. |
| COUNT | =COUNT(A2:A10) | Counts the number of numeric entries in the selected range. |
| MAX | =MAX(A2:A10) | Finds the largest value in the selected range. |
| MEDIAN | =MEDIAN(A2:A10) | Returns the middle value in an ordered range of numbers. |
| MIN | =MIN(A2:A10) | Finds the smallest value in the selected range. |
| SUM | =SUM(A2:A10) | Adds all numeric values in the specified range. |
💡 Tip: Ensure that your selected range contains only numbers; text entries are ignored by these formulas.
Time Formulas
| Formula | Structure | Explanation |
|---|---|---|
| TODAY | =TODAY() | Returns the current date; updates automatically each day. |
| NOW | =NOW() | Returns the current date and time; volatile function. |
| DATEDIF | =DATEDIF(StartDate,EndDate,"Y|M|D") | Finds the difference between two dates in years, months, or days. |
| YEAR | =YEAR(Date) | Extracts the year from a date value. |
| MONTH | =MONTH(Date) | Extracts the month from a date value. |
| DAY | =DAY(Date) | Extracts the day portion of a date. |
🕒 Tip: Change cell format to “Date” or “Number” if results appear incorrect.
Logical Formulas
| Formula | Structure | Explanation |
|---|---|---|
| IF | =IF(LogicalTest, ValueIfTrue, ValueIfFalse) | Tests a condition; returns one value for TRUE and another for FALSE. |
| OR | =OR(Test1, Test2, ...) | Returns TRUE if any condition is TRUE. |
| AND | =AND(Test1, Test2, ...) | Returns TRUE only if all test conditions are TRUE. |
💡 Tip: Combine IF with AND or OR for complex logical testing, e.g., =IF(AND(A1>10,B1<50),"OK","Check").
Lookup Formulas
| Formula | Structure | Explanation |
|---|---|---|
| VLOOKUP | =VLOOKUP(LookupValue, TableArray, ColIndex, RangeLookup) | Looks for a value vertically in a table and returns data from a specified column. |
🔍 Tip: Always use FALSE for exact matches. Lock your range using $ (e.g., $A$2:$C$50) when copying.
Financial Formulas
| Formula | Structure | Explanation |
|---|---|---|
| PMT | =PMT(rate, nper, pv, [fv], [type]) | Calculates periodic loan payment. Rate = interest per period, nper = periods, pv = present value (loan). |
💰 Tip: Divide annual rate by 12 for monthly payments. Negative PMT indicates outgoing cash flow.
Statistical Formulas
| Formula | Structure | Explanation |
|---|---|---|
| SUMIF | =SUMIF(range, criteria, [sum_range]) | Sums values meeting a single condition. |
| SUMIFS | =SUMIFS(sum_range, criteria_range1, criteria1, ...) | Sums values meeting multiple AND-based conditions. |
| COUNTIF | =COUNTIF(range, criteria) | Counts the number of cells matching a condition. |
| COUNTIFS | =COUNTIFS(range1,criteria1,range2,criteria2,...) | Counts cells satisfying multiple conditions simultaneously. |
| AVERAGEIF | =AVERAGEIF(range, criteria, [average_range]) | Finds the average of cells meeting a condition. |
| AVERAGEIFS | =AVERAGEIFS(average_range, criteria_range1, criteria1, ...) | Finds average for data meeting multiple criteria. |
📊 Tip: Use quotes for criteria, e.g., ">100" or "*Apple*" when matching text or ranges.
