Channel Avatar

์šฉ๊ฐ€๋ฆฌ @UC9uMoR8uRb4uUsr38OUBoqA@youtube.com

5.1K subscribers - no pronouns :c

Brian Y

Videos Playlists
Recently Uploaded Popular Oldest
04:39
[1๋ถ„ ์—‘์…€] ์ ˆ๋Œ€์ฐธ์กฐ ์™„๋ฒฝ์ •๋ฆฌ
08:08
[1๋ถ„ ์—‘์…€] ๋Œ€์ถœ์ด์ž ์™„๋ฒฝ์ •๋ฆฌ (#์›๊ธˆ #์›๋ฆฌ๊ธˆ #๋งŒ๊ธฐ์ƒํ™˜)
04:58
[1๋ถ„ ์—‘์…€] ํ”ผ๋ฒ—ํ…Œ์ด๋ธ” ์™„๋ฒฝ ํ•™์Šต
03:27
[1๋ถ„ ์—‘์…€] ์…€์— ์ด๋ฏธ์ง€ ์‚ฝ์ž…ํ•˜๊ธฐ (#๊น”๋”ํ•˜๊ฒŒ #์ •์‚ฌ๊ฐํ˜• #์‰ฝ๊ฒŒ #๋นจ๋ฆฌ)
03:50
[1๋ถ„ ์—‘์…€] ๊ฐœ์ฒด ์‚ฝ์ž…ํ•˜๊ธฐ(#Object)
02:38
[1๋ถ„ ์—‘์…€]๋‹ค๋ฅธ ๋ฐ์ดํ„ฐ ์ฐพ์•„๋‚ด๊ณ  ํ†ต๊ณ„๋‚ด์„ธ์š”
03:22
[1๋ถ„ ์—‘์…€] ์—†๋Š”๋ฐ์ดํ„ฐ ์ฐพ์•„๋‚ด์„ธ์š”(#vlookupํ™œ์šฉ)
05:42
[์‹œ์Šคํ…œ ๋งŒ๋“ค๊ธฐ] ์˜จ๋ผ์ธ์Šคํ† ์–ด ๋งค์ถœํ†ตํ•ฉ ๊ด€๋ฆฌ ์‹œ์Šคํ…œ (#์—‘์…€์˜จ๋ผ์ธ์Šคํ† ์–ด๋งค์ถœ๊ด€๋ฆฌ)
05:26
๋‚ ์งœ๋ฅผ ์š”์ผ, ์›”, ์ฃผ ๋งˆ์Œ๋Œ€๋กœ ๋ณ€๊ฒฝํ•ด๋ณด์„ธ์š” (#์—‘์…€๋‚ ์งœ๋ฅผ์š”์ผ๋กœ)
04:19
[์‹œ์Šคํ…œ ๋งŒ๋“ค๊ธฐ] ์ด๋ฏธ์ง€ ์ž๋™ ๋ถˆ๋Ÿฌ์˜ค๊ธฐ(#์—‘์…€์ด๋ฏธ์ง€์ž๋™ํ™”, #IndexMatch)
08:15
#Index #Match ํ•จ์ˆ˜๋กœ Report ์ž๋™ํ™” ํ•˜์„ธ์š” (#indexmatchlarge, #indexmatch๋‹ค์ค‘์กฐ๊ฑด )
06:16
#์—‘์…€๋‹จ์ถ•ํ‚ค 200% Speed UP *ํ•ต์‹ฌ ๋‹จ์ถ•ํ‚ค ๋ชจ์Œ*
08:31
[์‹œ์Šคํ…œ ๋งŒ๋“ค๊ธฐ] #์žฌ๊ณ ๊ด€๋ฆฌ์‹œ์Šคํ…œ
06:03
๋งค์ถœ 1,2,3์œ„ ๋ถˆ๋Ÿฌ์˜ค๊ธฐ(#Large, #Small)
09:06
์ตœ๊ทผ๋‚ ์งœ ๋งค์ถœ ์ง‘๊ณ„ํ•˜๊ธฐ #RANK, #Large ํ•จ์ˆ˜ ์กฐํ•ฉ. (#Rank ์ˆœ์œ„ ๊ตฌํ•˜๊ธฐ)
06:25
์—‘์…€์—๋Ÿฌ ํ•œ๋ฐฉ์— ์ฒ˜๋ฆฌ. #Iferror ๋กœ ์ผ๊ด„ ์ฒ˜๋ฆฌํ•˜์ž
09:33
๋ฐ์ดํ„ฐ ์ž๋ฅด๊ณ  ๋ถ™ํžˆ๊ณ  ์ž์ฃผ์ž์žฌ๋กœ ํ•ธ๋“ค๋ง ํ•˜๊ธฐ (#Left, #Mid, #Right)
20:42
๋ถ„์„ํ•œ๋‹ค๊ณ  ์‹œ๊ฐ„์“ฐ์ง€ ๋งˆ์„ธ์š” #Sumifs ํ•˜๋‚˜๋ฉด ๋
11:47
#Vlookup ํ•œ๋ฒˆ์— ๋๋‚ด์„ธ์š”
10:45
๊ฐฏ์ˆ˜ ์„ผ๋‹ค๊ณ  ๊ณ ์ƒํ•˜์ง€ ๋งˆ์„ธ์š”. ํ•œ๋ฒˆ์— ์ง‘๊ณ„ํ•˜๊ธฐ #Count #Countif #Countifs
09:33
๊ธฐ์ดˆ์ค‘์— ๊ธฐ์ดˆ #if #sum ํ•จ์ˆ˜. ๊ธฐ์ดˆ๋„ ๋ชจ๋ฅด๊ณ  ๋ถ„์„์„ ํ•˜์‹ ๋‹ค๊ณ ์š”?