Excel Wali
前往频道在 Telegram
🔗Excel Course Videos 🔗Shortcuts 🔗Concepts Learn Computer Basic https://t.me/computerexcelwali
显示更多3 327
订阅者
-124 小时
-97 天
-3530 天
正在加载数据
相似频道
标签云
进出提及
---
---
---
---
---
---
吸引订阅者
十一月 '2611月 '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 11月, 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 |
