Excel darslari
Open in Telegram
Eng qiziqarli va oson usulda! Hamkorimiz @grandtalim Kirill - Lotin bot: @kirill_lotin_uzbot
Show moreThe country is not specifiedThe category is not specified
1 169
Subscribers
+724 hours
+187 days
+8230 days
Data loading in progress...
Similar Channels
Tags Cloud
No data
Any problems? Please refresh the page or contact our support manager.
Incoming and Outgoing Mentions
---
---
---
---
---
---
Attracting Subscribers
December '24
December '24
+136
in 0 channels
November '24
+104
in 0 channels
Get PRO
October '24
+147
in 0 channels
Get PRO
September '24
+126
in 0 channels
Get PRO
August '24
+138
in 0 channels
Get PRO
July '24
+76
in 0 channels
Get PRO
June '24
+84
in 0 channels
Get PRO
May '24
+153
in 0 channels
Get PRO
April '24
+115
in 0 channels
Get PRO
March '24
+233
in 0 channels
Get PRO
February '24
+1 450
in 0 channels
Get PRO
January '240
in 0 channels
Get PRO
December '230
in 0 channels
Get PRO
November '230
in 2 channels
Get PRO
October '230
in 0 channels
Get PRO
September '230
in 0 channels
Get PRO
August '230
in 0 channels
Get PRO
July '230
in 0 channels
Get PRO
June '230
in 0 channels
Get PRO
May '230
in 0 channels
Get PRO
April '230
in 0 channels
Get PRO
March '230
in 0 channels
Get PRO
February '230
in 0 channels
Get PRO
January '230
in 0 channels
Get PRO
December '220
in 0 channels
Get PRO
November '220
in 0 channels
Get PRO
October '22
+1
in 0 channels
Get PRO
September '22
+1
in 0 channels
Get PRO
August '22
+59
in 0 channels
Get PRO
July '22
+42
in 0 channels
Get PRO
June '22
+46
in 0 channels
Get PRO
May '22
+36
in 0 channels
Get PRO
April '22
+47
in 0 channels
Get PRO
March '22
+56
in 0 channels
Get PRO
February '22
+43
in 0 channels
Get PRO
January '22
+42
in 0 channels
Get PRO
December '21
+52
in 0 channels
Get PRO
November '21
+48
in 0 channels
Get PRO
October '21
+221
in 0 channels
Get PRO
September '21
+206
in 0 channels
Get PRO
August '21
+866
in 0 channels
| Date | Subscriber Growth | Mentions | Channels | |
| 21 December | +2 | |||
| 20 December | +2 | |||
| 19 December | +6 | |||
| 18 December | +13 | |||
| 17 December | +4 | |||
| 16 December | +9 | |||
| 15 December | +4 | |||
| 14 December | +10 | |||
| 13 December | +9 | |||
| 12 December | +14 | |||
| 11 December | +15 | |||
| 10 December | +4 | |||
| 09 December | 0 | |||
| 08 December | +8 | |||
| 07 December | +3 | |||
| 06 December | +19 | |||
| 05 December | +7 | |||
| 04 December | +3 | |||
| 03 December | +3 | |||
| 02 December | 0 | |||
| 01 December | +1 |
Channel Posts
Barcha yaxshi yangilik! Kirill Lotin botimiz serveriga pul tushgach yana ishlay boshladi!
https://t.me/kirill_lotin_uzbot
| 2 | Shu darsning Excel fayli | 2 762 |
| 3 | Excelda FIOni formula orqali uchga bo’lish
Foydalanilgan funksiyalar:
=пстр ()
=найти() | 1 157 |
| 4 | салом алайкум админ!!
Excelда данные бўлимидаги текст по столбацам титулидаги жойдан
қатордаги Ф.И.Оваларни шу амал бн катакларга алохида ажратса бўлади...
уша Ф.И.Оваларни тенг амали бн формула орқали катакларга ёзувларни алохида ажратса бўладими мастер класс кўрсатинг жавоб учун олдиндан рахмат👍😎👍 | 1 065 |
| 5 | Sub Multi_FindReplace()
Dim sht As Worksheet
Dim fndList As Variant
Dim rplcList As Variant
Dim x As Long
fndList = Array("Ð", "Б", "Ð’", "Г", "Д", "Е", "Ð", "Ж", "З", "И", "Й", "К", "Л", "М", "Ð", "О", "П", "Ð ", "С", "Т", "У", "Ф", "Ð¥", "Ц", "Ч", "Ш", "Ъ", "Ь", "Ð", "Ю", "Я", "ÐŽ", "Òš", "Ò’", "Ò²", "а", "б", "в", "г", "д", "е", "Ñ‘", "ж", "з", "и", "й", "к", "л", "м", "н", "о", "п", "Ñ€", "Ñ", "Ñ‚", "у", "Ñ„", "Ñ…", "ц", "ч", "ш", "ÑŠ", "ÑŒ", "Ñ", "ÑŽ", "Ñ", "Ñž", "Ò›", "Ò“", "Ò³")
rplcList = Array("A", "B", "V", "G", "D", "E", "Yo", "J", "Z", "I", "Y", "K", "L", "M", "N", "O", "P", "R", "S", "T", "U", "F", "X", "S", "Ch", "Sh", "ʼ", "", "E", "Yu", "Ya", "Oʻ", "Q", "Gʻ", "H", "a", "b", "v", "g", "d", "e", "yo", "j", "z", "i", "y", "k", "l", "m", "n", "o", "p", "r", "s", "t", "u", "f", "x", "s", "ch", "sh", "ʼ", "", "e", "yu", "ya", "oʻ", "q", "gʻ", "h")
'Loop through each item in Array lists
For x = LBound(fndList) To UBound(fndList)
'Loop through each worksheet in ActiveWorkbook
For Each sht In ActiveWorkbook.Worksheets
sht.Cells.Replace What:=fndList(x), Replacement:=rplcList(x), _
LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=True, _
SearchFormat:=True, ReplaceFormat:=True
Next sht
Next x
End Sub | 1 102 |
| 6 | Excel fayllarni endi kirillchadan lotinchaga o’girish uchun maxsus bot ham ochib qo’ydik
@kirill_lotin_uzbot
Videodagi VBA kodni pastda berdim | 1 033 |
| 7 | No text... | 955 |
| 8 | Hisobotlar krilchada bo‘lgan edi endi oladigon odam lotincha so‘rayabdi. Shunga krilchada tayyorlangan hisobotni lotinchaga o‘girishmi iloji bormi deb so‘ragandim. | 929 |
| 9 | Masalan shu exceldagi krilchani bir tugmada lotin alifbosiga uzgartish iloji bolsa. Bu funksya worda bor | 913 |
| 10 | Assalomu aleykum admin. Excelda kril yozuvlarni lotin alifbosiga otkazish iloji bormi? | 876 |
| 11 | Tezkor tugmalar - o'zingiz uchun eng muxim tugmani alt + 1 , 2 , 3 ... larga qo'yib olish | 987 |
| 12 | Клавишларни амалларга боглаш кандай булади?
Каердандир настройкасига алт+шифт ёки алт+= функсияларни киритиб куйилса кейин бажарадику шуни ургатинг илтимос | 897 |
| 13 | No text... | 1 375 |
| 14 | Bunda murakkablashib ketyapdi man yuborga jadvalni kursangiz 1 ta qator qushish k.k holos shuni iloji bormi yuqmi | 1 213 |
| 15 | Aka har bir qaytarilgan matnlar tugagandan sòng 1 ta qator qushish k.k shuni iloji bormi sodda bulishi k.kdaa aka | 1 199 |
| 16 | Ustunlar harf emas son bo’lib qolganda…
Excel 2010 Файл -> Параметры, Формулы галочка "Стиль ссылок R1C1" | 923 |
| 17 | Ustunlar harf emas son bo’lib qolganda…
Excel 2003: Сервис -> Параметры, Общие, галочка "Стиль ссылок R1C1". | 890 |
| 18 | Javobi shu videoda [ovoz uchun oldindan uzr, mikrofonim yo'q edi] | 1 429 |
| 19 | 1 listda 4 ta yacheykada qilgan ishlarimni jami raqamlari yozilgan , shu narsani 2 chi listga ötkazib , 1 chi listni õzgartirganimda, kôchirganim ham ôzgarishi kk | 1 223 |
| 20 | Raxmat óxshadi👍 | 1 068 |
