Excel Wali
رفتن به کانال در Telegram
🔗Excel Course Videos 🔗Shortcuts 🔗Concepts Learn Computer Basic https://t.me/computerexcelwali
نمایش بیشتر3 327
مشترکین
-124 ساعت
-97 روز
-3530 روز
آرشیو پست ها
3 327
Ultimate Telegram Search Bot! Instantly find groups, channels, movies, news, chat messages👇
Bot: @mysearch
Channel: @MySearchANN
Group: @MySearch01
20 نوامبر, 04:17
3 327
Ultimate Telegram Search Bot! Instantly find groups, channels, movies, news, chat messages👇
Bot: @mysearch
Channel: @MySearchANN
Group: @MySearch01
17 نوامبر, 04:17
17 نوامبر, ~08:16
3 327
Ultimate Telegram Search Bot! Instantly find groups, channels, movies, news, chat messages👇
Bot: @mysearch
Channel: @MySearchANN
Group: @MySearch01
14 نوامبر, 04:08
15 نوامبر, ~19:56
3 327
Ultimate Telegram Search Bot! Instantly find groups, channels, movies, news, chat messages👇
Bot: @mysearch
Channel: @MySearchANN
Group: @MySearch01
11 نوامبر, 04:07
11 نوامبر, ~09:08
3 327
VLOOKUP vs XLOOKUP in Excel:
XLOOKUP is a more flexible and powerful function than VLOOKUP, providing better options for exact matches, direction flexibility, and error handling.
1. Data Range:
- VLOOKUP: Can only search from left to right. The lookup value must be in the first column.
- XLOOKUP: Can search in any direction (left to right, right to left, above, or below).
2. Column/Row Flexibility:
- VLOOKUP: Requires you to specify the column number of the data to return, which can break if columns are added/removed.
- XLOOKUP: Uses a range reference, so it automatically adjusts even if columns are inserted or removed.
3. Exact Match:
- VLOOKUP: Defaults to an approximate match, requiring you to specify "FALSE" for an exact match.
- XLOOKUP: Defaults to an exact match, making it more intuitive.
4. Error Handling:
- VLOOKUP: Requires IFERROR to handle errors.
- XLOOKUP: Has a built-in error-handling argument to display a custom message when no match is found.
5. Multiple Values:
- VLOOKUP: Returns one value only.
- XLOOKUP: Can return multiple values by selecting a range.
6. Performance:
VLOOKUP: Generally slower, especially on large datasets.
XLOOKUP: Faster, optimized for large datasets.
For More Resources
https://t.me/excel_wali
10 نوامبر, 13:18
3 327
Ultimate Telegram Search Bot! Instantly find groups, channels, movies, news, chat messages👇
Bot: @mysearch
Channel: @MySearchANN
Group: @MySearch01
08 نوامبر, 04:00
10 نوامبر, ~13:18
3 327
Ultimate Telegram Search Bot! Instantly find groups, channels, movies, news, chat messages👇
05 نوامبر, 03:56
06 نوامبر, ~00:21
3 327
Must know formula's in Excel for data analyst
Basic Arithmetic Formulas
1. Addition: =A1 + B1
2. Subtraction: =A1 - B1
3. Multiplication: =A1 *B1
4. Division: =A1 / B1
5. Sum: =SUM(A1:A10) - Adds all numbers in the specified range.
6. Average: =AVERAGE(A1:A10) - Calculates the average of numbers in the specified range.
7. Max: =MAX(A1:A10) - Finds the maximum value in the specified range.
8. Min: =MIN(A1:A10) - Finds the minimum value in the specified range.
Logical Formulas
1. IF: =IF(A1 > 10, "Yes", "No") - Returns "Yes" if A1 is greater than 10; otherwise, returns "No".
2. AND: =AND(A1 > 10, B1 < 5) - Returns TRUE if both conditions are met.
3. OR: =OR(A1 > 10, B1 < 5) - Returns TRUE if at least one condition is met.
4. NOT: =NOT(A1 > 10) - Reverses the logic; returns TRUE if A1 is not greater than 10.
Text Formulas
1. CONCATENATE: =CONCATENATE(A1, " ", B1) - Combines text from multiple cells.
- Alternatively, =A1 & " " & B1 can also be used.
2. LEFT: =LEFT(A1, 3) - Extracts the first 3 characters from the left side of the text in A1.
3. RIGHT: =RIGHT(A1, 3) - Extracts the last 3 characters from the right side of the text in A1.
4. MID: =MID(A1, 2, 3) - Extracts 3 characters from A1 starting at the 2nd character.
5. LEN: =LEN(A1) - Returns the number of characters in the text of A1.
6. TRIM: =TRIM(A1) - Removes extra spaces from text, leaving only single spaces between words.
Lookup & Reference Formulas
1. VLOOKUP: =VLOOKUP(A1, B1:C10, 2, FALSE) - Looks for A1 in the first column of the range and returns the corresponding value from the second column.
2. HLOOKUP: =HLOOKUP(A1, B1:C10, 2, FALSE) - Similar to VLOOKUP, but searches horizontally.
3. INDEX: =INDEX(A1:B10, 2, 2) - Returns the value of a cell in a specified row and column within a range.
4. MATCH: =MATCH(A1, B1:B10, 0) - Returns the relative position of a specified value within a range.
5. INDIRECT: =INDIRECT("A1") - Returns the value of the cell specified by a text string.
Date & Time Formulas
1. TODAY: =TODAY() - Returns the current date.
2. NOW: =NOW() - Returns the current date and time.
3. DATEDIF: =DATEDIF(A1, B1, "d") - Calculates the difference between two dates in days.
4. EDATE: =EDATE(A1, 1) - Adds a specified number of months to a date.
5. TEXT: =TEXT(A1, "dd/mm/yyyy") - Converts a date to text in a specified format.
Statistical Formulas
1. COUNT: =COUNT(A1:A10) - Counts the number of numeric cells in a range.
2. COUNTA: =COUNTA(A1:A10) - Counts the number of non-empty cells in a range.
3. COUNTIF: =COUNTIF(A1:A10, ">10") - Counts the number of cells in a range that meet a specific condition.
4. SUMIF: =SUMIF(A1:A10, ">10", B1:B10) - Adds the values in a range that meet a specified condition.
5. AVERAGEIF: =AVERAGEIF(A1:A10, ">10") - Calculates the average of numbers in a range that meet a specified condition.
More Excel Resources:
https://t.me/excel_wali
Hope this helps you 👍
02 نوامبر, 09:42
3 327
Ultimate Telegram Search Bot! Instantly find groups, channels, movies, news, chat messages👇
02 نوامبر, 03:56
02 نوامبر, ~09:39
3 327
Ultimate Telegram Search Bot! Instantly find groups, channels, movies, news, chat messages👇
30 اکتبر, 04:55
30 اکتبر, ~10:38
3 327
Ultimate Telegram Search Bot! Instantly find groups, channels, movies, news, chat messages👇
27 اکتبر, 04:54
28 اکتبر, ~22:30
3 327
Ultimate Telegram Search Bot! Instantly find groups, channels, movies, news, chat messages👇
24 اکتبر, 04:54
26 اکتبر, ~05:54
3 327
Ultimate Telegram Search Bot! Instantly find groups, channels, movies, news, chat messages👇
21 اکتبر, 04:48
21 اکتبر, ~06:09
3 327
Ultimate Telegram Search Bot! Instantly find groups, channels, movies, news, chat messages👇
18 اکتبر, 04:45
21 اکتبر, ~06:09
3 327
Ultimate Telegram Search Bot! Instantly find groups, channels, movies, news, chat messages👇
15 اکتبر, 04:45
15 اکتبر, ~05:59
