Скачать или смотреть Excel Formula & Functions Basics | Complete Guide for Beginners

Is video me aapko Excel Formula & Functions Basics ka full guide milega jisme sabhi important formulas aur unka use samjhaya gaya hai. Agar aap Excel seekh rahe ho ya apna knowledge improve karna chahte ho to ye video aapke liye bahut useful hoga.

🔹 Key Formula Components

Reference Other Cells:

=A1 → Relative reference

$A$1 → Absolute/Fixed reference

=FXRate → Named range (Absolute)

A1:B5 → Range (cells), relative

[#DoB] → Column in table

Basic Formula Parts:

→ Addition


→ Subtraction


→ Multiply


/ → Division

^ → Power to

% → Percentage

= → Equal to

🔹 Key Excel Functions (Formula Tab)

Numerical and Stats:

SUM → Addition

SUMIFS → On condition(s)

AVERAGE → Average

AVERAGEIFS → On condition(s)

COUNT → Count numbers

COUNTIFS → On condition(s)

COUNTA → Count non-blank

MIN → Minimum

MAX → Maximum

INT → Text to number

Dates:

DATE → Make a date

YEAR → Year from date

EOMONTH → End of month

DATEDIF → Difference between dates

NETWORKDAYS → Workdays between dates

DATEVALUE → Text to date

Logical:

AND → All conditions true

OR → One condition true

IF → If ‘A’ do ‘B’ else do ‘C’

IFERROR → If ‘A’ is an error, do ‘B’

Text:

LEFT → Cut text from left

RIGHT → Cut text from right

MID → Cut from middle

FIND → Find position of text

SUBSTITUTE → Replace part of text

LEN → Number of characters

UPPER → Make uppercase

LOWER → Make lowercase

PROPER → Capitalize first letter

TRIM → Remove extra spaces

TEXT → Convert to text

Lookup:

XLOOKUP → Returns match


🔹 Formula Tools & Other Formula Uses

Formula Auditing Tools: Trace Precedents, Trace Dependents, Show Formulas, Error Checking, Evaluate Formula

Custom Data Validation

Custom Conditional Formatting


👉 Ye video aapko Excel ke formulas aur functions ka strong base dene ke liye hai.