<![CDATA[
<p>1. 순위를 구하는 RANK 함수 사용법</p><div class="figure-video" data-ke-type="video" data-video-url="https://kakaotv.daum.net/embed/player/cliplink/rvz4m23byfuca5l519f9gv4t0@my?service=daum_cafe" data-video-host="kakaotv" data-video-play-service="daum_cafe" data-video-width="712" data-video-height="400" data-ke-style="alignCenter" data-video-thumbnail="https://img1.daumcdn.net/thumb/S712x400/?fname=https%3A%2F%2Fthumb.kakaocdn.net%2Fdna%2Fkamp%2Fsource%2Frvz4m23byfuca5l519f9gv4t0%2Fthumbs%2F2.jpg%3Fcredential%3DTuMuFGKUIcirOSjFzOpncbomGFEIdZWK%26expires%3D33159419646%26signature%3DW8GZopGy2BrZ%252FFJJWBqHc4R3XI8%253D" data-ke-mobile-mobileStyle="widthFull" data-video-origin-width="712" data-video-origin-height="400"><iframe src="https://kakaotv.daum.net/embed/player/cliplink/rvz4m23byfuca5l519f9gv4t0@my?service=daum_cafe&ptoken=v2_95e28426380d2606d1b7012135a9487c7516258e6954532ae37b5a27baf684258c65bdbe488a54a4f0964a6493fc03a41a45dd63962ee2213edc1f3ecd" width="712" height="400" frameborder="0" scrolling="no" allowfullscreen="" allow="encrypted-media"></iframe><div class="figcaption"></div></div><p>실습파일</p><div class="figure-file" data-ke-type="file" data-file-src="https://t1.daumcdn.net/cafeattach/1Ygzu/f199c7e8630cb8db899c45bd7fa7971130968022?download" data-file-name="6주차0201_순위를 구하는 RANK 함수 사용법.xlsx" data-file-size="14781" data-mimetype="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" data-ke-align="alignCenter"><a href='javascript:fileFilterViewer("https://t1.daumcdn.net/cafeattach/1Ygzu/f199c7e8630cb8db899c45bd7fa7971130968022?download", "/cafeattach/1Ygzu/f199c7e8630cb8db899c45bd7fa7971130968022", "6주차0201_순위를 구하는 RANK 함수 사용법.xlsx", "grpid%3D1Ygzu%26fldid%3DB4Rk%26dataid%3D15%26fileid%3D1%26regdt%3D20201012225702&url=https%3A%2F%2Ft1.daumcdn.net%2Fcafeattach%2F1Ygzu%2Ff199c7e8630cb8db899c45bd7fa7971130968022")'><div class="image"></div><div class="desc"><div class="filename"><span class="name">6주차0201_순위를 구하는 RANK 함수 사용법</span><span class="type">.xlsx</span></div><div class="size">14.43KB</div></div></a></div><p> </p><p>02. COUNT, COUNTA, COUNTBLANK 함수로 개수, 건수, 인원수 구하기</p><div class="figure-video" data-ke-type="video" data-video-url="https://kakaotv.daum.net/embed/player/cliplink/rv7u22rht1z8udejn38fpxgmq@my?service=daum_cafe" data-video-host="kakaotv" data-video-play-service="daum_cafe" data-video-width="712" data-video-height="400" data-ke-style="alignCenter" data-video-thumbnail="https://img1.daumcdn.net/thumb/S712x400/?fname=https%3A%2F%2Fthumb.kakaocdn.net%2Fdna%2Fkamp%2Fsource%2Frv7u22rht1z8udejn38fpxgmq%2Fthumbs%2F2.jpg%3Fcredential%3DTuMuFGKUIcirOSjFzOpncbomGFEIdZWK%26expires%3D33159419695%26signature%3D8ADuXqEWiBoZRJYwDdEwFCAYqic%253D" data-ke-mobile-mobileStyle="widthFull" data-video-origin-width="712" data-video-origin-height="400"><iframe src="https://kakaotv.daum.net/embed/player/cliplink/rv7u22rht1z8udejn38fpxgmq@my?service=daum_cafe&ptoken=v2_a1d6f308901a0fbcb50358765e8be5d8fd676833879519708206fcf731c7b03760aba247009120adee0941eda53bed5fc8cccd5c52e2f65f77101a7c9e" width="712" height="400" frameborder="0" scrolling="no" allowfullscreen="" allow="encrypted-media"></iframe><div class="figcaption"></div></div><p>실습파일</p><div class="figure-file" data-ke-type="file" data-file-src="https://t1.daumcdn.net/cafeattach/1Ygzu/bfec268b2d27b433729e91e204d0c2af70a85e84?download" data-file-name="6주차0202_COUNT, COUNTA, COUNTBLANK 함수로 개수, 건수, 인원수 구하기.xlsx" data-file-size="15048" data-mimetype="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" data-ke-align="alignCenter"><a href='javascript:fileFilterViewer("https://t1.daumcdn.net/cafeattach/1Ygzu/bfec268b2d27b433729e91e204d0c2af70a85e84?download", "/cafeattach/1Ygzu/bfec268b2d27b433729e91e204d0c2af70a85e84", "6주차0202_COUNT, COUNTA, COUNTBLANK 함수로 개수, 건수, 인원수 구하기.xlsx", "grpid%3D1Ygzu%26fldid%3DB4Rk%26dataid%3D15%26fileid%3D2%26regdt%3D20201012225702&url=https%3A%2F%2Ft1.daumcdn.net%2Fcafeattach%2F1Ygzu%2Fbfec268b2d27b433729e91e204d0c2af70a85e84")'><div class="image"></div><div class="desc"><div class="filename"><span class="name">6주차0202_COUNT, COUNTA, COUNTBLANK 함수로 개수, 건수, 인원수 구하기</span><span class="type">.xlsx</span></div><div class="size">14.70KB</div></div></a></div><p> </p><p>03. COUNTIF 함수를 사용하여 조건에 일치하는 인원수 구하기, 집계표 작성</p><div class="figure-video" data-ke-type="video" data-video-url="https://kakaotv.daum.net/embed/player/cliplink/rv2bum7dv9fy9rdcrsisxx1z3@my?service=daum_cafe" data-video-host="kakaotv" data-video-play-service="daum_cafe" data-video-width="712" data-video-height="400" data-ke-style="alignCenter" data-video-thumbnail="https://img1.daumcdn.net/thumb/S712x400/?fname=https%3A%2F%2Fthumb.kakaocdn.net%2Fdna%2Fkamp%2Fsource%2Frv2bum7dv9fy9rdcrsisxx1z3%2Fthumbs%2F2.jpg%3Fcredential%3DTuMuFGKUIcirOSjFzOpncbomGFEIdZWK%26expires%3D33159419758%26signature%3D3LG5KC8lwVPOXiaw5ca5UVcvVqc%253D" data-ke-mobile-mobileStyle="widthFull" data-video-origin-width="712" data-video-origin-height="400"><iframe src="https://kakaotv.daum.net/embed/player/cliplink/rv2bum7dv9fy9rdcrsisxx1z3@my?service=daum_cafe&ptoken=v2_c55bfa64b65362ff3b54393913c6f07a722ea4a7a4e96f00be982723bde4101bee6177ea834afbce79d92a78d7aa1b3c9d1368f8de96fdb168106309cd" width="712" height="400" frameborder="0" scrolling="no" allowfullscreen="" allow="encrypted-media"></iframe><div class="figcaption"></div></div><p>실습파일</p><div class="figure-file" data-ke-type="file" data-file-src="https://t1.daumcdn.net/cafeattach/1Ygzu/4a08df68103d16b12ebbb1be400590b978af2043?download" data-file-name="6주차0203_COUNTIF 함수를 사용하여 조건에 일치하는 인원수 구하기, 집계표 작성.xlsx" data-file-size="15322" data-mimetype="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" data-ke-align="alignCenter"><a href='javascript:fileFilterViewer("https://t1.daumcdn.net/cafeattach/1Ygzu/4a08df68103d16b12ebbb1be400590b978af2043?download", "/cafeattach/1Ygzu/4a08df68103d16b12ebbb1be400590b978af2043", "6주차0203_COUNTIF 함수를 사용하여 조건에 일치하는 인원수 구하기, 집계표 작성.xlsx", "grpid%3D1Ygzu%26fldid%3DB4Rk%26dataid%3D15%26fileid%3D3%26regdt%3D20201012225702&url=https%3A%2F%2Ft1.daumcdn.net%2Fcafeattach%2F1Ygzu%2F4a08df68103d16b12ebbb1be400590b978af2043")'><div class="image"></div><div class="desc"><div class="filename"><span class="name">6주차0203_COUNTIF 함수를 사용하여 조건에 일치하는 인원수 구하기, 집계표 작성</span><span class="type">.xlsx</span></div><div class="size">14.96KB</div></div></a></div><p> </p><p> </p><p>04. COUNTIF vs COUNTIFS 함수</p><div class="figure-video" data-ke-type="video" data-video-url="https://kakaotv.daum.net/embed/player/cliplink/rvpbju68nk9i1zngcuf3cxi2e@my?service=daum_cafe" data-video-host="kakaotv" data-video-play-service="daum_cafe" data-video-width="712" data-video-height="400" data-ke-style="alignCenter" data-video-thumbnail="https://img1.daumcdn.net/thumb/S712x400/?fname=https%3A%2F%2Fthumb.kakaocdn.net%2Fdna%2Fkamp%2Fsource%2Frvpbju68nk9i1zngcuf3cxi2e%2Fthumbs%2F2.jpg%3Fcredential%3DTuMuFGKUIcirOSjFzOpncbomGFEIdZWK%26expires%3D33159419804%26signature%3Dd6G41kjliN2IeNhFDNpOc2azhg0%253D" data-ke-mobile-mobileStyle="widthFull" data-video-origin-width="712" data-video-origin-height="400"><iframe src="https://kakaotv.daum.net/embed/player/cliplink/rvpbju68nk9i1zngcuf3cxi2e@my?service=daum_cafe&ptoken=v2_6c4eb584ef3d3d92fa85e3fddf7695d2f4679588f6b51c5076e06be695e5a5f5281e3381dcee85659c28fee541b2487f031cf8d621827e72ea685cc7ef" width="712" height="400" frameborder="0" scrolling="no" allowfullscreen="" allow="encrypted-media"></iframe><div class="figcaption"></div></div><p>실습파일</p><div class="figure-file" data-ke-type="file" data-file-src="https://t1.daumcdn.net/cafeattach/1Ygzu/f238b8430ec4f519af6145857571f80ac3072c5b?download" data-file-name="6주차0204_COUNTIF vs COUNTIFS 함수.xlsx" data-file-size="13086" data-mimetype="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" data-ke-align="alignCenter"><a href='javascript:fileFilterViewer("https://t1.daumcdn.net/cafeattach/1Ygzu/f238b8430ec4f519af6145857571f80ac3072c5b?download", "/cafeattach/1Ygzu/f238b8430ec4f519af6145857571f80ac3072c5b", "6주차0204_COUNTIF vs COUNTIFS 함수.xlsx", "grpid%3D1Ygzu%26fldid%3DB4Rk%26dataid%3D15%26fileid%3D4%26regdt%3D20201012225702&url=https%3A%2F%2Ft1.daumcdn.net%2Fcafeattach%2F1Ygzu%2Ff238b8430ec4f519af6145857571f80ac3072c5b")'><div class="image"></div><div class="desc"><div class="filename"><span class="name">6주차0204_COUNTIF vs COUNTIFS 함수</span><span class="type">.xlsx</span></div><div class="size">12.78KB</div></div></a></div>
<!-- -->
]]>
첫댓글 출석했습니다
출석했습니다
출석했습니다