Scribd
Upload
2 views6 pages

? Microsoft Excel Module 4

Module 4 covers intermediate Excel functions including logical functions (IF, IFS, AND, OR), lookup functions (VLOOKUP, HLOOKUP, XLOOKUP), text functions (CONCAT, TEXTJOIN), and date functions (TODAY, NOW, DATEDIF). Each function is defined with syntax and examples to illustrate their usage. The module emphasizes decision making, data searching, text combining, and date manipulation in Excel.

Uploaded by

sb6899675
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
2 views6 pages

? Microsoft Excel Module 4

Module 4 covers intermediate Excel functions including logical functions (IF, IFS, AND, OR), lookup functions (VLOOKUP, HLOOKUP, XLOOKUP), text functions (CONCAT, TEXTJOIN), and date functions (TODAY, NOW, DATEDIF). Each function is defined with syntax and examples to illustrate their usage. The module emphasizes decision making, data searching, text combining, and date manipulation in Excel.

Uploaded by

sb6899675
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

🟡 MODULE 4: Intermediate Functions (Excel Notes)

📌 1. Logical Functions
✅ Definition
Logical functions help Excel make decisions based on
conditions.

🔹 IF Function (Recap + Nested IF)


Syntax:
=IF(condition, true_value, false_value)
Nested IF (multiple conditions):
=IF(A1>80,"A",IF(A1>50,"B","C"))
⚙️Steps
1. Select a cell
2. Type =IF(
3. Enter condition
4. Add true/false values
5. Press Enter
💡 Example
Marks grading using nested IF

🔹 IFS Function
✅ Definition
Checks multiple conditions without nesting
Syntax:
=IFS(condition1, value1, condition2, value2, ...)
Example:
=IFS(A1>80,"A", A1>50,"B", A1<=50,"C")

🔹 AND Function
✅ Definition
Returns TRUE only if all conditions are true
Syntax:
=AND(condition1, condition2)
Example:
=AND(A1>50, B1>50)

🔹 OR Function
✅ Definition
Returns TRUE if any one condition is true
Syntax:
=OR(condition1, condition2)
Example:
=OR(A1>50, B1>50)

📌 2. Lookup Functions
✅ Definition
Lookup functions are used to search data in tables.

🔹 VLOOKUP
Definition: Searches vertically (top to bottom)
Syntax:
=VLOOKUP(lookup_value, table, col_index, FALSE)
⚙️Steps
1. Select a cell
2. Type =VLOOKUP(
3. Enter lookup value
4. Select table range
5. Enter column number
6. Use FALSE for exact match
💡 Example
=VLOOKUP(A1, A2:C10, 2, FALSE)

🔹 HLOOKUP
Definition: Searches horizontally (left to right)
Syntax:
=HLOOKUP(lookup_value, table, row_index, FALSE)

📌 3. XLOOKUP (Modern Function)


✅ Definition
Advanced lookup function that replaces VLOOKUP & HLOOKUP.
🧾 Syntax
=XLOOKUP(lookup_value, lookup_array, return_array)
⚙️Steps
1. Type =XLOOKUP(
2. Select lookup value
3. Select lookup column
4. Select return column
5. Press Enter
💡 Example
=XLOOKUP(A1, A2:A10, B2:B10)
⭐ Advantages
 Works both vertical & horizontal
 No column index needed
 More accurate

📌 4. Text Functions

🔹 CONCAT
✅ Definition
Combines text from multiple cells
Syntax:
=CONCAT(text1, text2, ...)
Example:
=CONCAT(A1, B1)

🔹 TEXTJOIN
✅ Definition
Combines text with a delimiter (separator)
Syntax:
=TEXTJOIN(delimiter, ignore_empty, text1, text2,...)
Example:
=TEXTJOIN(" ", TRUE, A1, B1)

📌 5. Date Functions
🔹 TODAY
✅ Definition
Returns current date
Syntax:
=TODAY()

🔹 NOW
✅ Definition
Returns current date and time
Syntax:
=NOW()

🔹 DATEDIF
✅ Definition
Calculates difference between two dates
Syntax:
=DATEDIF(start_date, end_date, "unit")
🧾 Units
 "Y" → Years
 "M" → Months
 "D" → Days
💡 Example
=DATEDIF(A1, B1, "Y")

🎯 Quick Summary
 IF / IFS → Decision making
 AND / OR → Combine conditions
 VLOOKUP / HLOOKUP → Search data
 XLOOKUP → Modern & better lookup
 CONCAT / TEXTJOIN → Combine text
 TODAY / NOW / DATEDIF → Work with dates

You might also like