I almost worked hard on Excel! 4. Crawling with Google Sheet's Import Brothers!

16,946 views

중년코딩

Published on Dec 4, 2019
About :

This video is long! Play at 1.5x speed is a must!! But it still takes everyone 20 minutes to get to work! Let's invest 20 minutes and get 20 years of comfort!! I didn't even put music in so you can focus!! ★Stop working overtime with Excel and get off work on time with Google Sheets! Tips on Excel and Google Sheets taught by the world's laziest 20-year accountant! Learn the differences between Excel and Google Sheets and learn how to automate inefficient Excel work with Google Sheets. The purpose of this lecture is to make your work with Excel easier and lazier, and ultimately get home faster. Because we're all lazy. Let's crawl Naver news, exchange rates, stock prices, and real estate transaction data with Google Sheet's Import siblings, Importxml, Importhtml, and the world's most powerful GoogleFinance function! ★This lecture consists of a total of 7 chapters as follows. Chapter 0. Prove that Google Sheets is better than Excel in 5 minutes! Chapter 1. Maintain the latest source with IMPORTRANGE Chapter 2. Let's get rid of copy and paste with ARRAYFORMULA and arrays. Chapter 3-1. Let's use Google Sheets like a DB part1_Creating an array Chapter 3-2. Let's use Google Sheets like a DB part2_Filter function Chapter 3-3. Let's use Google Sheets like a DB part3_Query function Chapter 4. IMPORT brothers that bring in external data ← Here, now! Chapter 5. Creating a questionnaire with filled values ​​Chapter 6. Asking Google to do things with Apps Script Chapter 7. Tips ★Please refer to the link below for example files. (You need a Gmail account.) https://docs.google.com/spreadsheets/... ★The entire lecture is also posted on the Notion page. https://www.notion.so/3ca983ad90b94e2... ★If the lecture was helpful, please like and subscribe! Please leave your opinions in the comments and I will actively reflect them. The goal is to post one lecture per week. #Excel #ExcelBasics #ExcelCourse #ExcelLecture #ExcelBeginner #ExcelFunctions #ExcelMacro #ExcelSummary #ExcelExpert #CreatingExcelTables #ExcelFormulas #ExcelPractice #ExcelPivot #Accounting #Accountant #GoogleSpreadsheets #GoogleSheets #HowToUseGoogleSheets #GoogleSheets #Spreadsheets

  • vidoe Comments
Trend Videos
37:54
[SUB] Excuse me, but would you please give me your passport? [I don't have anything] EP.32 #Lee Young-ji #Kentaro
차린건 쥐뿔도 없지만
6,431,134 views   11 days ago
17:49
DAY6 fan meeting was held on KakaoTalk?! DAY6 did a challenge show for My Day even though there was no challenge to return🍀ㅣFantalk EP.1ㅣDAY6
카카오
256,901 views   1 day ago
21:57
The level of Neapolitan Matpia food evaluated by Italian legends ㄷㄷㄷ Is this really how Italians react???
슛포러브
3,088,852 views   2 days ago
14:31
Cherry asked me to send her to a Korean kindergarten… Why is she suddenly doing that?
올리버쌤
586,528 views   4 days ago
8:45
💍 We're getting married..! With 5 years of memories ❤️
담다미담
1,259,453 views   6 days ago
27:12
[Eating Vlog #103] The season of noodles has finally come🤤♨️But now with a period binge...ㅎ Wang Galbitang + Meat Wang Mandu, Yogurt World, Dubai Chapssaltteok, Cheese Stir-fried Noodles + Gochubasasak, Mom's Bread, Mala Tang + Cream Shrimp
살빼조DietJo
298,001 views   1 day ago
58:52
The Return of Lethal Company
이도원
625,232 views   7 days ago
24:57
2 hours on the plane VS 17 hours lying down ⎪🇮🇩Indonesia 2
원지의하루
671,801 views   7 days ago
28:10
Davichi, who lived in a car for a month during the event
걍밍경
823,873 views   2 days ago
14:30
Just looking at it makes my mouth water💚 Taeyomi came to visit my house👶 [Oh Eun-young's Bucket List]
오은영의 버킷리스트
1,042,059 views   1 day ago
3:54
aespa (에스파) - Whiplash Show! MusicCore MBC241026 broadcast
MBCkpop
1,679,564 views   3 days ago
3:35
ILLIT (아이일릿) 'Cherish (My Love)' Official MV
HYBE LABELS
19,564,668 views   8 days ago
4:04
aespa (에스파) – Whiplash @인기가요 inkigayo 20241027
SBSKPOP X INKIGAYO
1,054,578 views   2 days ago
14:30
Just looking at it makes my mouth water💚 Taeyomi came to visit my house👶 [Oh Eun-young's Bucket List]
오은영의 버킷리스트
1,042,059 views   1 day ago
14:30
Just looking at it makes my mouth water💚 Taeyomi came to visit my house👶 [Oh Eun-young's Bucket List]
오은영의 버킷리스트
1,042,059 views   1 day ago
11:44
[I'm SOLO LIVE] 22nd season final couple!! Is it currently in progress??
촌장엔터테인먼트TV
755,018 views   5 days ago
3:11
aespa 'Whiplash' MV
SMTOWN
47,371,879 views   8 days ago
20:36
[Samsung vs KIA] Today, 2024. If you were to express this moment 10.28 KBO Moment KS Game 5 2024 KBO Postseason
KBO
242,266 views   1 day ago
24:57
2 hours on the plane VS 17 hours lying down ⎪🇮🇩Indonesia 2
원지의하루
671,801 views   7 days ago
9:11
Love alcohol problem
짧은대본 ShortPaper
532,404 views   3 days ago
41:59
Sicilian Taste Tour: One City, One Food, A New Concept Stamp-Cracking Food Trip (Google Rating 4.5+ Only)
육식맨 YOOXICMAN
486,126 views   5 days ago
8:45
💍 We're getting married..! With 5 years of memories ❤️
담다미담
1,259,453 views   6 days ago
1:07:33
Ears and stomach will burst, 4 meals a day, Macau food tour 【Macau】
빠니보틀 Pani Bottle
966,709 views   1 day ago
9:11
Love alcohol problem
짧은대본 ShortPaper
532,404 views   3 days ago
21:39
FC Spear VS ShieldUTD Highlights [2024 Nexon Icon Match]
MBC스포츠탐험대
1,529,561 views   9 days ago
21:13
Master Jang Young-ran, Actress Lee Seung-yeon, Yeonhui-dong Housewarming (Entertainment Behind the Scenes)
A급 장영란
702,923 views   6 days ago
40:30
[Ep.11] Jung Hyung-don's intuition on the unreleased footage from the filming set Even the production staff is curious enough to go crazy... [Jo Dong-A-Ri Episode 11]
조동아리
508,871 views   4 days ago
15:42
🇯🇵 Japanese Real Estate 1963 Tokyo Apartment 130 Million Won Domestic Room Tour 🔨 Interior 35 Million Won End
정세월드
300,073 views   4 days ago
58:52
The Return of Lethal Company
이도원
625,232 views   7 days ago
2:26
[TAKE#B 4K] KISS OF LIFE - Igloo
GENIE MUSIC
2,476,433 views   8 days ago
14:31
Cherry asked me to send her to a Korean kindergarten… Why is she suddenly doing that?
올리버쌤
586,528 views   4 days ago
3:54
aespa (에스파) - Whiplash Show! MusicCore MBC241026 broadcast
MBCkpop
1,679,564 views   3 days ago
Google AdSense
336 x 280
Up Next
31:16
#M/013 - Lock drama off Amsterdam - Hectic off Ijmuiden
SY Bruty
52,572 views
1 month ago
20:36
This is how much boat you get for 1000€ (BOAT TOUR)
annaundmalin
33,178 views
3 weeks ago
17:31
Sailing around Sweden in 3 months
Janik May
23,935 views
1 year ago
22:17
Is that it for SAILING? Our honest answers Karl Ocean Ep. 79
Karl Ocean
8,626 views
2 days ago
43:24
We sail around southern Sweden via the Göta Canal
Claus Gottschall
24,412 views
1 month ago
36:44
#117_we have to drop Mayday in the middle of the Pacific T12-T24 SY MariaNoa
Sailing MariaNoa
30,381 views
3 months ago
23:05
Sailing to Gotland. Two weeks sailing holiday on the Baltic Sea.
SY ORJA
10,588 views
10 months ago
15:10
I BET NO ONE expected this! - This is my ace up my sleeve
Segeljungs
17,728 views
2 days ago
24:59
#80// SAILING from Tonga to NEW ZEALAND
SailingManatee
57,597 views
10 months ago
16:05
EP #01- Midsummer in Sweden - from Greifswald to Rönne - Sailing on the Baltic Sea 2022
Sailing SY MarYSol
15,989 views
1 year ago
28:07
Repairing a sailboat instead of sailing (We fix our ship)
annaundmalin
29,735 views
2 days ago
13:57
Long-distance yacht made of aluminum: Hutting 46 - the powerhouse from Makkum
YACHT tv
63,305 views
4 months ago
27:13
STORM on Ibiza: THIS will be a lesson for us! 🌩️ I Karl Ocean Ep. 68
Karl Ocean
29,728 views
3 months ago
20:45
We sail to Denmark
Blue Horizon
125,016 views
1 year ago
34:57
Mooring to the rocks in Swedish archipelago, easy like this.
Mike Peuker
8,689 views
2 weeks ago
34:52
A Sailing Trip into Old Times - Part 1
Peter Thiemt
11,723 views
5 months ago
36:25
On 23 feet around the Baltic Sea (fog, storm, Russian warships and tornado)
Johannes Schoch
34,383 views
1 year ago
29:29
The Great Male Refusal and the Fashion Revolution
Julia Bolchakova
515,884 views
1 year ago
29:31
Alfred Nobel and his prize
Julia Bolchakova
633,067 views
10 months ago
37:36
Where did these actors go?
Звезды и интриги
95,998 views
4 months ago
14:52
BEAUTIFUL OTERO: WHAT IS IT LIKE TO BE A LUXURIOUS PARISIAN COURTESAN?
Коллекция Заблуждений
224,916 views
3 years ago
13:04
The Secret of the Great Watchmaker! How Breguet Invented the TOURBILLON! The History of the Breguet Brand
Watch Investor
135,581 views
2 weeks ago
27:02
Kate Warne, the world's first female detective, saved President Lincoln
Julia Bolchakova
354,076 views
2 years ago
31:54
Zazel and her incredible trick
Julia Bolchakova
196,333 views
7 months ago
35:00
The True Story of Dr. Snow and the Broad Street Column
Julia Bolchakova
297,284 views
1 year ago
25:06
The life of the famous 19th century courtesan and adventurer Lola Montez, which is cooler than a gripping TV series
Коллекция Заблуждений
560,468 views
3 years ago
1:11:41
BOURBON. Even the Habsburgs feared this dynasty FIBE
Файб
1,862,753 views
2 months ago
33:41
Princess Tarakanova: history and legend
Julia Bolchakova
762,589 views
1 year ago
28:19
The Life of a Parisian Courtesan of the Second Empire and the Belle Epoque
Julia Bolchakova
513,007 views
1 year ago
30:21
The Gunpowder Plot in History and Culture
Julia Bolchakova
220,828 views
11 months ago
1:25:47
Princess Diana / Queen of Human Hearts / Personalities / MINAEV
МИНАЕВ LIVE
3,720,877 views
1 year ago
34:40
The world history of coffee, coffee houses and the people who sit in them
Julia Bolchakova
566,462 views
1 year ago
31:41
The Fatal Triangle: White, Nesbit and Thaw
Julia Bolchakova
256,336 views
1 year ago
30:27
Divorce and Annulment in History
Julia Bolchakova
238,594 views
8 months ago
32:02
The Life and Work of the Portraitist of Kings Elisabeth Vigee-Lebrun
Julia Bolchakova
233,450 views
1 year ago
27:20
The Fantastic and Real Destiny of Princess Karabu
Julia Bolchakova
301,822 views
10 months ago
Google AdSense
336 x 280

fetery.com. Copyright 2024