<![CDATA[
<p><font color="#0066cc"><span style="font-size: 10pt;"> <span style="font-family: Gungsuh,궁서,serif; font-size: 14pt;"><strong><u><span style="color: rgb(34, 116, 28); font-family: Gulim,굴림,AppleGothic,sans-serif;">강사: 정훈희</span></u></strong></span></span></font></p><p><font color="#0066cc"><span style="font-size: 10pt;"><span style="font-family: Gungsuh,궁서,serif; font-size: 14pt;"><strong><span style="color: rgb(102, 0, 255); font-family: Gulim,굴림,AppleGothic,sans-serif; font-size: 12pt;">===정말 쉬운 엑셀 시리즈===</span></strong></span></span></font></p><p><font color="#0066cc"><span style="font-size: 10pt;"><span style="font-family: Gungsuh,궁서,serif; font-size: 14pt;"><span style="color: rgb(102, 0, 255); font-family: Gulim,굴림,AppleGothic,sans-serif; font-size: 12pt;"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(255, 0, 0);"><span style="font-size: 10pt;"><a class="tx-link" href="https://youtu.be/IoHhxyofQnI" target="_blank" rel="noopener noreferrer"><span style="color: rgb(255, 0, 0);">▶</span><span style="color: rgb(255, 0, 221);">1. 처음시작:</span> <span style="color: rgb(0, 85, 255);">엑셀 초보자가 곡 알아야 할 10가지</span></a></span></span></span></font></span></span></span></font></p><p><font color="#0066cc"><span style="font-size: 10pt;"><span style="font-family: Gungsuh,궁서,serif; font-size: 14pt;"><span style="color: rgb(102, 0, 255); font-family: Gulim,굴림,AppleGothic,sans-serif; font-size: 12pt;"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(255, 0, 0);"><a class="tx-link" href="https://youtu.be/UnDzIPviqd0" target="_blank" rel="noopener noreferrer"><span style="color: rgb(255, 0, 0);">▶</span></a></span><a class="tx-link" href="https://youtu.be/UnDzIPviqd0" target="_blank" rel="noopener noreferrer"><span style="color: rgb(0, 0, 0);"><span style="color: rgb(255, 0, 221);">2. 처음시작:</span> <span style="color: rgb(0, 85, 255);">엑셀화면 구성과 설정 (50가지 필수 기능)</span></span></a></span></font></span></span></span></font></p><p><font color="#0066cc"><span style="font-size: 10pt;"><span style="font-family: Gungsuh,궁서,serif; font-size: 14pt;"><span style="color: rgb(102, 0, 255); font-family: Gulim,굴림,AppleGothic,sans-serif; font-size: 12pt;"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(0, 0, 0);"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);">▶</span><span style="color: rgb(0, 0, 0);"><span style="color: rgb(255, 0, 0);">3. 복습:</span> <a class="tx-link" href="https://youtu.be/mnEUWsGcAWU" target="_blank" rel="noopener noreferrer"><span style="color: rgb(0, 85, 255);">채우기 기능 (기초 사용법. 기본 기능 및 사용법. 빠른 채우기 시트 셀서식 강의)</span></a></span></span></span></font></span></span></font></span></span></span></font></p><p><font color="#0066cc"><span style="font-size: 10pt;"><span style="font-family: Gungsuh,궁서,serif; font-size: 14pt;"><span style="color: rgb(102, 0, 255); font-family: Gulim,굴림,AppleGothic,sans-serif; font-size: 12pt;"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(0, 0, 0);"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(255, 0, 0);"><span style="color: rgb(0, 0, 0);"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 10pt;"><a class="tx-link" href="https://youtu.be/FNgAnkR3Tkw" target="_blank" rel="noopener noreferrer"><span style="color: rgb(255, 0, 0);">▶</span><span style="color: rgb(255, 0, 0);">4. 복습:</span> <span style="color: rgb(0, 85, 255);">처음 배우는 엑셀의 계산식과 수식관련 연산자 학습 절대</span></a><a class="tx-link" href="https://youtu.be/FNgAnkR3Tkw" target="_blank" rel="noopener noreferrer"><span style="color: rgb(0, 85, 255);">참조번지 교육</span></a></span></font></span></span></span></span></font></span></span></font></span></span></span></font></p><p><font color="#0066cc"><span style="font-size: 10pt;"><span style="font-family: Gungsuh,궁서,serif; font-size: 14pt;"><span style="color: rgb(102, 0, 255); font-family: Gulim,굴림,AppleGothic,sans-serif; font-size: 12pt;"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(0, 0, 0);"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(255, 0, 0);"><span style="color: rgb(0, 0, 0);"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(255, 0, 0);"><a class="tx-link" href="https://youtu.be/WmOKzbAVUJI" target="_blank" rel="noopener noreferrer"><span style="color: rgb(255, 0, 0);">▶5. 복습:</span></a></span><a class="tx-link" href="https://youtu.be/WmOKzbAVUJI" target="_blank" rel="noopener noreferrer"> </a><span style="color: rgb(0, 85, 255);"><a class="tx-link" href="https://youtu.be/WmOKzbAVUJI" target="_blank" rel="noopener noreferrer"><span style="color: rgb(0, 85, 255);">엑셀 왕초보도 1시간만 공부하면 놀라운 실무 작업을 있어요</span></a><span style="color: rgb(102, 0, 255);"><a class="tx-link" href="https://youtu.be/WmOKzbAVUJI" target="_blank" rel="noopener noreferrer"><span style="color: rgb(102, 0, 255);">=헬스장 출석 관리표 작성</span></a></span></span></span></font></span></span></span></span></font></span></span></font></span></span></span></font></p><p><font color="#0066cc"><span style="font-size: 10pt;"><span style="font-family: Gungsuh,궁서,serif; font-size: 14pt;"><span style="color: rgb(102, 0, 255); font-family: Gulim,굴림,AppleGothic,sans-serif; font-size: 12pt;"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(0, 0, 0);"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(255, 0, 0);"><span style="color: rgb(0, 0, 0);"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(0, 85, 255);"><span style="color: rgb(102, 0, 255);"><span style="font-size: 10pt;"><a class="tx-link" href="https://youtu.be/dGngxRXA3dE" target="_blank" rel="noopener noreferrer"><span style="color: rgb(255, 0, 0);">▶</span><span style="color: rgb(255, 0, 0);">6. 복습:</span> <span style="color: rgb(0, 85, 255);">금전출납부 만들기</span></a></span></span></span></span></font></span></span></span></span></font></span></span></font></span></span></span></font></p><p><font color="#0066cc"><span style="font-size: 10pt;"><span style="font-family: Gungsuh,궁서,serif; font-size: 14pt;"><span style="color: rgb(102, 0, 255); font-family: Gulim,굴림,AppleGothic,sans-serif; font-size: 12pt;"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(0, 0, 0);"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(255, 0, 0);"><span style="color: rgb(0, 0, 0);"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(0, 85, 255);"><span style="color: rgb(102, 0, 255);"><span style="font-size: 10pt;"> <a class="tx-link" href="https://youtu.be/pke9uu5mZgs" target="_blank" rel="noopener noreferrer"><span style="color: rgb(255, 0, 0);">▶6-1복습:</span> <span style="color: rgb(0, 85, 255);">가계부 만들기 1탄</span></a><a class="tx-link" href="https://youtu.be/pke9uu5mZgs" target="_blank" rel="noopener noreferrer"><span style="color: rgb(0, 85, 255);"> </span></a></span></span></span></span></font></span></span></span></span></font></span></span></font></span></span></span></font></p><p><font color="#0066cc"><span style="font-size: 10pt;"><span style="font-family: Gungsuh,궁서,serif; font-size: 14pt;"><span style="color: rgb(102, 0, 255); font-family: Gulim,굴림,AppleGothic,sans-serif; font-size: 12pt;"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(0, 0, 0);"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(255, 0, 0);"><span style="color: rgb(0, 0, 0);"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(0, 85, 255);"><span style="color: rgb(102, 0, 255);"><span style="font-size: 10pt;"> <a class="tx-link" href="https://youtu.be/tjtKwsh68Ac" target="_blank" rel="noopener noreferrer"><span style="color: rgb(255, 0, 0);">▶6-2복습:</span> <span style="color: rgb(0, 85, 255);">가계부 만들기</span></a><span style="color: rgb(0, 85, 255);"> 2탄</span></span></span></span></span></font></span></span></span></span></font></span></span></font></span></span></span></font></p><p><font color="#0066cc"><span style="font-size: 10pt;"><span style="font-family: Gungsuh,궁서,serif; font-size: 14pt;"><span style="color: rgb(102, 0, 255); font-family: Gulim,굴림,AppleGothic,sans-serif; font-size: 12pt;"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(0, 0, 0);"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(255, 0, 0);"><span style="color: rgb(0, 0, 0);"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(0, 85, 255);"><span style="color: rgb(102, 0, 255);"><span style="font-size: 10pt;"><span style="color: rgb(0, 85, 255);"> <a class="tx-link" href="https://youtu.be/hyI-CNX5GrQ" target="_blank" rel="noopener noreferrer"><span style="color: rgb(255, 0, 0);"> </span></a><a class="tx-link" href="https://youtu.be/hyI-CNX5GrQ" target="_blank" rel="noopener noreferrer"><span style="color: rgb(255, 0, 0);">▶6-3(1.2복습):</span> <span style="color: rgb(0, 85, 255);">가계부 만들기</span></a></span></span></span></span></span></font></span></span></span></span></font></span></span></font></span></span></span></font></p><p><font color="#0066cc"><span style="font-size: 10pt;"><span style="font-family: Gungsuh,궁서,serif; font-size: 14pt;"><span style="color: rgb(102, 0, 255); font-family: Gulim,굴림,AppleGothic,sans-serif; font-size: 12pt;"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(0, 0, 0);"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(255, 0, 0);"><span style="color: rgb(0, 0, 0);"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(0, 85, 255);"><span style="color: rgb(102, 0, 255);"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 10pt;"><a class="tx-link" href="https://youtu.be/86MZOV483JU" target="_blank" rel="noopener noreferrer"><span style="color: rgb(255, 0, 0);">▶7. 복습:</span> <span style="color: rgb(0, 85, 255);">엑셀 필수 함수 배우기 (누적계산작업)</span></a></span></font></span></font></span></font></span></span></span></span></font></span></span></span></span></font></span></span></font></span></span></span></font></p><p><font color="#0066cc"><span style="font-size: 10pt;"><span style="font-family: Gungsuh,궁서,serif; font-size: 14pt;"><span style="color: rgb(102, 0, 255); font-family: Gulim,굴림,AppleGothic,sans-serif; font-size: 12pt;"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(0, 0, 0);"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(255, 0, 0);"><span style="color: rgb(0, 0, 0);"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(0, 85, 255);"><span style="color: rgb(102, 0, 255);"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(255, 0, 0);"><a class="tx-link" href="https://youtu.be/9NpKPxAhC3k" target="_blank" rel="noopener noreferrer"><span style="color: rgb(255, 0, 0);">▶8. 복습:</span></a></span><a class="tx-link" href="https://youtu.be/9NpKPxAhC3k" target="_blank" rel="noopener noreferrer"> </a><span style="color: rgb(0, 85, 255);"><a class="tx-link" href="https://youtu.be/9NpKPxAhC3k" target="_blank" rel="noopener noreferrer"><span style="color: rgb(0, 85, 255);">MS엑셀 함수 사용법 배우기 (EVERAGE,COUNT,TODAY,NOW함수등 엑셀 강좌</span></a></span></span></font></span></font></span></font></span></span></span></span></font></span></span></span></span></font></span></span></font></span></span></span></font></p><p><font color="#0066cc"><span style="font-size: 10pt;"><span style="font-family: Gungsuh,궁서,serif; font-size: 14pt;"><span style="color: rgb(102, 0, 255); font-family: Gulim,굴림,AppleGothic,sans-serif; font-size: 12pt;"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(0, 0, 0);"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(255, 0, 0);"><span style="color: rgb(0, 0, 0);"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(0, 85, 255);"><span style="color: rgb(102, 0, 255);"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(0, 85, 255);"><span style="font-size: 10pt;"><span style="color: rgb(255, 0, 0);"><span style="color: rgb(0, 0, 0);"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(255, 0, 0);"><span style="font-size: 10pt;"><span style="color: rgb(255, 0, 0);"><span style="color: rgb(0, 0, 0);"><a class="tx-link" href="https://youtu.be/juGTJik-peo" target="_blank" rel="noopener noreferrer"><span style="color: rgb(255, 0, 0);">▶</span><span style="color: rgb(255, 0, 0);">9. 복습:</span> <span style="color: rgb(0, 85, 255);">엑셀기본-이것만은 알아두자!! (조건부 서식 필더링 피벗테이블 사용법 배우기)</span></a></span></span></span></span></span></font></span></span></span></span></span></font></span></font></span></font></span></span></span></span></font></span></span></span></span></font></span></span></font></span></span></span></font></p><p><font color="#0066cc"><span style="font-size: 10pt;"><span style="font-family: Gungsuh,궁서,serif; font-size: 14pt;"><span style="color: rgb(102, 0, 255); font-family: Gulim,굴림,AppleGothic,sans-serif; font-size: 12pt;"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(0, 0, 0);"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(255, 0, 0);"><span style="color: rgb(0, 0, 0);"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(0, 85, 255);"><span style="color: rgb(102, 0, 255);"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(0, 85, 255);"><span style="font-size: 10pt;"><span style="color: rgb(255, 0, 0);"><span style="color: rgb(0, 0, 0);"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(255, 0, 0);"><span style="font-size: 10pt;"><span style="color: rgb(255, 0, 0);"><span style="color: rgb(0, 0, 0);"><a class="tx-link" href="https://youtu.be/vnRZDegBfI4" target="_blank" rel="noopener noreferrer"><span style="color: rgb(255, 0, 0);">▶10. 복습:</span> <span style="color: rgb(0, 85, 255);">MS엑셀 기초 조건부 서식 작성 유익한 엑셀 기본 기능 배우기</span></a></span></span></span></span></span></font></span></span></span></span></span></font></span></font></span></font></span></span></span></span></font></span></span></span></span></font></span></span></font></span></span></span></font></p><p><font color="#0066cc"><span style="font-size: 10pt;"><span style="font-family: Gungsuh,궁서,serif; font-size: 14pt;"><span style="color: rgb(102, 0, 255); font-family: Gulim,굴림,AppleGothic,sans-serif; font-size: 12pt;"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(0, 0, 0);"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(255, 0, 0);"><span style="color: rgb(0, 0, 0);"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(0, 85, 255);"><span style="color: rgb(102, 0, 255);"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(0, 85, 255);"><span style="font-size: 10pt;"><span style="color: rgb(255, 0, 0);"><span style="color: rgb(0, 0, 0);"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(255, 0, 0);"><a class="tx-link" href="https://youtu.be/DRy0R7tiMSw" target="_blank" rel="noopener noreferrer"><span style="color: rgb(255, 0, 0);">▶</span></a></span><span style="color: rgb(255, 0, 0);">11</span><a class="tx-link" href="https://youtu.be/DRy0R7tiMSw" target="_blank" rel="noopener noreferrer"><span style="color: rgb(255, 0, 0);"><span style="color: rgb(255, 0, 0);">. </span>복습(종합):</span> <span style="color: rgb(0, 85, 255);">MS엑셀 11가지 기능 배우기 (1,복사 2,</span></a><a class="tx-link" href="https://youtu.be/DRy0R7tiMSw" target="_blank" rel="noopener noreferrer"><span style="color: rgb(0, 85, 255);">입력 3,붙여넣기 4,</span></a><a class="tx-link" href="https://youtu.be/DRy0R7tiMSw" target="_blank" rel="noopener noreferrer"><span style="color: rgb(0, 85, 255);">행열 5,이름상자 6,조건부서식 7,중복데이터 8,서식 9,표 10,수식계산 11,절대참조번지</span></a></span></font></span></span></span></span></span></font></span></font></span></font></span></span></span></span></font></span></span></span></span></font></span></span></font></span></span></span></font></p><p><font color="#0066cc"><span style="font-size: 10pt;"><span style="font-family: Gungsuh,궁서,serif; font-size: 14pt;"><span style="color: rgb(102, 0, 255); font-family: Gulim,굴림,AppleGothic,sans-serif; font-size: 12pt;"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(0, 0, 0);"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(255, 0, 0);"><span style="color: rgb(0, 0, 0);"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(0, 85, 255);"><span style="color: rgb(102, 0, 255);"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(0, 85, 255);"><span style="font-size: 10pt;"><span style="color: rgb(255, 0, 0);"><span style="color: rgb(0, 0, 0);"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(0, 85, 255);"><font color="#0066cc"><a class="tx-link" href="https://youtu.be/cRqcN3uCMvE" target="_blank" rel="noopener noreferrer">▶12. 복습: MS엑셀 믾이 사용하는 '4대함수'{Vlookup , Hlookup</a><a class="tx-link" href="https://youtu.be/cRqcN3uCMvE" target="_blank" rel="noopener noreferrer">,Index,Match 함수}꼭 알아두세요</a></font><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(255, 0, 0);"><span style="color: rgb(0, 0, 0);"><br></span></span></span></font></span></span></font></span></span></span></span></span></font></span></font></span></font></span></span></span></span></font></span></span></span></span></font></span></span></font></span></span></span></font></p><p><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(255, 0, 0);"><span style="color: rgb(0, 0, 0);"><font color="#0066cc"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(255, 0, 0);"><span style="color: rgb(0, 0, 0);"><font color="#0066cc"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 12pt;"><strong><span style="color: rgb(102, 0, 255);">===소소한 활용팁===</span></strong></span></font></span></font></span></font></span></font></span></span></span></font></span></font></span></font></span></span></span></font></p><p><font color="#0066cc"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(255, 0, 0);"><a class="tx-link" href="https://youtu.be/gjRGVD6WGDI" target="_blank" rel="noopener noreferrer"><span style="color: rgb(255, 0, 0);">▶ 4.</span></a></span><a class="tx-link" href="https://youtu.be/gjRGVD6WGDI" target="_blank" rel="noopener noreferrer"> <span style="color: rgb(0, 85, 255);">MS 엘셀 수식계산 하는법 </span></a><a class="tx-link" href="https://youtu.be/gjRGVD6WGDI" target="_blank" rel="noopener noreferrer"><span style="color: rgb(0, 85, 255);">【엑셀 잘할수 있습니다 </span></a><a class="tx-link" href="https://youtu.be/gjRGVD6WGDI" target="_blank" rel="noopener noreferrer"><span style="color: rgb(0, 85, 255);">▶이번강의 꼭 시청</span></a><a class="tx-link" href="https://youtu.be/gjRGVD6WGDI" target="_blank" rel="noopener noreferrer"><span style="color: rgb(0, 85, 255);">】</span></a></span></font></span></font></p><p><font color="#0066cc"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 12pt;"><strong><span style="color: rgb(102, 0, 255);">===엑셀 문서작업===</span></strong></span></font></span></font></p><p><font color="#0066cc"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(255, 0, 0);">▶</span><span style="color: rgb(255, 0, 0);"> 2</span><a class="tx-link" href="https://youtu.be/uSiJEpJMiy8" target="_blank" rel="noopener noreferrer"><span style="color: rgb(255, 0, 0);">.</span> 엑셀 문서작업 (1.시작과 저장하기</a><a class="tx-link" href="https://youtu.be/uSiJEpJMiy8" target="_blank" rel="noopener noreferrer"> 2. 서식파일 이용하여 문서 작성하기)</a></span></font></span></font></p><p><br></p><p><font color="#0066cc" size="2"> <span style="font-family: Gungsuh,궁서,serif; font-size: 14pt;"><strong><span style="color: rgb(9, 0, 255);"><u><span style="font-family: Gulim,굴림,AppleGothic,sans-serif;"><span style="color: rgb(34, 116, 28);">강사: 한정희</span> </span><span style="color: rgb(34, 116, 28); font-family: Gulim,굴림,AppleGothic,sans-serif;">(짤막한 강좌)</span></u></span></strong></span></font></p><p><font color="#0066cc" size="2"><span style="font-size: 12pt;"><strong><span style="color: rgb(102, 0, 255);">===엑셀 기초에서 실무까지===</span></strong></span></font></p><p><font color="#0066cc" size="2"><span style="color: rgb(255, 0, 0);"><a class="tx-link" href="https://youtu.be/6heMauzTa7g" target="_blank" rel="noopener noreferrer">1강:</a></span><a class="tx-link" href="https://youtu.be/6heMauzTa7g" target="_blank" rel="noopener noreferrer"> 데이터 입력</a> </font></p><p><font color="#0066cc" size="2"><span style="color: rgb(255, 0, 0);"><a class="tx-link" href="https://youtu.be/I-OiwOabXTk" target="_blank" rel="noopener noreferrer">2강:</a></span><a class="tx-link" href="https://youtu.be/I-OiwOabXTk" target="_blank" rel="noopener noreferrer"> 데이터 표시 형식</a> </font></p><p><font color="#0066cc"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 10pt;"><a class="tx-link" href="https://youtu.be/njHlcUE1svo" target="_blank" rel="noopener noreferrer"><span style="color: rgb(255, 0, 0);">3강:</span> 자동 채우기</a></span></font></span></font></p><p><font color="#0066cc"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 10pt;"><a class="tx-link" href="https://youtu.be/xuvKHBYS6bQ" target="_blank" rel="noopener noreferrer"><span style="color: rgb(255, 0, 0);">4강: </span>간단한 게산 표 만들기</a></span></font></span></font></p><p><font color="#0066cc"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 10pt;"><span style="color: rgb(255, 0, 0);"><a class="tx-link" href="https://youtu.be/tu5BpQQ7eaw" target="_blank" rel="noopener noreferrer">5강: </a></span><a class="tx-link" href="https://youtu.be/tu5BpQQ7eaw" target="_blank" rel="noopener noreferrer">워크시트 이름 변경,추가,삭제,이동,복사,색상 바꾸기</a> </span></font></span></font></p><p><font color="#0066cc"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 10pt;">6강:<a class="tx-link" href="https://youtu.be/D9XktdZttW4" target="_blank" rel="noopener noreferrer">지출기안서-업무에 필요한 양식 만들기</a></span></font></span></font></p><p><font color="#0066cc"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 10pt;">97강: <a class="tx-link" href="https://youtu.be/q7zUKg5aars" target="_blank" rel="noopener noreferrer">결재 양식 작성후 연결하여 그림으로 붙여넣기</a></span></font></span></font></p><p><font color="#0066cc"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 10pt;">96강: <a class="tx-link" href="https://youtu.be/V1S-0i3isA0" target="_blank" rel="noopener noreferrer">연산하여 붙여넣기와 테두리는 제외하고 붙여넣기</a></span></font></span></font></p><p><font color="#0066cc"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 10pt;"><a class="tx-link" href="https://youtu.be/iG3YOrUAYjc" target="_blank" rel="noopener noreferrer">선택하여 붙</a><a class="tx-link" href="https://youtu.be/iG3YOrUAYjc" target="_blank" rel="noopener noreferrer">여넣기-연결하여 붙여넣기</a></span></font></span></font></p><p><font color="#0066cc"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 10pt;"><a class="tx-link" href="https://youtu.be/zsfy-UGesCU" target="_blank" rel="noopener noreferrer">견적서-업</a></span></font></span></font><a class="tx-link" style="font-size: 10pt;" href="https://youtu.be/zsfy-UGesCU" target="_blank" rel="noopener noreferrer"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 10pt;">무에 필요한 양식 만들기</span></font></span></a><span style="color: rgb(0, 102, 204); font-size: 10pt;"><a class="tx-link" href="https://youtu.be/zsfy-UGesCU" target="_blank" rel="noopener noreferrer">사용자 지정 서식</a></span></p><p><span style="color: rgb(0, 102, 204); font-size: 10pt;"><a class="tx-link" href="https://youtu.be/yBxBHEPSpdM" target="_blank" rel="noopener noreferrer">사용자 지정서식</a></span></p><p><font color="#0066cc"><span style="font-size: 10pt;"><font color="#0066cc"><span style="font-size: 10pt;"><a class="tx-link" href="https://youtu.be/GKuoFKQl6zw" target="_blank" rel="noopener noreferrer">음수를 한 눈에 볼 수 있도록 서식 지정하기</a></span></font></span></font></p><p><font color="#0066cc" size="2"><a class="tx-link" href="https://youtu.be/iG3YOrUAYjc" target="_blank" rel="noopener noreferrer"><span style="color: rgb(255, 0, 0);">98강:</span> 연결하여 붙여넣기</a></font></p><p><font color="#0066cc"><span style="font-size: 12pt;"><strong><span style="color: rgb(102, 0, 255);">===엑셀 수식과 함수 70강===</span></strong></span></font></p><p><font color="#0066cc">엑셀 수식 작성법</font></p><p><font color="#0066cc">수식을 잘 작성할 수 있는 첫 관문 상대참조 방식</font></p><p><font color="#0066cc"><font color="#0066cc">수식을 작성하는 기본 공식, 상대참조 원리 이해</font></font></p><p><font color="#0066cc"><font color="#0066cc">합계, 평균, 개수등을 빠르고 쉽게 구하는 자동합계</font></font></p><p><font color="#0066cc"><font color="#0066cc">수식을 잘 사용하려먼 꼭 익혀야하는 절대 참조</font></font></p><p><font color="#0066cc"><font color="#0066cc">절대 참조 방식을 활용해 누적 합계 구하기</font></font></p><p><font color="#0066cc"><font color="#0066cc">절대 참조 방식과 구성비 구하기</font></font></p><p><font color="#0066cc"><font color="#0066cc">이름 정의, 셀 주소에 별칭을 붙여서 수식에 사용</font></font></p><p><font color="#0066cc"><font color="#0066cc">혼합 참조, 행과 열을 따로 고정해서 사용하는 혼합</font></font></p><p><font color="#0066cc"><font color="#0066cc">3차원 수식, 여러개의 시트에 작성된 데이터의</font></font></p><p><font color="#0066cc"><font color="#0066cc">함수의 필요성과 기초 작성법</font></font></p><p><font color="#0066cc"><font color="#0066cc">LARGE와 SMALL 함수, 몇 번째 큰 값, 작은</font></font></p><p><font color="#0066cc"><font color="#0066cc"><span style="font-size: 12pt;"><strong><span style="color: rgb(102, 0, 255);">===된다! 7일 실무 엑셀===</span></strong></span></font></font></p><p><font color="#0066cc"><font color="#0066cc">1강: 데이터 입력</font></font></p><p><font color="#0066cc"><font color="#0066cc">데이터 표시형식</font></font></p><p><font color="#0066cc"><font color="#0066cc">자동 채우기</font></font></p><p><font color="#0066cc"><font color="#0066cc">간단한 계산표 만들기</font></font></p><p><font color="#0066cc"><font color="#0066cc">워크시트 이름 변경, 추가, 삭제, 이동, 복사, 색상 바꾸기</font></font></p><p><font color="#0066cc"><font color="#0066cc">견적서-업무에 필요한 양식 만들기</font></font></p><p><font color="#0066cc"><font color="#0066cc">단축키를 사용하여 데이터 범위 선택과 빠른 이동</font></font></p><p><font color="#0066cc"><font color="#0066cc">첫 행을 고정하는 틀 고정과 데이터 위/아래를 비교하는</font></font></p><p><font color="#0066cc">데이터를 오름차순, 내림차순으로 정렬하기</font></p><p><font color="#0066cc">사용자 정의 정렬-직위 순으로 정렬하기</font></p><p><font color="#0066cc">데이터베이스 규칙에 밎게 빈 셀에 바로 위 데이터 값</font></p><p><font color="#0066cc">불 필요한 공백 제거하기-셀 안에 숨어 있는 빈칸 제거<font color="#0066cc"><br></font></font></p><p><font color="#0066cc"><span style="color: rgb(34, 116, 28);"> </span><span style="font-size: 12pt;"><strong><span style="color: rgb(34, 116, 28); font-size: 14pt;">강사: 엑셀레이터</span></strong></span></font></p><p><font color="#0066cc"><a class="tx-link" href="https://youtu.be/5C91ebW-ioI?list=PLpzwphXndx3DOJHtsQL1DKmbwEQlqG0Be" target="_blank" rel="noopener noreferrer"><span style="color: rgb(255, 0, 0);">▶</span><span style="color: rgb(255, 0, 0);">채널소개</span></a></font></p><p><font color="#0066cc"><a class="tx-link" href="https://youtu.be/slumzjP-kdQ" target="_blank" rel="noopener noreferrer"><span style="color: rgb(255, 0, 0);">▶</span><span style="color: rgb(255, 0, 0);">1.필수기초-수식 및 함수개념</span></a></font></p><p><font color="#0066cc"><a class="tx-link" href="https://youtu.be/Z0_qCdHqozE" target="_blank" rel="noopener noreferrer"><span style="color: rgb(255, 0, 0);">▶2.필수기초-절대참조&상대참조</span></a></font></p><p><font color="#0066cc"><br></font></p><p><font color="#0066cc"><span style="font-family: Gungsuh,궁서,serif; font-size: 14pt;"><u><strong><span style="color: rgb(255, 0, 0);">함수 계산 배우기</span></strong></u></span></font></p><p><font color="#0066cc"><span style="font-family: Gungsuh,궁서,serif; font-size: 14pt;"><span style="color: rgb(255, 0, 0);"><a class="tx-link" href="https://youtu.be/slumzjP-kdQ" target="_blank" rel="noopener noreferrer"><font size="2"><font face="Gulim"><span style="color: rgb(255, 0, 0);">▶</span><span style="color: rgb(255, 0, 0);">1.필수기초-수식 및 함수개념</span></font></font></a><strong> </strong><span style="color: rgb(102, 0, 255); font-family: Gulim,굴림,AppleGothic,sans-serif; font-size: 10pt;">(엑셀레이터)</span></span></span></font></p><p><font color="#0066cc"><span style="font-family: Gungsuh,궁서,serif; font-size: 14pt;"><span style="color: rgb(255, 0, 0);"><span style="color: rgb(102, 0, 255); font-family: Gulim,굴림,AppleGothic,sans-serif; font-size: 10pt;"><a class="tx-link" href="https://youtu.be/Z0_qCdHqozE" target="_blank" rel="noopener noreferrer"><span style="color: rgb(255, 0, 0);">▶2.필수기초-절대참조&상대참조</span></a> (엑셀레이터)</span><strong><u></u></strong></span></span></font></p><font color="#0066cc"><p><span style="font-size: 10pt;"><a class="tx-link" href="https://youtu.be/9NpKPxAhC3k" target="_blank" rel="noopener noreferrer"><span style="color: rgb(255, 0, 0);">▶함수 사용법</span> <span style="color: rgb(0, 85, 255);">(AVERAGE,COUNT,TODAY,NOW)</span> <span style="color: rgb(102, 0, 255);">(한정희강사 8강)</span></a></span></p><p><span style="font-size: 10pt;"><a class="tx-link" href="https://youtu.be/86MZOV483JU" target="_blank" rel="noopener noreferrer"><span style="color: rgb(255, 0, 0);">▶</span></a></span><a class="tx-link" href="https://youtu.be/86MZOV483JU" target="_blank" rel="noopener noreferrer"><span style="color: rgb(255, 0, 0);">필수 함수</span></a><a class="tx-link" href="https://youtu.be/86MZOV483JU" target="_blank" rel="noopener noreferrer"><span style="color: rgb(255, 0, 0);"> 배우기</span></a><a class="tx-link" style="font-size: 10pt;" href="https://youtu.be/86MZOV483JU" target="_blank" rel="noopener noreferrer"> <span style="color: rgb(0, 85, 255);">(SUM=average.round) </span><span style="color: rgb(0, 85, 255);">(SUMIF)</span><span style="color: rgb(0, 85, 255);"> (dsum) (</span><span style="color: rgb(0, 85, 255);"> iferror)</span><span style="color: rgb(0, 85, 255);"> (count.counta) (countif.countifs) (if)</span> <span style="color: rgb(102, 0, 255);">(한정희강사 7강)</span></a><br></p><span style="font-size: 10pt;"><p><br></p><font color="#0066cc"><p><br></p><span style="font-size: 10pt;"><p><br></p><p><br></p></span></font></span></font><p><br></p>
<!-- -->
]]>
카페 게시글
퍼온동영상
엑셀 배우기
광태
추천 0
조회 1,410
20.04.11 22:03
댓글 0
다음검색
