Excel Wali
رفتن به کانال در Telegram
🔗Excel Course Videos 🔗Shortcuts 🔗Concepts Learn Computer Basic https://t.me/computerexcelwali
نمایش بیشتر3 327
مشترکین
-124 ساعت
-97 روز
-3530 روز
در حال بارگذاری دادهها
کانالهای مشابه
ابر برچسبها
اشارات ورودی و خروجی
---
---
---
---
---
---
جذب مشترکین
نوامبر '26نوامبر '26
نوامبر '26
+23
در 0 کانالها
اکتبر '26
+39
در 0 کانالها
Get PRO
سپتامبر '26
+58
در 0 کانالها
Get PRO
اوت '26
+102
در 0 کانالها
Get PRO
ژوئیه '26
+100
در 0 کانالها
Get PRO
ژوئن '26
+60
در 0 کانالها
Get PRO
مه '26
+69
در 1 کانالها
Get PRO
آوریل '26
+57
در 0 کانالها
Get PRO
مارس '26
+11
در 0 کانالها
Get PRO
فوریه '26
+31
در 0 کانالها
Get PRO
ژانویه '26
+174
در 0 کانالها
Get PRO
دسامبر '25
+76
در 0 کانالها
Get PRO
نوامبر '25
+37
در 0 کانالها
Get PRO
اکتبر '25
+63
در 0 کانالها
Get PRO
سپتامبر '25
+138
در 0 کانالها
Get PRO
اوت '25
+245
در 0 کانالها
Get PRO
ژوئیه '25
+133
در 0 کانالها
Get PRO
ژوئن '25
+236
در 0 کانالها
Get PRO
مه '25
+137
در 0 کانالها
Get PRO
آوریل '25
+193
در 0 کانالها
Get PRO
مارس '25
+353
در 1 کانالها
Get PRO
فوریه '25
+139
در 0 کانالها
Get PRO
ژانویه '25
+284
در 0 کانالها
Get PRO
دسامبر '24
+144
در 0 کانالها
Get PRO
نوامبر '24
+115
در 0 کانالها
Get PRO
اکتبر '24
+148
در 0 کانالها
Get PRO
سپتامبر '24
+124
در 0 کانالها
Get PRO
اوت '24
+94
در 0 کانالها
Get PRO
ژوئیه '24
+42
در 0 کانالها
Get PRO
ژوئن '24
+147
در 0 کانالها
Get PRO
مه '24
+259
در 0 کانالها
Get PRO
آوریل '24
+125
در 0 کانالها
Get PRO
مارس '24
+603
در 0 کانالها
Get PRO
فوریه '24
+1 264
در 0 کانالها
| تاریخ | رشد مشترکین | اشارات | کانالها | |
| 22 نوامبر | 0 | |||
| 21 نوامبر | +2 | |||
| 20 نوامبر | +3 | |||
| 19 نوامبر | 0 | |||
| 18 نوامبر | +4 | |||
| 17 نوامبر | +2 | |||
| 16 نوامبر | 0 | |||
| 15 نوامبر | 0 | |||
| 14 نوامبر | 0 | |||
| 13 نوامبر | 0 | |||
| 12 نوامبر | +1 | |||
| 11 نوامبر | +1 | |||
| 10 نوامبر | +5 | |||
| 09 نوامبر | 0 | |||
| 08 نوامبر | +2 | |||
| 07 نوامبر | 0 | |||
| 06 نوامبر | +1 | |||
| 05 نوامبر | 0 | |||
| 04 نوامبر | +1 | |||
| 03 نوامبر | +1 | |||
| 02 نوامبر | 0 | |||
| 01 نوامبر | 0 |
پستهای کانال
Ultimate Telegram Search Bot! Instantly find groups, channels, movies, news, chat messages👇
Bot: @mysearch
Channel: @MySearchANN
Group: @MySearch01
20 نوامبر, 04:17
| 2 | بدون متن... | 328 |
| 3 | بدون متن... | 289 |
| 4 | Ultimate Telegram Search Bot! Instantly find groups, channels, movies, news, chat messages👇
Bot: @mysearch
Channel: @MySearchANN
Group: @MySearch01 | 47 |
| 5 | https://app.rigi.club/B1s0/8n2bg8p1 | 107 |
| 6 | Ultimate Telegram Search Bot! Instantly find groups, channels, movies, news, chat messages👇
Bot: @mysearch
Channel: @MySearchANN
Group: @MySearch01 | 149 |
| 7 | Ultimate Telegram Search Bot! Instantly find groups, channels, movies, news, chat messages👇
Bot: @mysearch
Channel: @MySearchANN
Group: @MySearch01 | 48 |
| 8 | 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 | 712 |
| 9 | Ultimate Telegram Search Bot! Instantly find groups, channels, movies, news, chat messages👇
Bot: @mysearch
Channel: @MySearchANN
Group: @MySearch01 | 139 |
| 10 | Ultimate Telegram Search Bot! Instantly find groups, channels, movies, news, chat messages👇 | 130 |
| 11 | 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 👍 | 1 000 |
| 12 | Ultimate Telegram Search Bot! Instantly find groups, channels, movies, news, chat messages👇 | 70 |
| 13 | Ultimate Telegram Search Bot! Instantly find groups, channels, movies, news, chat messages👇 | 55 |
| 14 | بدون متن... | 1 045 |
| 15 | Excel for Data Analysts By Excel Wali | 826 |
| 16 | Ultimate Telegram Search Bot! Instantly find groups, channels, movies, news, chat messages👇 | 159 |
| 17 | Ultimate Telegram Search Bot! Instantly find groups, channels, movies, news, chat messages👇 | 191 |
| 18 | Ultimate Telegram Search Bot! Instantly find groups, channels, movies, news, chat messages👇 | 30 |
| 19 | Ultimate Telegram Search Bot! Instantly find groups, channels, movies, news, chat messages👇 | 220 |
| 20 | Ultimate Telegram Search Bot! Instantly find groups, channels, movies, news, chat messages👇 | 25 |
