fa
Feedback

فریب کلاهبرداران را نخورید! تل‌متریو این کانال‌ها را شناسایی و برچسب‌گذاری می‌کند 👉 برای مشاهده برچسب، اشتراک تهیه کنید

Excel Wali

Excel Wali

رفتن به کانال در Telegram

🔗Excel Course Videos 🔗Shortcuts 🔗Concepts Learn Computer Basic https://t.me/computerexcelwali

نمایش بیشتر
3 327
مشترکین
-124 ساعت
-97 روز
-3530 روز

در حال بارگذاری داده‌ها

جذب مشترکین
نوامبر '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: @MySearc
Ultimate Telegram Search Bot! Instantly find groups, channels, movies, news, chat messages👇 Bot: @mysearch Channel: @MySearchANN Group: @MySearch01
20 نوامبر, 04:17

2
+1
بدون متن...
328
3
+1
بدون متن...
289
4
Ultimate Telegram Search Bot! Instantly find groups, channels, movies, news, chat messages👇 Bot: @mysearch Channel: @MySearc
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: @MySearc
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: @MySearc
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: @MySearc
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👇
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👇
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👇
Ultimate Telegram Search Bot! Instantly find groups, channels, movies, news, chat messages👇
55
14
+6
بدون متن...
1 045
15
Excel for Data Analysts By Excel Wali+9
Excel for Data Analysts By Excel Wali
826
16
Ultimate Telegram Search Bot! Instantly find groups, channels, movies, news, chat messages👇
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👇
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👇
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👇
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👇
Ultimate Telegram Search Bot! Instantly find groups, channels, movies, news, chat messages👇
25