Now create it with Excel, Word Cloud Text Mining Automation Power Query & Power BI Utilization

51,652 views

오빠두엑셀 l 엑셀 강의 대표채널

Published on Sep 8, 2021
About :

👇🏻 Download example files used in the lecture https://www.oppadu.com/%ec%97%91%ec%8... Free word cloud production homepage: https://www.wordclouds.com ⭐ Creating an Excel Advanced Filter Macro Program - Excel LIVE Episode 45 Full Video • Excel LIVE Episode 53 - Creating an Excel x Power BI Keyword Analysis Tool... ⭐ Oppa Do Excel We Can Do Membership Channel has been opened. / @oppadu Pro: Provides full video replay of live lectures Premium: Provides premium-only workshops and replay videos #ExcelAdvancedFilter #ExcelAutomaticFilter #FilterMacro ❤️ OppaDuExcel Official Website: https://www.oppadu.com 📚 Go to Excel Community: https://www.oppadu.com/question 00:00 Lecture Start 02:04 Basic Principles of Power Query Keyword Analysis 03:42 Notes for Those Unfamiliar with Power Query 04:29 Power Query Text Mining Limitations 05:22 Creating a Table to Convert to a Query 07:13 Creating a Basic Query 08:41 1. Separate delimiters with spaces 11:43 2. Separate keywords by spaces 12:45 3. Remove special characters 13:38 4. Remove unnecessary words (optional) 15:30 5. Remove suffixes (eul, reul, eseo) 18:07 Check the completed query 19:30 Add suffixes to remove 20:14 Text mining practice 21:06 Remove single-letter words from analysis results 21:54 Create a free word cloud 23:30 Create a word cloud with Power BI

  • vidoe Comments
Trend Videos
5:02
2 weeks before the second birth, Jo Du-pal (+30kg)
조두팔
267,113 views   2 days ago
2:19
Bernice Character Play "A Glass for You Who Are Sad" Zenres John Zero
젠레스 존 제로
196,926 views   2 days ago
5:24
[Park Soo-hong is happy] I insisted on natural childbirth at 41 weeks pregnant, but in the end...
박수홍 행복해다홍
707,279 views   4 days ago
11:07
I'm surprised that cabbage kimchi is this delicious.
김대석 셰프TV
573,480 views   8 days ago
20:46
Hong Jin-kyung and Han Ga-in, who were surprised to see each other for the first time in person (Yukgaejang, Hwangtaejijim)
공부왕찐천재 홍진경
1,119,069 views   7 days ago
15:15
(Caution: Goosebumps) The shocking future of Jang Yeong-ran seen by a newly possessed shaman
A급 장영란
1,888,690 views   6 days ago
11:34
How much will the taxi fare be?
고재영
1,018,886 views   2 days ago
25:49
Moving to a two-room rooftop apartment with three terraces in Seoul - [Single-family home 3]
계곡은개골개골
246,974 views   2 days ago
21:06
I went to Jakarta to eat Nasi Goreng⎪🇮🇩Indonesia1
원지의하루
504,230 views   3 days ago
8:57
Why Son Heung-min is better without Hwang Hee-chan
김진짜 Real KIM
677,572 views   6 days ago
5:01
[Hwang Young-woong regular album] Your side_Official music video
황영웅 Tv
1,141,984 views   2 days ago
13:18
Can you beat Minecraft in Adventure Mode?
우융
260,642 views   5 days ago
9:05
[Musical Star] Kwak Philip - I'm a Monster (MONSTER) Frankenstein (4K)
빵송국
287,338 views   5 days ago
16:21
Kang Min-a, who got married in Yeoju
인생84
1,360,081 views   5 days ago
11:34
How much will the taxi fare be?
고재영
1,018,886 views   2 days ago
28:27
What Happens When Your 17-Year-Old Friend Becomes Your Manager - Vietnam 〔Part 1〕
채코제 Channel Korean Jay
428,121 views   2 days ago
16:12
💀Continuing abnormal climate on the Korean Peninsula… How are we coping with it? / 💀 feat. Gyeonggi-do
지식해적단
178,684 views   2 days ago
2:51
SAY MY NAME 'WaveWay' MV
SAY MY NAME
1,117,099 views   1 day ago
3:55
PLAVE - What If Official M/V
GENIE MUSIC
453,174 views   4 days ago
3:47
DRAMAㅣZINGBERGER COVER
징버거 JINGBURGER
433,178 views   5 days ago
13:18
Can you beat Minecraft in Adventure Mode?
우융
260,642 views   5 days ago
26:36
[Any Collection] "We can't be friends, do you understand?" The junior who hurt Jung Chae-yeon with abusive language 🔥Regulating discipline🔥 Little brother fool Hwang In-yeop X Bae Hyun-seong☺ Prefabricated Family JTBC 241016 Broadcast
DRAMA Voyage
242,612 views   1 day ago
28:27
What Happens When Your 17-Year-Old Friend Becomes Your Manager - Vietnam 〔Part 1〕
채코제 Channel Korean Jay
428,121 views   2 days ago
3:47
DRAMAㅣZINGBERGER COVER
징버거 JINGBURGER
433,178 views   5 days ago
11:53
Japan's Hidden Gourmet Snack 'Basashi' [馬刺し]
유우키의 일본이야기 YUUKI
373,903 views   3 days ago
17:05
[Daily Vlog] What do you do when you're not filming mukbang? 😲 Real close-up vlog of playing, eating, and working hard💻📝 (feat. Speak)
살빼조DietJo
236,696 views   2 days ago
21:06
I went to Jakarta to eat Nasi Goreng⎪🇮🇩Indonesia1
원지의하루
504,230 views   3 days ago
34:22
Tolseobang, who arranged a trip to Sicily for his mother-in-law before joining the company
멜봉 네덜란드 MelBong
130,573 views   4 days ago
1:11
[Steph] Korean Dance Choi Ho-jong 'Nightmare' Main Role Casting Audition
The CHOOM (더 춤)
407,470 views   2 days ago
3:16
Neneko Mashiro 'Spring Dream'
네네코 마시로 NENEKO MASHIRO
116,722 views   1 day ago
4:05
[4K] Lee Ho-kwang - Land of Lola (Angel: Bori, Yari) LIVE @241013 Congratulatory Song
짱호
333,338 views   3 days ago
1:11
[Steph] Korean Dance Choi Ho-jong 'Nightmare' Main Role Casting Audition
The CHOOM (더 춤)
407,470 views   2 days ago
Google AdSense
336 x 280
Up Next
1:19:16
Derya Turkan & Alper Kekech
Matrix Rotterdam
16,396 views
Streamed 2 years ago
9:27
Ozer Ozel - Derya Turkan - Tanburi Cemil Bey Ferahfeza Saz Semai
Enes Üstün (menustun)
120,990 views
12 years ago
7:00
Neyzen Emin (Writer) Dede Beyati Preface
MFb
319,259 views
9 years ago
5:49
Ozer Ozel - Suz-i dil Saz Semai (Fahri Kopuz-Sedat Oztoprak)
Özer Özel
11,045 views
7 years ago
6:55
Derya Türkan - Lament (Uşşâk)
Mevlûde Burnaz
479,211 views
11 years ago
2:58
Zeynel Demirtaş - Hijaz Prelude (Refik Fersan)
ZeynelDemirtaVEVO
8,988 views
2 years ago
5:52
Ozer Ozel - Kurdilihicâzkar Prelude - Composer: Tanburi Cemil Bey
Özer Özel
24,640 views
9 years ago
56:35
Ozer Ozel & Derya Turkan - Dede Efendi House Concert
Özer Özel
4,809 views
4 years ago
52:38
Interviews with Masters - Derya Türkan
Kenan Tülek
1,258 views
2 years ago
7:04
Sultani-Yegah Pesrev (Refik Fersan)-Ahenk
Küçük Tanbûrî
79,772 views
11 years ago
9:24
Ferahfeza Saz Semaisi - Özer Özel & Derya Türkan (Tanburi Cemil Bey)
Özer Özel
11,195 views
5 years ago
1:31
Elif folk song with Özer Özel tambour
bincee80
435,104 views
13 years ago
1:09:00
CONCERT - Derya Türkan, İsmail Hakkı Fencioğlu, Özata Ayan
Boğaziçi Üniversitesi Türk Müziği Kulübü
3,758 views
8 months ago
7:59
Goksel Baktagir - Hijaz Saz Semai (Garip)
uNReaL1905
1,480,728 views
17 years ago
1:16:22
Ozer Ozel & Ismail Altunsaray Concert 2/2 (In Memory of Neset Ertas)
Özer Özel
32,314 views
4 years ago
1:12:25
Ozer Ozel & Derya Turkan
Tanburi Cemil Bey Derneği
16,836 views
4 years ago
8:38
Erkan Oğur & Derya Türkan - Zahit Know Us Eyleme (26, International İzmir Festival)
D. K.
1,096,151 views
10 years ago
8:59
Ozer Ozel & Aslihan Ozel - Muhayyer Saz Semai (Tanburi Cemil Bey)
Tanburi Cemil Bey Derneği
70,176 views
7 years ago
8:15
Nikriz Sazsemâîsi - Cinuçen Tanrıkorur & İhsan Özgen (Refik Fersan)
Cinuçen Tanrıkorur
23,893 views
3 years ago
31:37
Ehl-i Makam Guests Ozer Ozel and Derya Turkan Part 1 December 20, 2014 Traditional Arts Academy
Küçükçekmecem Tv
14,000 views
9 years ago
1:45:03
Al Avocato full Movie HD - Adel Emam exclusive - Al Avocato movie starring Adel Emam and Yousra exclusively
ذكريات الدراما
1,137,029 views
6 months ago
3:58:10
Surat Al-Baqarah Sheikh Abdul Basit Abdul Samad The Holy Quran Live Surat Al-Baqarah Quran Recitation
أنا مسلم - I'm a Muslim
2,147,437 views
Streamed 11 months ago
1:33:05
A wonderful evening.. An evening waiting for my uncle Bey HD Starring Mohamed Reda and Karima Mokhtar!
MyContent منوعات
17,522 views
1 day ago
1:23:22
Masoud Saeed movie why
Aflamna El7elwa - أفلامنا الحلوة
3,536,402 views
6 years ago
1:42:43
They took him to the police station because of a cup of tea
دراما عالماشي
2,838 views
15 hours ago
2:07:33
Bakhit and Adeela full movie HD - Adel Emam & Sherine - Bakhit and Adeela full movie starring Adel Emam
ذكريات الدراما
961,550 views
6 months ago
1:34:50
Exclusively, The Accused movie Starring Salah Zulfikar and Maali Zayed
Aflam Gamda
903,578 views
1 year ago
2:04:45
Exclusive movie The Execution Squad Starring Nour El-Sherif and Mamdouh Abdel-Alim
Bee Movies
3,741,163 views
3 years ago
2:15:15
El Beh El Bawab Movie
Al Masreya Al Lobnaneya المصرية اللبنانية
4,968,971 views
8 years ago
3:25:53
El Nemr Film - Starring Mohamed Emam
Synergy تامر مرسي
31,519,742 views
2 years ago
1:55:59
The movie "No One Saw No One Knew" Starring Adel Emam and Moali Zayed
Bee Movies
441,423 views
1 year ago
2:14:34
Kill My Wife and I Will Salut You full movie HD
ذكريات الدراما
31,665 views
2 months ago
2:03:52
On the Minister's Doorstep Movie Starring Adel Emam and Yousra
Bee Movies
3,042,148 views
3 years ago
3:55:44
Surat Al-Baqarah in full, a ruqyah for the home and a treatment for magic. Recitation that soothes the heart and opens the chest - Sourate Al-Baqara
أنا مسلم - I'm a Muslim
5,811 views
Streamed 4 days ago
1:53:04
So the smoke doesn't fly away movie
IMedia Movies | أي ميديا موفيز
210,973 views
1 year ago
Google AdSense
336 x 280

fetery.com. Copyright 2024