엑셀 실습

<p>03</p><div class="figure-file" data-ke-type="file" data-file-src="https://t1.daumcdn.net/cafeattach/1ZjpC/fc17ac74be64e5b3582ff9e41e51843fce53d358?download" data-file-name="★피벗테이블.xlsx" data-file-size="82432" data-mimetype="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" data-ke-align="alignCenter"><a href="javascript:checkVirus('grpid%3D1ZjpC%26fldid%3DWmyi%26dataid%3D1%26fileid%3D26%26regdt%3D20251229013740&url=https%3A%2F%2Ft1.daumcdn.net%2Fcafeattach%2F1ZjpC%2Ffc17ac74be64e5b3582ff9e41e51843fce53d358')"><div class="image"></div><div class="desc"><div class="filename"><span class="name">★피벗테이블</span><span class="type">.xlsx</span></div><div class="size">80.50KB</div></div></a></div><div class="figure-file" data-ke-type="file" data-file-src="https://t1.daumcdn.net/cafeattach/1ZjpC/6d21b3c9c87b8506dfdd1dd5517736bfda3a7dde?download" data-file-name="인쇄설정.xlsx" data-file-size="30208" data-mimetype="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" data-ke-align="alignCenter"><a href="javascript:checkVirus('grpid%3D1ZjpC%26fldid%3DWmyi%26dataid%3D1%26fileid%3D25%26regdt%3D20251229013740&url=https%3A%2F%2Ft1.daumcdn.net%2Fcafeattach%2F1ZjpC%2F6d21b3c9c87b8506dfdd1dd5517736bfda3a7dde')"><div class="image"></div><div class="desc"><div class="filename"><span class="name">인쇄설정</span><span class="type">.xlsx</span></div><div class="size">29.50KB</div></div></a></div><div class="figure-file" data-ke-type="file" data-file-src="https://t1.daumcdn.net/cafeattach/1ZjpC/b199f30717c7c7e153de636d0a09f8b7dbfac1bd?download" data-file-name="기타차트.xlsx" data-file-size="105472" data-mimetype="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" data-ke-align="alignCenter"><a href="javascript:checkVirus('grpid%3D1ZjpC%26fldid%3DWmyi%26dataid%3D1%26fileid%3D24%26regdt%3D20251229013740&url=https%3A%2F%2Ft1.daumcdn.net%2Fcafeattach%2F1ZjpC%2Fb199f30717c7c7e153de636d0a09f8b7dbfac1bd')"><div class="image"></div><div class="desc"><div class="filename"><span class="name">기타차트</span><span class="type">.xlsx</span></div><div class="size">103.00KB</div></div></a></div><div class="figure-file" data-ke-type="file" data-file-src="https://t1.daumcdn.net/cafeattach/1ZjpC/051856c416a4e179936b04851676706fb301472d?download" data-file-name="목표값-시나리오.xlsx" data-file-size="39936" data-mimetype="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" data-ke-align="alignCenter"><a href="javascript:checkVirus('grpid%3D1ZjpC%26fldid%3DWmyi%26dataid%3D1%26fileid%3D21%26regdt%3D20251229013740&url=https%3A%2F%2Ft1.daumcdn.net%2Fcafeattach%2F1ZjpC%2F051856c416a4e179936b04851676706fb301472d')"><div class="image"></div><div class="desc"><div class="filename"><span class="name">목표값-시나리오</span><span class="type">.xlsx</span></div><div class="size">39.00KB</div></div></a></div><div class="figure-file" data-ke-type="file" data-file-src="https://t1.daumcdn.net/cafeattach/1ZjpC/26265087662f7f9f933ebf69742905d14765753c?download" data-file-name="★부분합.xlsx" data-file-size="1198080" data-mimetype="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" data-ke-align="alignCenter"><a href="javascript:checkVirus('grpid%3D1ZjpC%26fldid%3DWmyi%26dataid%3D1%26fileid%3D20%26regdt%3D20251229013740&url=https%3A%2F%2Ft1.daumcdn.net%2Fcafeattach%2F1ZjpC%2F26265087662f7f9f933ebf69742905d14765753c')"><div class="image"></div><div class="desc"><div class="filename"><span class="name">★부분합</span><span class="type">.xlsx</span></div><div class="size">1.14MB</div></div></a></div><div class="figure-file" data-ke-type="file" data-file-src="https://t1.daumcdn.net/cafeattach/1ZjpC/60239c96353d6030fc016d0d8b72731dc311129b?download" data-file-name="차트만들기.xlsx" data-file-size="592896" data-mimetype="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" data-ke-align="alignCenter"><a href="javascript:checkVirus('grpid%3D1ZjpC%26fldid%3DWmyi%26dataid%3D1%26fileid%3D19%26regdt%3D20251229013740&url=https%3A%2F%2Ft1.daumcdn.net%2Fcafeattach%2F1ZjpC%2F60239c96353d6030fc016d0d8b72731dc311129b')"><div class="image"></div><div class="desc"><div class="filename"><span class="name">차트만들기</span><span class="type">.xlsx</span></div><div class="size">579.00KB</div></div></a></div><div class="figure-file" data-ke-type="file" data-file-src="https://t1.daumcdn.net/cafeattach/1ZjpC/6bbd7a06087007732f2c7f44a0d7dd68cd176de9?download" data-file-name="기타함수(LARGE-SMALL-MEDIA-MOD-MATCH-INDEX).xlsx" data-file-size="26624" data-mimetype="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" data-ke-align="alignCenter"><a href="javascript:checkVirus('grpid%3D1ZjpC%26fldid%3DWmyi%26dataid%3D1%26fileid%3D18%26regdt%3D20251229013740&url=https%3A%2F%2Ft1.daumcdn.net%2Fcafeattach%2F1ZjpC%2F6bbd7a06087007732f2c7f44a0d7dd68cd176de9')"><div class="image"></div><div class="desc"><div class="filename"><span class="name">기타함수(LARGE-SMALL-MEDIA-MOD-MATCH-INDEX)</span><span class="type">.xlsx</span></div><div class="size">26.00KB</div></div></a></div><div class="figure-file" data-ke-type="file" data-file-src="https://t1.daumcdn.net/cafeattach/1ZjpC/62f98a848bc66b0e45c4bda3007566fb57ae5d35?download" data-file-name="IF함수 (1).xlsx" data-file-size="39424" data-mimetype="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" data-ke-align="alignCenter"><a href="javascript:checkVirus('grpid%3D1ZjpC%26fldid%3DWmyi%26dataid%3D1%26fileid%3D17%26regdt%3D20251229013740&url=https%3A%2F%2Ft1.daumcdn.net%2Fcafeattach%2F1ZjpC%2F62f98a848bc66b0e45c4bda3007566fb57ae5d35')"><div class="image"></div><div class="desc"><div class="filename"><span class="name">IF함수 (1)</span><span class="type">.xlsx</span></div><div class="size">38.50KB</div></div></a></div><div class="figure-file" data-ke-type="file" data-file-src="https://t1.daumcdn.net/cafeattach/1ZjpC/05ca7d257fa9cf91f0e240b66e772a9b55f58da3?download" data-file-name="데이터베이스 함수-ROUND 함수.xlsx" data-file-size="81920" data-mimetype="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" data-ke-align="alignCenter"><a href="javascript:checkVirus('grpid%3D1ZjpC%26fldid%3DWmyi%26dataid%3D1%26fileid%3D16%26regdt%3D20251229013740&url=https%3A%2F%2Ft1.daumcdn.net%2Fcafeattach%2F1ZjpC%2F05ca7d257fa9cf91f0e240b66e772a9b55f58da3')"><div class="image"></div><div class="desc"><div class="filename"><span class="name">데이터베이스 함수-ROUND 함수</span><span class="type">.xlsx</span></div><div class="size">80.00KB</div></div></a></div><div class="figure-file" data-ke-type="file" data-file-src="https://t1.daumcdn.net/cafeattach/1ZjpC/c67fae763b6d17ddf25712cd90a7ef6854e53a71?download" data-file-name="★문제-인기복합기-3월체험행사.xlsx" data-file-size="40960" data-mimetype="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" data-ke-align="alignCenter"><a href="javascript:checkVirus('grpid%3D1ZjpC%26fldid%3DWmyi%26dataid%3D1%26fileid%3D15%26regdt%3D20251229013740&url=https%3A%2F%2Ft1.daumcdn.net%2Fcafeattach%2F1ZjpC%2Fc67fae763b6d17ddf25712cd90a7ef6854e53a71')"><div class="image"></div><div class="desc"><div class="filename"><span class="name">★문제-인기복합기-3월체험행사</span><span class="type">.xlsx</span></div><div class="size">40.00KB</div></div></a></div><div class="figure-file" data-ke-type="file" data-file-src="https://t1.daumcdn.net/cafeattach/1ZjpC/548c4d454952ca4c24b44c8401709d177ed46c3c?download" data-file-name="정렬- 필터.xlsx" data-file-size="31744" data-mimetype="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" data-ke-align="alignCenter"><a href="javascript:checkVirus('grpid%3D1ZjpC%26fldid%3DWmyi%26dataid%3D1%26fileid%3D12%26regdt%3D20251229013740&url=https%3A%2F%2Ft1.daumcdn.net%2Fcafeattach%2F1ZjpC%2F548c4d454952ca4c24b44c8401709d177ed46c3c')"><div class="image"></div><div class="desc"><div class="filename"><span class="name">정렬- 필터</span><span class="type">.xlsx</span></div><div class="size">31.00KB</div></div></a></div><p> </p><div class="figure-file" data-ke-type="file" data-file-src="https://t1.daumcdn.net/cafeattach/1ZjpC/d5046ec3941832dcc55054acfe5a7893e9ba0ff2?download" data-file-name="찾기함수.xlsx" data-file-size="148992" data-mimetype="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" data-ke-align="alignCenter"><a href="javascript:checkVirus('grpid%3D1ZjpC%26fldid%3DWmyi%26dataid%3D1%26fileid%3D14%26regdt%3D20251229013740&url=https%3A%2F%2Ft1.daumcdn.net%2Fcafeattach%2F1ZjpC%2Fd5046ec3941832dcc55054acfe5a7893e9ba0ff2')"><div class="image"></div><div class="desc"><div class="filename"><span class="name">찾기함수</span><span class="type">.xlsx</span></div><div class="size">145.50KB</div></div></a></div><div class="figure-file" data-ke-type="file" data-file-src="https://t1.daumcdn.net/cafeattach/1ZjpC/4d7b8d958728fc48baa82275f7f15691f2d1c190?download" data-file-name="함수(개수및 순위).xlsx" data-file-size="27648" data-mimetype="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" data-ke-align="alignCenter"><a href="javascript:checkVirus('grpid%3D1ZjpC%26fldid%3DWmyi%26dataid%3D1%26fileid%3D11%26regdt%3D20251229013740&url=https%3A%2F%2Ft1.daumcdn.net%2Fcafeattach%2F1ZjpC%2F4d7b8d958728fc48baa82275f7f15691f2d1c190')"><div class="image"></div><div class="desc"><div class="filename"><span class="name">함수(개수및 순위)</span><span class="type">.xlsx</span></div><div class="size">27.00KB</div></div></a></div><div class="figure-file" data-ke-type="file" data-file-src="https://t1.daumcdn.net/cafeattach/1ZjpC/8df75e5b9ac631b9f99c10c2420ee807fc6d0ae9?download" data-file-name="소스1.xlsx" data-file-size="29184" data-mimetype="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" data-ke-align="alignCenter"><a href="javascript:checkVirus('grpid%3D1ZjpC%26fldid%3DWmyi%26dataid%3D1%26fileid%3D10%26regdt%3D20251229013740&url=https%3A%2F%2Ft1.daumcdn.net%2Fcafeattach%2F1ZjpC%2F8df75e5b9ac631b9f99c10c2420ee807fc6d0ae9')"><div class="image"></div><div class="desc"><div class="filename"><span class="name">소스1</span><span class="type">.xlsx</span></div><div class="size">28.50KB</div></div></a></div><div class="figure-file" data-ke-type="file" data-file-src="https://t1.daumcdn.net/cafeattach/1ZjpC/28db9847ee98ae6240d581c1b1707d1e08732943?download" data-file-name="텍스트나누기-합치기.xlsx" data-file-size="288768" data-mimetype="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" data-ke-align="alignCenter"><a href="javascript:checkVirus('grpid%3D1ZjpC%26fldid%3DWmyi%26dataid%3D1%26fileid%3D8%26regdt%3D20251229013740&url=https%3A%2F%2Ft1.daumcdn.net%2Fcafeattach%2F1ZjpC%2F28db9847ee98ae6240d581c1b1707d1e08732943')"><div class="image"></div><div class="desc"><div class="filename"><span class="name">텍스트나누기-합치기</span><span class="type">.xlsx</span></div><div class="size">282.00KB</div></div></a></div><div class="figure-file" data-ke-type="file" data-file-src="https://t1.daumcdn.net/cafeattach/1ZjpC/4415d6989be3ca356fb4638ff2b141b4bf83021a?download" data-file-name="데이터유효성검사-부동산.xlsx" data-file-size="32768" data-mimetype="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" data-ke-align="alignCenter"><a href="javascript:checkVirus('grpid%3D1ZjpC%26fldid%3DWmyi%26dataid%3D1%26fileid%3D9%26regdt%3D20251229013740&url=https%3A%2F%2Ft1.daumcdn.net%2Fcafeattach%2F1ZjpC%2F4415d6989be3ca356fb4638ff2b141b4bf83021a')"><div class="image"></div><div class="desc"><div class="filename"><span class="name">데이터유효성검사-부동산</span><span class="type">.xlsx</span></div><div class="size">32.00KB</div></div></a></div><div class="figure-file" data-ke-type="file" data-file-src="https://t1.daumcdn.net/cafeattach/1ZjpC/aff887d666c5f65a2bf3a9ca9ad26093f7a2fd31?download" data-file-name="문자_날짜함수 (2).xlsx" data-file-size="39936" data-mimetype="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" data-ke-align="alignCenter"><a href="javascript:checkVirus('grpid%3D1ZjpC%26fldid%3DWmyi%26dataid%3D1%26fileid%3D7%26regdt%3D20251229013740&url=https%3A%2F%2Ft1.daumcdn.net%2Fcafeattach%2F1ZjpC%2Faff887d666c5f65a2bf3a9ca9ad26093f7a2fd31')"><div class="image"></div><div class="desc"><div class="filename"><span class="name">문자_날짜함수 (2)</span><span class="type">.xlsx</span></div><div class="size">39.00KB</div></div></a></div><div class="figure-file" data-ke-type="file" data-file-src="https://t1.daumcdn.net/cafeattach/1ZjpC/3f747d94bdfa03ee9783414e8d4c676b2ab96696?download" data-file-name="조건부서식.xlsx" data-file-size="46080" data-mimetype="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" data-ke-align="alignCenter"><a href="javascript:checkVirus('grpid%3D1ZjpC%26fldid%3DWmyi%26dataid%3D1%26fileid%3D6%26regdt%3D20251229013740&url=https%3A%2F%2Ft1.daumcdn.net%2Fcafeattach%2F1ZjpC%2F3f747d94bdfa03ee9783414e8d4c676b2ab96696')"><div class="image"></div><div class="desc"><div class="filename"><span class="name">조건부서식</span><span class="type">.xlsx</span></div><div class="size">45.00KB</div></div></a></div><div class="figure-file" data-ke-type="file" data-file-src="https://t1.daumcdn.net/cafeattach/1ZjpC/1d73e2530319317a30dc08f4c96979eb84aa0f7f?download" data-file-name="수식만들기(월별차량, 비상근무).xlsx" data-file-size="31744" data-mimetype="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" data-ke-align="alignCenter"><a href="javascript:checkVirus('grpid%3D1ZjpC%26fldid%3DWmyi%26dataid%3D1%26fileid%3D5%26regdt%3D20251229013740&url=https%3A%2F%2Ft1.daumcdn.net%2Fcafeattach%2F1ZjpC%2F1d73e2530319317a30dc08f4c96979eb84aa0f7f')"><div class="image"></div><div class="desc"><div class="filename"><span class="name">수식만들기(월별차량, 비상근무)</span><span class="type">.xlsx</span></div><div class="size">31.00KB</div></div></a></div><div class="figure-file" data-ke-type="file" data-file-src="https://t1.daumcdn.net/cafeattach/1ZjpC/b6ffed17909b620aefd0b59307f782e359417339?download" data-file-name="셀선택 및 선택하여 붙여넣기.xlsx" data-file-size="71168" data-mimetype="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" data-ke-align="alignCenter"><a href="javascript:checkVirus('grpid%3D1ZjpC%26fldid%3DWmyi%26dataid%3D1%26fileid%3D4%26regdt%3D20251229013740&url=https%3A%2F%2Ft1.daumcdn.net%2Fcafeattach%2F1ZjpC%2Fb6ffed17909b620aefd0b59307f782e359417339')"><div class="image"></div><div class="desc"><div class="filename"><span class="name">셀선택 및 선택하여 붙여넣기</span><span class="type">.xlsx</span></div><div class="size">69.50KB</div></div></a></div><div class="figure-file" data-ke-type="file" data-file-src="https://t1.daumcdn.net/cafeattach/1ZjpC/213d2ecc735dfc2abe932a3f5a32c39f8236a78d?download" data-file-name="입력및수정.xlsx" data-file-size="31744" data-mimetype="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" data-ke-align="alignCenter"><a href="javascript:checkVirus('grpid%3D1ZjpC%26fldid%3DWmyi%26dataid%3D1%26fileid%3D1%26regdt%3D20251229013740&url=https%3A%2F%2Ft1.daumcdn.net%2Fcafeattach%2F1ZjpC%2F213d2ecc735dfc2abe932a3f5a32c39f8236a78d')"><div class="image"></div><div class="desc"><div class="filename"><span class="name">입력및수정</span><span class="type">.xlsx</span></div><div class="size">31.00KB</div></div></a></div><p> </p><div class="figure-file" data-ke-type="file" data-file-src="https://t1.daumcdn.net/cafeattach/1ZjpC/5bf555db5e84bfbadb21f2a5c2ca59509964d33f?download" data-file-name="셀서식-맞춤.xlsx" data-file-size="64000" data-mimetype="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" data-ke-align="alignCenter"><a href="javascript:checkVirus('grpid%3D1ZjpC%26fldid%3DWmyi%26dataid%3D1%26fileid%3D2%26regdt%3D20251229013740&url=https%3A%2F%2Ft1.daumcdn.net%2Fcafeattach%2F1ZjpC%2F5bf555db5e84bfbadb21f2a5c2ca59509964d33f')"><div class="image"></div><div class="desc"><div class="filename"><span class="name">셀서식-맞춤</span><span class="type">.xlsx</span></div><div class="size">62.50KB</div></div></a></div><div class="figure-file" data-ke-type="file" data-file-src="https://t1.daumcdn.net/cafeattach/1ZjpC/7fbe5eb5e5b13fdb2c4b045c59f23c227e756c07?download" data-file-name="표시형식.xlsx" data-file-size="40448" data-mimetype="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" data-ke-align="alignCenter"><a href="javascript:checkVirus('grpid%3D1ZjpC%26fldid%3DWmyi%26dataid%3D1%26fileid%3D3%26regdt%3D20251229013740&url=https%3A%2F%2Ft1.daumcdn.net%2Fcafeattach%2F1ZjpC%2F7fbe5eb5e5b13fdb2c4b045c59f23c227e756c07')"><div class="image"></div><div class="desc"><div class="filename"><span class="name">표시형식</span><span class="type">.xlsx</span></div><div class="size">39.50KB</div></div></a></div>