Excel Formula Basics - Reference, Operators & Common Errors | Excel Full Course | Lecture - 10

Learn Excel formula basics — references (relative/absolute/mixed), operators, PEMDAS, and how to fix common errors like #DIV/0!, #Name?, #Value!, #REF! and #N/A.
This quick bilingual Hindi tutorial explains references, operators, order of operations (PEMDAS) and how to solve the most common formula errors.

What you’ll learn:
• How relative, absolute and mixed references work (with examples).
• Use arithmetic, comparison, text & reference operators in Excel.
• PEMDAS (order of operations) inside Excel formulas.
• Fix common errors: #DIV/0!, #REF!, #NAME?, #VALUE!, #N/A
• Quick tips to build error-resistant formulas.

Timestamps:
0:00 — Intro
0:10 — Syntax
0:37 — Relative, Absolute and Mixed references
1:56 — Excel Operators (Arithmetic, Comparison, Text and Reference Operators)
3:47 — Order of Operation in excel (PEMDAS vs BODMAS)
4:10 — Common formula errors (#DIV/0!, #REF!, #NAME?, #VALUE! and #N/A)
4:48 — Quick fixes & error-proofing tips (Evaluate Formula, IFERROR)
5:06— Resources

Download resources & files:
Cheat Sheet —https://drive.google.com/file/d/1ufeSB8l9a-IE6suajxHV269ycHK4RNSk/view?usp=sharing

Related playlist: https://youtube.com/playlist?list=PLQvnZU9XAXLsajQBuwkzHFkdSPgd8Q_WM&si=0SNi8GWlecoNbp13

If this helped, please👍 Like this video and🔔 Subscribe for weekly Excel tutorials

#Excel #ExcelFormulas #PEMDAS #ExcelHindi #ExcelErrors #ExcelFormulaBasics #ExcelReferences #ExcelErrors #AbsoluteReference #ExcelOperators

Видео Excel Formula Basics - Reference, Operators & Common Errors | Excel Full Course | Lecture - 10 канала Learn with Raju