moneymattersbynktehri.in

Menu

🧮 Excel Formula Master Sheet – A Beginner-Friendly Guide to Learn Common Functions

Whether you’re a student, a teacher, or someone trying to master Excel for everyday work, this ready-made Excel Formula Master Sheet is designed to help you understand and practice basic yet powerful Excel formulas.

This article includes:

  • A downloadable Excel sheet
  • A detailed explanation of formulas
  • Tips for practical use

📥 To Download the Sample Excel Sheet click the link below :

👉 Link to download the Excel File

🧠 What’s Inside the Sheet?

This Excel sheet covers a wide variety of basic functions such as calculations, formatting, date/time formulas, conditional logic, and lookups. Here’s a
detailed table of the formulas used in the file:

📘 Excel Formula Master Table

S.No.

Topic

Formula
Used

Cell/Range

Purpose

1

Compound Interest

=B5*(1+B6/100)^B7

B8

Calculates compound interest.

2

Simple Interest

=B5*B6*B7/100

B10

Calculates simple interest.

3

Pass/Fail Check

=IF(B12>=51,”Pass”,”Fail”)

C12:C23

Displays “Pass” if
marks are 51+, otherwise “Fail”.

4

Lower Case

=LOWER(E3)

E3:E6

Converts text to lowercase.

5

Upper Case

=UPPER(F3)

F3:F6

Converts text to uppercase.

6

Proper Case

=PROPER(G3)

G3:G6

Capitalizes the first letter of
each word.

7

VLOOKUP

=VLOOKUP(F12,B12:C23,2,FALSE)

G12:G15

Searches for student names and
returns their result.

8

Current Date

=TODAY()

G18

Displays the current date.

9

Current Date & Time

=NOW()

G19

Shows current date and time
(auto-updating).

10

Count (Numeric Cells)

=COUNT(B12:B23)

B26

Counts only the numeric values in the marks column. 

11

CountA (Non-Blank)

=COUNTA(B12:B23)

B27

Counts all non-empty cells (including text or numbers).

12

Average Marks

=AVERAGE(B12:B23)

B29

Computes average of all student marks.

13

Highest Marks

=MAX(B12:B23)

B30

Finds the maximum score.

14

Minimum Marks

=MIN(B12:B23)

B31

Finds the lowest score.

15

Count Pass

=COUNTIF(C12:C23,”Pass”)

B32

Counts how many students passed.

16

Count Fail

=COUNTIF(C12:C23,”Fail”)

B33

Counts how many students failed.

17

Total Entries

=COUNTA(B12:B23)

B34

Total number of students/records.

 

 

🛠️ Bonus Features in the Sheet

  • ✅ Conditional formatting: Auto-highlighting of Pass and Fail results.
  • ✅ Easy-to-edit inputs for experimenting with different values.
  • ✅ Text transformation examples using LOWER, UPPER, and PROPER.

📌 How to Use This Sheet

  1. Download and open the Excel file.
  2. Review each formula using the Formula Table above.
  3. Try changing values to see how formulas respond.
  4. Use it as a reference sheet for your school, office, or online learning.

💬 Final Thoughts

This Excel Formula Master Sheet is a simple, practical tool to begin your journey into spreadsheets. Share it with students, coworkers, or anyone interested in learning Excel — and feel free to tweak and expand on it!

💡 Tip for Readers:

To try these formulas:

  1. Download the Excel file below.
  2. Review the sample data and modify the formulas as needed.
  3. Observe how results change automatically based on your inputs!

How to Display the Full File Path in Excel Using a Simple Formula

When working with multiple files on your computer, it often becomes difficult to remember where a particular Excel file is saved. Excel provides a very easy formula that instantly shows the complete file path, folder location, and sheet name.

✔️ Formula to Use

=CELL("filename")

📝 How to Insert the Formula Step-by-Step

  1. Click on any blank cell in your Excel sheet.
  2. Type the formula: 
    =CELL("filename")

    You can also type =CELL( and choose “filename” from the dropdown list that appears.

  3. Press Enter.
  4. Excel will immediately display the complete path where your current file is saved.

📁 What Information Does This Formula Show?

After pressing Enter, you will see something like:

C:\Users\YourName\Documents\Accounts\MyFile.xlsx]Sheet1

This displays:

  • Drive (C:)
  • Folders (Users → YourName → Documents → Accounts)
  • File Name (MyFile.xlsx)
  • Sheet Name (Sheet1)

💡 Why This Is Useful

  • Helps you quickly locate the exact folder where the file is stored.
  • Useful when working with many files saved in different locations.
  • Helpful for documentation, audits, or file management systems.
  • Ensures you always know the correct file location without searching manually.
    =========================================================================
💻 चाहे आप छात्र हों, शिक्षक हों या ऑफिस में Excel में काम करते हैं और इसे और अधिक सुविधाजनक, आसान व शीघ्रता से उपयोग करना चाहते हों, तो एक ही चाबी है : Excel Formula  – यह Excel Formula Master Sheet इसी उद्देश्य से तैयार की गयी है !  

यह पोस्ट एक रेडीमेड Excel शीट के बारे में है जिसकी सहायता से आपको आसान और प्रभावशाली Excel फॉर्मूले सीखने और अभ्यास करने में मदद मिलेगी।    

इस लेख में आपको मिलेगा:

✔️ डाउनलोड करने योग्य Excel फाइल
✔️ हर फॉर्मूले की विस्तृत जानकारी
✔️ रोज़मर्रा के कामों में इस्तेमाल के सुझाव

📥 Excel फ़ाइल डाउनलोड करने के लिए नीचे दिए गए लिंक पर क्लिक करें:

👉 Link to download the Excel File   

 

🧠 इस शीट में क्या है?

इस Excel शीट में कई मूलभूत उपयोगी फॉर्मूले शामिल हैं — जैसे गणना, फ़ॉर्मेटिंग, तारीख/समय से जुड़े फॉर्मूले, शर्तों पर आधारित निर्णय (IF), और वीलुकअप फंक्शन। 

📘 Excel Formula Master Table :

क्रम संख्या

विषय

फॉर्मूला

सेल/रेंज 

उद्देश्य

1

चक्रवृद्धि ब्याज

=B5*(1+B6/100)^B7

B8

चक्रवृद्धि ब्याज निकालना

2

साधारण ब्याज

=B5*B6*B7/100

B10

साधारण ब्याज निकालना

3

पास/फेल जांच

=IF(B12>=51,”Pass”,”Fail”)

C12:C23

51 या उससे अधिक होने पर “Pass”  दिखाना

4

लोअर केस

=LOWER(E3)

E3:E6

टेक्स्ट को छोटे अक्षरों में बदलना

5

अपर केस

=UPPER(F3)

F3:F6

टेक्स्ट को बड़े अक्षरों में बदलना

6

प्रॉपर केस

=PROPER(G3)

G3:G6

हर शब्द का पहला अक्षर कैपिटल करना

7

VLOOKUP

=VLOOKUP(F12,B12:C23,2,FALSE)

G12:G15

नाम से परिणाम निकालना

8

वर्तमान तिथि

=TODAY()

G18

आज की तारीख दिखाना

9

तिथि व समय

=NOW()

G19

वर्तमान तिथि और समय दिखाना

10

केवल संख्या गिनना

=COUNT(B12:B23)

B26

केवल अंकों की गिनती

11

गैर–खाली सेल गिनना

=COUNTA(B12:B23)

B27

जो भी सेल खाली नहीं हैं, उनकी गिनती

12

औसत अंक

=AVERAGE(B12:B23)

B29

सभी अंकों का औसत निकालना

13

अधिकतम अंक

=MAX(B12:B23)

B30

सबसे ज़्यादा अंक

14

न्यूनतम अंक

=MIN(B12:B23)

B31

सबसे कम अंक

15

पास की गिनती

=COUNTIF(C12:C23,”Pass”)

B32

कितने विद्यार्थी पास हुए

16

फेल की गिनती

=COUNTIF(C12:C23,”Fail”)

B33

कितने विद्यार्थी फेल हुए

17

कुल प्रविष्टियाँ

=COUNTA(B12:B23)

B34

कुल रिकॉर्ड/विद्यार्थी

जब आप कॉलम सेल/रेंज  के अंतर्गत
लिखे विशिष्ट सेल
में अपने माऊस का कर्सर ले जाएंगे तो उसमें प्रयोग किए सिंटेक्स
को फॉर्मूला बार में भी स्पष्ट रूप से देख व पढ़ सकते हैं ।

 

🛠️ एक्स्ट्रा फ़ीचर्स :

✅ Conditional Formatting: Pass और Fail के अनुसार रंग बदलते हैं
✅ सभी इनपुट आसानी से बदले जा सकते हैं
✅ LOWER, UPPER और PROPER का रियल उदाहरण 

📌 इस शीट का उपयोग कैसे करें?

1.     ऊपर दी गई लिंक से Excel फाइल डाउनलोड करें ।

2.     हर फॉर्मूले को टेबल के अनुसार देखें और समझें ।

3.     इनपुट बदलकर देखें कि परिणाम कैसे बदलता है ।

4.     इस शीट को अपने स्कूल, ऑफिस, या ऑनलाइन क्लास में रेफरेंस की तरह इस्तेमाल करें ।

💬 अंतिम विचार

यहExcelFormulaMasterSheet एक आसान और प्रभावी तरीका है Excel की शुरुआत करने का इसे छात्रों, सहकर्मियों या किसी भी Excel सीखने वाले व्यक्ति के साथ ज़रूर साझा करें — और चाहें तो इसमें नए उदाहरण जोड़ते रहें।

💡 सुझाव:

  • Excel फाइल डाउनलोड करें
  • डेटा को समझें और अपने अनुसार बदलाव करें
  • बदलाव करने पर परिणाम अपने–आप बदलते हुए देखें!

✅ Also Read – More Useful Computer Tips & Tutorials:

🔹 Create a Clickable File Index in Excel – Step-by-Step Guide

Quickly locate your files and folders using Excel! This tutorial will help you reduce time spent searching on your PC.

🔹 Mail Merge in MS Word Using Excel – Complete Tutorial
Learn to send personalized letters, invitations, or labels in minutes using the powerful Mail Merge feature.

 
 

 

Post Views: 142
Tagged , , , , , , , , , , ,

2 Responses

Leave a Reply

Your email address will not be published. Required fields are marked *