[Compilation] [Excel] Tasks that can be completed in seconds if you know the functions ① to ⑫

294,247 views

わちょんのゆっくりIT

Published on Mar 20, 2024
About :

The new school year is just around the corner. Let's not waste time and effort on pointless Excel work. I hope we can learn something from the methods of Bucho, Reimu, and Marisa. <Table of contents> Contents (Key points) 0:00 Opening 1:39 Creating sequential numbers (jump function, SEQUENCE function) 6:00 Deleting blank cells (working column, F4) 11:27 Column numbers for VLOOKUP function (COLUMNS function, XLOOKUP function) 17:12 Days of the week (TEXT function, display format) 21:31 Creating a calendar (IF function, template function) 27:27 Selecting A1 for all sheets (select all sheets function, considering opportunities to use macros) 32:10 Sequential numbers from A to B to C (CHAR function, the importance of questioning the method in the first place) 37:35 Transferring image data to cells (get data function, insert from image function) 42:53 Deleting cells that do not contain formulas (jump function (again), the importance of having a database) 48:00 Splitting names (MID function, FIND function, TEXTSPLIT function) 53:51 Multiple or condition filters (advanced filter settings, the importance of work columns) 59:54 Overly detailed formatting (add-in functions, shortcut keys) <Respect> F-rank University Employment Channel / @user-ys6bh5zc3k <Wachon's website> https://wachi-yon.jp/exceldlpage/exce... <Twitter> Wachon / wachi_yukkuri <Video editing software> Yukkuri MovieMaker4 https://manjubox.net/ymm4/ <Music and sound effects> Amacha Music Studio https://amachamusic.chagasi.com/terms... Sound Effect Lab https://soundeffect-lab.info/sound/an... Maoudamashii https://maou.audio/ <Advertisement below> Books and online schools that teach Excel and programming-related technologies. This is an affiliate link, so if you purchase something from the link below, Wachon will also receive a reward. Please forgive me. ■Books・Excel Super Time-Saving Methods Taught by Charismatic YouTubersAmazon: (1,870 yen) https://px.a8.net/svt/ejp?a8mat=3NCUS... ・Excel Work Techniques for Learning Functions Properly What if Excel Functions Used in Work were Personified? (1,760 yen) https://px.a8.net/svt/ejp?a8mat=3NCUS... ・Perfect Excel VBA (3,608 yen) https://px.a8.net/svt/ejp?a8mat=3NCUS... ・Programming Techniques to Make Excel VBA Development Super Efficient - Development Tips to Eliminate Wasteful Work [Yuji Fukami] https://px.a8.net/svt/ejp?a8mat=3NCUS...

  • vidoe Comments
Trend Videos
24:52
I hate beans, but they keep telling me to eat bean rice. Slow-aging diet!
일주어터
332,768 views   2 days ago
7:16
Guys I'm breaking up
숏박스
2,793,146 views   5 days ago
11:16
I gave birth [SKCouple]
소근커플 S.K.Couple
540,015 views   3 days ago
10:48
Voluntary fishing grounds
짧은대본 ShortPaper
741,469 views   4 days ago
46:41
[Ep.22] (Real situation) What Kim Sook wanted more than traveling the world ㅣ Three blind dates dedicated to Kim Soo-yong [Jo Dong-a-ri Episode 22]
조동아리
686,512 views   5 days ago
58:05
Jung Joon-ho Shin Hyun-joon {Salty Brother} EP. 75 Entertainment Bromance Shin Hyun-joon x Jung Joon-ho's Runaway Locomotive-level 🚆 Exposure. Today is full of great revelations and laughter! 👂 Are you ready to get ready to burst into laughter OK?😂
짠한형 신동엽
1,520,141 views   2 days ago
10:48
Voluntary fishing grounds
짧은대본 ShortPaper
741,469 views   4 days ago
5:30
Jeon Yu Jin - Prayer [Immortal Songs 2 Singing the Legend/Immortal Songs 2] KBS 250111 Broadcast
KBS 레전드 케이팝
443,079 views   4 days ago
4:09
BOYNEXTDOOR (보이네스트도어) 'Today Only I LOVE YOU' Official MV
HYBE LABELS
32,073,962 views   9 days ago
3:29
Donation, is this okay?
충주시
358,975 views   1 day ago
24:19
Why are more realistic men like this part 2.
곰민영
241,103 views   2 days ago
25:02
A night in the freezing desert of Mongolia (2)
곽튜브
908,952 views   2 days ago
4:46
MarkTop's first ever live appearance certification!! Starting Child +10 keys received and went crazy until he fell in love
잠골버스
272,437 views   4 days ago
15:52
Tender 4.5kg LA Galbijjim that is highly praised by guests🥇 Anyone can make it!
딸을 위한 레시피 Recipes for daughters
485,208 views   4 days ago
15:28
[Full-time] From grilled eel to mom's lunch box, eating in the waiting room of Music Core Lalal MBC250111 broadcast
픽잇 :Pick it
332,001 views   1 day ago
2:36
[Special Preview] "A knife mark on the magistrate's face..." Yoon Ji-hye's meaningful question to Im Ji-yeon..! 〈Madam Ok's Story〉 to be aired on 1/18 (Sat) at 10:30 PM!
JTBC Drama
662,586 views   1 day ago
17:10
Hong Jin-kyung, Jang Do-yeon, Lee Su-ji! What are the secrets of these dating experts to seducing men without being noticed? (A handsome man appears)
공부왕찐천재 홍진경
615,073 views   2 days ago
11:01
🔥 Let's go for the second one🔥 (feat. Immingout👶🏻)
오늘의 샛별이
146,153 views   14 hours ago
10:14
If you get angry, you get 1 million won! A challenge where you have to put up with your wife cheating on you no matter what. LOL
보물섬
834,829 views   1 day ago
17:10
Hong Jin-kyung, Jang Do-yeon, Lee Su-ji! What are the secrets of these dating experts to seducing men without being noticed? (A handsome man appears)
공부왕찐천재 홍진경
615,073 views   2 days ago
16:33
Let's all gather in Animal Crossing and play the squid game! Kekekekekeke
아오니 AONI
498,263 views   4 days ago
22:08
The cold of death, surviving in the frozen desert with only plastic
야만스러운
262,516 views   2 days ago
7:16
Guys I'm breaking up
숏박스
2,793,146 views   5 days ago
36:19
Song Hye Kyo's vlog, not mine...
걍밍경
4,104,270 views   5 days ago
2:47
Boo Seok Soon (SEVENTEEN) 'Jeans' Official MV
HYBE LABELS
19,733,850 views   7 days ago
6:05
Irreplaceable actor Lee Soon-jae, 2024 KBS Drama Awards Grand Prize Winner! [2024 KBS Drama Awards] KBS 250111 Broadcast
KBS Drama
1,824,586 views   4 days ago
24:22
Poor parents hide their daughter-in-law's home for 16 years and never tell anyone, and the first time she sees her mother-in-law's tears after walking through the remote mountains to her parents' home Multicultural mother-in-law and daughter-in-law's story Algoism
EBSCulture (EBS 교양)
579,429 views   2 days ago
5:25
Last Stardust - Aimer / COVER by LILPA
릴파 lilpa
455,247 views   4 days ago
22:16
A suspicious country that is more Korean than Korea - Mongolia (1)
곽튜브
1,527,418 views   9 days ago
11:16
I gave birth [SKCouple]
소근커플 S.K.Couple
540,015 views   3 days ago
28:30
London Curry Tour: The Best British Food, Better Than India
육식맨 YOOXICMAN
511,151 views   2 days ago
18:01
🎉Park Chae-yu, a younger sibling is born👼🏻🎉 (New Year, Moon-sen with dad)
혜진쓰 Hyejin's
1,207,096 views   4 days ago
Google AdSense
336 x 280
Up Next
34:45
UNCHARTED: DRAKE'S FORTUNE Full Story
Nerd All Stars
22,895 views
2 years ago
42:38
RESIDENT EVIL 0 (Zero) Full Story
Nerd All Stars
50,774 views
2 years ago
17:37
EVERYTHING WRONG with UNCHARTED: OFF THE MAP
Primeira Fila
201,448 views
2 years ago
2:45:35
Dissecting THE LAST OF US Creation, Narrative and Influence
Blader Koyotte
2,521,493 views
2 years ago
40:37
BATMAN: WHITE KNIGHT - Complete Story
Nerd All Stars
158,383 views
5 years ago
19:14
THE REAL TREASURE YOU FORGOT!
bulletO
55,059 views
5 months ago
44:14
UNCHARTED SAGA: Is It Worth Playing or Not?
Zangado
655,290 views
8 years ago
29:04
I PLATINUMIZED Uncharted 1 just to HUMILIATE A FOREIGN
Neit Dreik
186,954 views
7 months ago
16:57
Why is the entire internet going down now? Mikhail Klimarev
The Breakfast Show
116,830 views
12 hours ago
1:17:01
The Punisher: Marvel's brutal and controversial PS2 game
Mansas
42,214 views
3 days ago
52:47
RESIDENT EVIL 2: REMAKE Full Story
Nerd All Stars
77,503 views
4 years ago
50:36
THE LAST OF US - Full Story
Nerd All Stars
72,206 views
4 years ago
13:29
UNCHARTED'S INCREDIBLE EVOLUTION
Fiaspo
214,296 views
2 years ago
44:19
RESIDENT EVIL 1: REMAKE Full Story
Nerd All Stars
95,454 views
2 years ago
1:30:57
THE UNFORGIVABLE CRIME AGAINST DAYS GONE
O Meu Canal de Games
455,138 views
7 months ago
10:57
A Treasure Called UNCHARTED
Lofailou
40,692 views
3 months ago
40:09
Spoiler Session - The Story of Uncharted: Drake's Fortune
Sidão do Game
186,888 views
8 years ago
34:48
Awesome Games That Aren't for Everyone
Pão de Mel
66,310 views
1 month ago
20:10
I PLATINUMIZED THE GAME THAT MADE ME HATE THE HUMAN RACE!!!
Eu Sou Mark
240,463 views
5 months ago
32:55
GOD OF WAR (2005) Full Story
Nerd All Stars
42,156 views
2 years ago
25:56
I tried to guide the sea bass beginner, Mukogo-kun.
シーバスTAGチャンネル：田口知宏
13,030 views
3 years ago
30:07
Aiming for the Karasu sea bass that go crazy for inago [PERFECT JOURNEY] VOL.13
fimoTV
53,003 views
4 years ago
17:03
Deploying a sea bass game focusing on top fishing at Lake Hinuma 1/2 "Seabass Journey 21 Masanori Muraoka x Lake Hinuma, Ibaraki Prefecture" Intro ver. [Fishing Vision] Part 1
釣りビジョン -Fishing Vision Japan-
17,895 views
3 months ago
26:28
[Boil Festival] I often hear that sea bass that depend on the annual haku (young mullet) boils all over Japan do not bite at all. It is worth seeing the haku catch in Lake Hinuma, one of the most mullet-dependent areas in Japan!
2011LONGIN
79,046 views
4 years ago
28:26
This was my last Shimabara fishing trip of the year. On the day, I moved from spot to spot and enjoyed fighting with the sea bass.
ナイスフィッシング
947 views
2 weeks ago
19:45
I cast a lure at a school of 60cm fish attacking a fish... [Ikehara Dam]
秦拓馬☆俺達。チャンネル
367,773 views
1 year ago
18:12
Can you catch sea bass in a scorching hot day game at Hakone? I tried it.
シーバスTAGチャンネル：田口知宏
12,139 views
4 years ago
33:17
Day game sea bass fishing using situational judgment and lure rotation. "One week fishing life #5"
RAD FISHING/高橋優介
152,243 views
2 years ago
20:23
It's October, but the day game at Hakone Sea Bass is very tough... A deep confusion
シーバスTAGチャンネル：田口知宏
15,829 views
4 years ago
25:21
[Targeting sea bass eating sweetfish] Autumn river sea bass in Niigata
fimoTV
54,857 views
4 years ago
17:33
Team LONGIN is on the go! Niigata expedition. In midsummer, they will tackle the rivers with young sweetfish patterns using a sinking pencil! Even in day games, they will just reel in the Levin! ?
2011LONGIN
29,537 views
1 year ago
20:32
I went fishing at Hakone with a channel viewer who was trying it for the first time.
ときどき釣りちゃんねる
30,888 views
3 years ago
31:14
SUPER BIG CATCH GAME A meter-long sea bass I encountered in Kumamoto.
ima | AMS Design co., ltd.
128,325 views
2 years ago
26:09
I tried fishing for sea bass with a 75mm Jinpen
シーバスTAGチャンネル：田口知宏
21,334 views
4 years ago
22:48
[Onga River Estuary Barrage! Wide Open! Ranker Chance!] Sea Bass Estuary Fishing @251
釣りTube
2,298 views
5 months ago
25:13
The bottom is a treasure trove of sea bass! How to tackle low activity [Bottom drift]
BlueBlueFishing ～ブルーブルー株式会社～
205,746 views
4 years ago
54:06
[No night games. Aiming for sea bass only in day games] A Shiny Time -Vol 5- Akita Yoneshiro River Edition [Takeyuki Kubota]
fimoTV
116,058 views
1 year ago
16:57
Why is the entire internet going down now? Mikhail Klimarev
The Breakfast Show
116,830 views
12 hours ago
21:17
ATV.37 [Edo Bachi] RED Nakamura ~ RED Master's Tokyo Bay Bachi Escape Game
apiatv
38,151 views
4 years ago
19:02
The results of a day of lure fishing in the mecca of sea bass [Ibaraki Prefecture]
いばんちゅTV
31,471 views
1 year ago
Google AdSense
336 x 280

fetery.com. Copyright 2024