Excel darslari


Channel's geo and language: Uzbekistan, Uzbek


Tez va oson darslar!
youtube.com/@Exceldarslari
Hamkorimiz @grandtalim
Kirill - Lotin bot: @kirill_lotin_uzbot

Related channels  |  Similar channels

Channel's geo and language
Uzbekistan, Uzbek
Statistics
Posts filter


👍


juda foydali bo'ldi, rahmat




Forward from: Excel darslari Chat
Shuni sinab ko’ringchi, balki G5 manzilini G6 qilish kerak bo’lishi mumkin


Forward from: Excel darslari Chat
=ТЕКСТ(ДАТА(ЕСЛИ(СЧЕТЧИСЛ(ПСТР(G5;5;2)+0>30);1900;2000)+ПСТР(G5;5;2);ПСТР(G5;3;2);ПСТР(G5;1;2));"ДД.ММ.ГГГГ")


shunga yordam bervoring👆


Birinchi qatordagi tugilgan kun oy yil jshshrdan ajratib olingan, shuni 2-qatordagi shaklga keltirish uchun nima qilsa bo'ladi, 2-qatordagi qo'lda yozilgan


Video is unavailable for watching
Show in Telegram
Tartib raqami 1000gacha bo’lsachi?

#ExcelDarslari

PS
Bugun shu savol tushgan ekan, qayta yuklandi


Mana Olimpiada ham tugadi.

Olingan medallarni tahlil qilib ko'rib, nega bizda yugurish va suzishga unchalik katta e'tibor yo'qligini o'ylab qoldim. Umuman olganda AQSh ham Xitoy ham eng ko'p oltin medalni yengil atletikodan olibti.

Suzishni zo'r tarafi shuki bitta odam 5tagacha oltin olish imkoni bor ekan. Boksda esa bu imkoniyat yo'q menimcha. Ya'ni bizning barcha bokschilarimiz olgan 5 ta oltin medalni Fransiyaning bitta suzuvchisi olgan.

Balki men sportni yaxshi tushunmasman, lekin sonlar shuni ko'rsatyaptiki, AQSh uchun eng zo'r sport bu yugurish, sakrash va uloqtirish bo'lgan, naqd 14 ta oltin medal olib kelgan. AQSh jami 40ta oltin medal olgan bo'lsa shunda 35%i atletika.

Xullas, endi maktabimizda qumga sakrash va yugurishni albatta yo'lga qo'yamiz.

https://olympics.com/en/paris-2024/medals

@exceldarslari

PS
Asosiysi kaltak yeb, bir-birini mayib qilgandan, yugurib, suzib, narsa uloqtirish xavfsizroq tuyuldi menga.




Test qilib, ishlatib ko'rish uchun kerakli fayllar 👇


Video is unavailable for watching
Show in Telegram
Excel bilan Photoshopni ulab, avtomatlashtiramiz

Videodagi kod quyidagi faylda topishingiz mumkin

@exceldarslari

YouTubeda

5k 0 15 7 14

Ushbu kodni Google Sheets’da ishlatish uchun:

1. Google Sheets hujjatingizni oching.
2. Extensions > App script -ga o'ting.
3. Skript muharririda istalgan kod bo’lsa uni o'chiring va taqdim etilgan kod bilan almashtiring.
4. Skriptni saqlang.
5. Skript muharririni yoping.

Endi, belgilangan varaqdagi A ustunidagi katakchani (A1 dan A1000 gacha) tahrirlaganingizda, B ustunidagi qo'shni katak avtomatik ravishda joriy sana va vaqt bilan yangilanadi. Agar varaq nomi “Sheet1” dan farq qilsa, uni kod ichida ham o’zgartiring.


function onEdit(e) {
var range = e.range;
var sheet = range.getSheet();

if (sheet.getName() == "Sheet1") { // Change "Sheet1" to your sheet name
var column = range.getColumn();
var row = range.getRow();

if (column == 1 && row >= 1 && row




Video is unavailable for watching
Show in Telegram
GOOGLEFINANCE funksiyasi bilan dollar kursini tortib olamiz (Google Sheets)

@exceldarslari

PS
Bir kun kechikkan video

6k 0 19 25 15

Video is unavailable for watching
Show in Telegram
Google sheets dasturida katakni ichiga progress bar qilish kerak bo’lib qolsa shu formuladan foydalanasiz:

=SPARKLINE(C6/B6, {"charttype","bar"; "max",1; "min", 0; "color1", "green"})

@exceldarslari


Video is unavailable for watching
Show in Telegram
Oylikni oshirishda ikki xil hisoblash usuli, uchinchisini izohda yozib qoldiring!

@exceldarslari


Video is unavailable for watching
Show in Telegram
Doim, birlashtirilgan kataklar jadvalni tahlil qilishda hammaga xalaqt qiladi lekin baribir juda ko’pchilik shu formatdan foydalanadi. Uning o’rniga:

Batafsil:
https://youtu.be/GLfWqVcnllo?si=oujVz_BXlSSYBejc

@exceldarslari

5.4k 0 12 10 13

Video is unavailable for watching
Show in Telegram
СЧЁТЕСЛИ / COUNTIF formulasi yordamida 60%dan ko’p to’lov qilganlar sonini aniqlash

https://youtu.be/Z0ZZ_caTiPY?si=TS6KZMCx62NFhxcL

@exceldarslari

4.4k 0 24 39 10

Video is unavailable for watching
Show in Telegram
Excel darslari: mini market uchun shtrix kod skaner

Baza

@exceldarslari

4.6k 0 26 28 15
20 last posts shown.