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

Trend Videos
58:52
625,232 views   7 days ago
3:11
47,371,879 views   8 days ago
9:11
532,404 views   3 days ago
9:11
532,404 views   3 days ago
58:52
625,232 views   7 days ago
2:26
2,476,433 views   8 days ago
Google AdSense
336 x 280
Up Next
31:16
20:36
annaundmalin
33,178 views
3 weeks ago
17:31
Janik May
23,935 views
1 year ago
22:17
43:24
Claus Gottschall
24,412 views
1 month ago
36:44
23:05
15:10
24:59
SailingManatee
57,597 views
10 months ago
28:07
annaundmalin
29,735 views
2 days ago
20:45
Blue Horizon
125,016 views
1 year ago
34:57
34:52
Peter Thiemt
11,723 views
5 months ago
29:29
Julia Bolchakova
515,884 views
1 year ago
29:31
Julia Bolchakova
633,067 views
10 months ago
37:36
Звезды и интриги
95,998 views
4 months ago
14:52
Коллекция Заблуждений
224,916 views
3 years ago
27:02
31:54
Julia Bolchakova
196,333 views
7 months ago
35:00
Julia Bolchakova
297,284 views
1 year ago
1:11:41
Файб
1,862,753 views
2 months ago
33:41
Julia Bolchakova
762,589 views
1 year ago
28:19
30:21
Julia Bolchakova
220,828 views
11 months ago
1:25:47
МИНАЕВ LIVE
3,720,877 views
1 year ago
34:40
31:41
Julia Bolchakova
256,336 views
1 year ago
30:27
Julia Bolchakova
238,594 views
8 months ago
32:02
27:20
Julia Bolchakova
301,822 views
10 months ago
Google AdSense
336 x 280

fetery.com. Copyright 2024