<![CDATA[
<center>
<TABLE width=746 border="2" bordercolor="white"> <TBODY> <TR> <TD width="366" colSpan=2> <B>계획과정소개</B></TD> <TD width="370" colSpan=2> </TD></TR> <TR> <TD width=740 colSpan=4> <TABLE width=740 border="2" bordercolor="white"> <TBODY> <TR> <TD width=128 bgColor="#CDEDCD"> <P align=center><B>과 정 이 름</B></TD> <TD width=596 bgcolor="#CDEDCD"> <P align=left> 엑셀2000 초급과정</TD></TR> <TR> <TD width=128 bgColor="#CDEDCD"> <P align=center><B>강 사 명</B></TD> <TD width=596 bgcolor="#CDEDCD"> <P align=left> 조 정 윤</A></TD></TR></TBODY></TABLE></TD></TR> <TR> <TD width=133> </TD> <TD width="229"> </TD> <TD width="184"> </TD> <TD width=182> </TD></TR> <TR> <TD width="366" colSpan=2> <B>세부일정소개</B></TD> <TD width="370" colSpan=2> 해당강의목록을 클릭하시면 동영상이 실행됩니다</TD></TR> <TR> <TD width=740 colSpan=4> <TABLE width=740 border="2" bordercolor="white"> <TBODY> <TR> <TD width=43 bgColor="#CDEDCD"> <P align=center><span style="font-size:12pt;">회 수</span></TD> <TD width=150 bgColor="#CDEDCD"> <P align=center><span style="font-size:12pt;">강 의 제 목</span></TD> <TD width=442 bgColor="#CDEDCD"> <P align=center><span style="font-size:12pt;">강 의 내 용</span></TD></TR><TR> <TD width=43 bgcolor="#CDEDCD"> <P align=center style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;">0</span></TD> <TD width=150 bgcolor="#CDEDCD"> 간단한 도움말</span> <P style="line-height:100%; margin-top:0; margin-bottom:0;"><SPAN style="font-size:12pt;"><FONT face=굴림체,굴림체></FONT></SPAN></TD> <TD width=442 bgcolor="#CDEDCD"> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;">엑셀은 가계부나 서류정리 여러가지을 하실수 있읍니다가계 가시면 컴퓨터로 계산을 하시는것을 보셨을것입니다그런기능이라 생각을 하시면 됩니다물론 그것과 틀리지만 그런기능이 아마 이것이 발전해서 만들어 졌다고 하더군요엑셀은 사무실에서 매우 유용하게 사용을 하고 있읍니다시간은 오래 걸리지만 배워 두시면 집 사무실 어디에서나 사용을 하실수 있읍니다</span></TD></TR> <TR> <TD width=43 bgcolor="#CDEDCD"> <P align=center style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;">1</span></TD> <TD width=150 bgcolor="#CDEDCD"> <P style="line-height:100%; margin-top:0; margin-bottom:0;"><SPAN style="font-size:12pt;"><FONT face=굴림체,굴림체> 엑셀시작하기</FONT></SPAN></TD> <TD width=442 bgcolor="#CDEDCD"> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day1-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day1-1.asf" target="_blank"><span style="font-size:12pt;">엑셀 시작하기&종료하기</span></a> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day1-1.asf" target="_blank">-</a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day1-1.asf.asf" target="_blank"><span style="font-size:12pt;"> </span></a><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day1-2.asf" target="_blank"><span style="font-size:12pt;">보기메뉴를 이용한 화면 구성 변경하기</span></a><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day1-2.asf" target="_blank"></a></span></TD></TR> <TR> <TD width=43 bgcolor="#CDEDCD"> <P align=center style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;">2</span></TD> <TD width=150 bgcolor="#CDEDCD"> <p style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"> 통합문서의 개념 </span></TD> <TD width=442 bgcolor="#CDEDCD"> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day2-1.asf" target="_blank">-</a><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day2-1.asf" target="_blank"> </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day2-1.asf" target="_blank"><span style="font-size:12pt;">엘셀을 시작하기전에</span></a> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day2-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day2-2.asf" target="_blank"><span style="font-size:12pt;">오피스 길잡이</span></a> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day2-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day2-3.asf" target="_blank"><span style="font-size:12pt;">통합문서의 개념</span></a></TD></TR> <TR> <TD width=43 height="115" bgcolor="#CDEDCD"> <P align=center style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;">3</span></TD> <TD width=150 height="115" bgcolor="#CDEDCD"> <P style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"> 데이터 입력</span></TD> <TD width=442 height="115" bgcolor="#CDEDCD"> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;">-<a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day3-1.asf" target="_blank"> </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day3-1.asf" target="_blank"><span style="font-size:12pt;">문자 데이터 입력 저장</span></a><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day3-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day3-2.asf" target="_blank"><span style="font-size:12pt;">데이터 입력(숫자데이터</span></a><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day3-1.asf" target="_blank">)</a></span> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day3-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day3-3.asf" target="_blank"><span style="font-size:12pt;">데이터입력(문자데이터)</span></a> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day3-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day3-4.asf" target="_blank"><span style="font-size:12pt;">데이터입력(한자데이터)</span></a> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day3-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day3-5.asf" target="_blank"><span style="font-size:12pt;">실습을 통한 한자와 특수문자 입력</span></a> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day3-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day3-6.asf" target="_blank"><span style="font-size:12pt;">엘셀문서의 저장</span></a> <p style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day3-1.asf" target="_blank">-</a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day3-7.asf" target="_blank"><span style="font-size:12pt;">엘셀문서의열기</span></a></TD></TR> <TR> <TD width=43 bgcolor="#CDEDCD"> <P align=center style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;">4</span></TD> <TD width=150 bgcolor="#CDEDCD"> <P style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"> 작업 영역 선택하기</span></TD> <TD width=442 bgcolor="#CDEDCD"> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;">-<a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day4-1.asf" target="_blank"> </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day4-1.asf" target="_blank"><span style="font-size:12pt;">셀행열 다루기</span></a><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day4-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day4-2.asf" target="_blank"><span style="font-size:12pt;">행과 열에서의 블록 지정하기</span></a> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day4-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day4-3.asf" target="_blank"><span style="font-size:12pt;">셀의 이동복사</span></a> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day4-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day4-4.asf" target="_blank"><span style="font-size:12pt;">행,열의 삽입.삭제</span></a> <p style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day4-1.asf" target="_blank">-</a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day4-5.asf" target="_blank"><span style="font-size:12pt;">행,열의 너비조정</span></a> <p style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day4-1.asf" target="_blank">-</a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day4-6.asf" target="_blank"><span style="font-size:12pt;">행,열의 너비조정(1)</span></a></TD></TR> <TR> <TD width=43 height=54 bgcolor="#CDEDCD"> <P align=center style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;">5</span></TD> <TD width=150 height=54 bgcolor="#CDEDCD"> <P style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"> 셀의 이동과 복사</span></TD> <TD width=442 height=54 bgcolor="#CDEDCD"> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day5-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day5-1.asf" target="_blank"><span style="font-size:12pt;">수식의 기본익히기</span></a><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day5-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day5-2.asf" target="_blank"><span style="font-size:12pt;">수식에서의 셀참조</span></a><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day5-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day5-3.asf" target="_blank"><span style="font-size:12pt;">데이터를 이용한 나쁜수식</span></a> <p style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day5-1.asf" target="_blank">-</a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day5-4.asf" target="_blank"><span style="font-size:12pt;">상대참조영역</span></a></TD></TR> <TR> <TD width=43 bgcolor="#CDEDCD"> <P align=center style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;">6</span></TD> <TD width=150 bgcolor="#CDEDCD"> <P style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"> 수식을 이용한 연산(1)</span></TD> <TD width=442 bgcolor="#CDEDCD"> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;">-<a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day06-1.asf" target="_blank"> </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day06-1.asf" target="_blank"><span style="font-size:12pt;">시트다루기</span></a> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day06-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day06-2.asf" target="_blank"><span style="font-size:12pt;">워크시트에 대해서</span></a> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day06-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day06-3.asf" target="_blank"><span style="font-size:12pt;">셀의 복사와 시트의 복사의 차이</span></a> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day06-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day06-4.asf" target="_blank"><span style="font-size:12pt;">시트의 그룹지정</span></a></TD></TR> <TR> <TD width=43 bgcolor="#CDEDCD"> <P align=center style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;">7</span></TD> <TD width=150 bgcolor="#CDEDCD"> <P style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"> 함수(1)</span></TD> <TD width=442 bgcolor="#CDEDCD"> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day07-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day07-1.asf" target="_blank"><span style="font-size:12pt;">함수의 기능</span></a><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day07-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day07-2.asf" target="_blank"><span style="font-size:12pt;">SUM 함수</span></a> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day07-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day07-3.asf" target="_blank"><span style="font-size:12pt;">MAX 함수</span></a></TD></TR> <TR> <TD width=43 bgcolor="#CDEDCD"> <P align=center style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;">8</span></TD> <TD width=150 bgcolor="#CDEDCD"> <P style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"> 함수(2)</span></TD> <TD width=442 bgcolor="#CDEDCD"> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day08-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day08-1.asf" target="_blank"><span style="font-size:12pt;">함수마법사등 활용방법</span></a> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day08-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day08-2.asf" target="_blank"><span style="font-size:12pt;">ROUND 함수에 대해서</span></a> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day08-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day08-3.asf" target="_blank"><span style="font-size:12pt;">ROUNDUP 함수에 대해서</span></a> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day08-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day08-4.asf" target="_blank"><span style="font-size:12pt;">ROUNDDOWN 함수에 대해서</span></a></TD></TR> <TR> <TD width=43 bgcolor="#CDEDCD"> <P align=center style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;">9</span></TD> <TD width=150 bgcolor="#CDEDCD"> <P style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"> 함수(3)</span></TD> <TD width=442 bgcolor="#CDEDCD"> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day09-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day09-1.asf" target="_blank"><span style="font-size:12pt;">COUNT 함수에 대해서</span></a> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day09-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day09-2.asf" target="_blank"><span style="font-size:12pt;">COUNTBLANK 함수에대해서</span></a> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day09-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day09-3.asf" target="_blank"><span style="font-size:12pt;">COUNTA 함수에 대해서</span></a> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day09-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day09-4.asf" target="_blank"><span style="font-size:12pt;">COUNTIF 함수에 대해서</span></a> </TD></TR> <TR> <TD width=43 bgcolor="#CDEDCD"> <P align=center style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;">10</span></TD> <TD width=150 bgcolor="#CDEDCD"> <P style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"> 함수(4)</span></TD> <TD width=442 bgcolor="#CDEDCD"> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day10-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day10-1.asf" target="_blank"><span style="font-size:12pt;">선택하여 붙여넣기</span></a> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day10-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day10-2.asf" target="_blank"><span style="font-size:12pt;">YEAR 함수애 대해서</span></a> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day10-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day10-3.asf" target="_blank"><span style="font-size:12pt;">질문에 대해서</span></a> <p style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day10-1.asf" target="_blank">-</a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day10-4.asf" target="_blank"><span style="font-size:12pt;">TODAY 함수에 대해서</span></a></TD></TR> <TR> <TD width=43 bgcolor="#CDEDCD"> <P align=center style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;">11</span></TD> <TD width=150 bgcolor="#CDEDCD"> <P style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"> 함수(5)</span></TD> <TD width=442 bgcolor="#CDEDCD"> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day11-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day11-1.asf" target="_blank"><span style="font-size:12pt;">문자함수 사용하기 위해서</span></a> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day11-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day11-2.asf" target="_blank"><span style="font-size:12pt;">LEFT RIGHT 함수</span></a> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day11-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day11-3.asf" target="_blank"><span style="font-size:12pt;">각종함수의 사용</span></a></TD></TR> <TR> <TD width=43 bgcolor="#CDEDCD"> <P align=center style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;">12</span></TD> <TD width=150 bgcolor="#CDEDCD"> <P style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"> 함수(6)</span></TD> <TD width=442 bgcolor="#CDEDCD"> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day12-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day12-1.asf" target="_blank"><span style="font-size:12pt;">IF 함수</span></a> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day12-1.asf" target="_blank">-</a><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day12-2.asf" target="_blank"> </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day12-2.asf" target="_blank"><span style="font-size:12pt;">IF함수-문자</span></a> <p style="line-height:150%; margin-top:0; margin-bottom:0;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day12-1.asf" target="_blank"><span style="font-size:12pt;">- </span></a><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day12-3.asf" target="_blank"><span style="font-size:12pt;">IF함수-숫자</span></a> <p style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day12-1.asf.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day12-4.asf" target="_blank"><span style="font-size:12pt;">IF함수-END,OR</span></a></TD></TR> <TR> <TD width=43 height="50" bgcolor="#CDEDCD"> <P align=center style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;">13</span></TD> <TD width=150 height="50" bgcolor="#CDEDCD"> <P style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"> 함수(7)</span></TD> <TD width=442 height="50" bgcolor="#CDEDCD"> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day13-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day13-1.asf" target="_blank"><span style="font-size:12pt;">IF함수-성별</span></a><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day13-1.asf" target="_blank"></a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day13-1.asf" target="_blank"><span style="font-size:12pt;">-</span></a><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day13-2.asf" target="_blank"><span style="font-size:12pt;"> IF함수-성별(1</span></a><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day13-2.asf" target="_blank"><span style="font-size:12pt;">)</span></a> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day13-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day13-3.asf" target="_blank"><span style="font-size:12pt;">IF함수-중첩IF</span></a> <p style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day13-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day13-4.asf" target="_blank"><span style="font-size:12pt;">IF와 ROUND함수와의 병용</span></a></TD></TR> <TR> <TD width=43 bgcolor="#CDEDCD"> <P align=center style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;">14</span></TD> <TD width=150 bgcolor="#CDEDCD"> <P style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"> 함수(8)</span></TD> <TD width=442 bgcolor="#CDEDCD"> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day14-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day14-1.asf" target="_blank"><span style="font-size:12pt;">RANK 함수</span></a> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day14-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day14-2.asf" target="_blank"><span style="font-size:12pt;">RANK 함수(1)</span></a> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day14-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day14-3.asf" target="_blank"><span style="font-size:12pt;">RANK 함수(2</span></a><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day14-1.asf" target="_blank"><span style="font-size:12pt;">)</span></a> <p style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day14-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day14-4.asf" target="_blank"><span style="font-size:12pt;">SUMIF 함수</span></a></TD></TR> <TR> <TD width=43 bgcolor="#CDEDCD"> <P align=center style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;">15</span></TD> <TD width=150 bgcolor="#CDEDCD"> <P style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"> 함수(9)</span></TD> <TD width=442 bgcolor="#CDEDCD"> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day15-1.asf" target="_blank">- </a></span><a href="excel2000-day15-1.asf" target="_blank"><span style="font-size:12pt;">데이터베이스란</span></a><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day15-1.asf" target="_blank">?- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day15-2.asf" target="_blank"><span style="font-size:12pt;">DSUM 함수</span></a> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day15-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day15-3.asf" target="_blank"><span style="font-size:12pt;">DCOUNT 함수</span></a></TD></TR> <TR> <TD width=43 bgcolor="#CDEDCD"> <P align=center style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;">16</span></TD> <TD width=150 bgcolor="#CDEDCD"> <P style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"> 함수(10)</span></TD> <TD width=442 bgcolor="#CDEDCD"> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day16-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day16-1.asf" target="_blank"><span style="font-size:12pt;">VLOOKUP 함수</span></a><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day16-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day16-2.asf" target="_blank"><span style="font-size:12pt;">워드와 엑셀데이터의 호환</span></a><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day16-1.asf" target="_blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day16-3.asf" target="_blank"> </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day16-3.asf" target="_blank"><span style="font-size:12pt;">VLOOKUP 함수(1)</span></a> <p style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day16-1.asf" target="_blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day16-4.asf" target="_blank"> </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day16-4.asf" target="_blank"><span style="font-size:12pt;">VLOOKUP 함수 사용시 문제점 해결방안</span></a></TD></TR> <TR> <TD width=43 bgcolor="#CDEDCD"> <P align=center style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;">17</span></TD> <TD width=150 bgcolor="#CDEDCD"> <P style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"> 함수(11)</span></TD> <TD width=442 bgcolor="#CDEDCD"> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day17-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day17-1.asf" target="_blank"><span style="font-size:12pt;">VLOOKUP 함수의 마무리</span></a><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day17-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day17-2.asf" target="_blank"><span style="font-size:12pt;">VLOOKUP 함수의활용</span></a> <p style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day17-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day17-3.asf" target="_blank"><span style="font-size:12pt;">VLOOKUP - 저자 데이터구하기</span></a> <p style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day17-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day17-4.asf" target="_blank"><span style="font-size:12pt;">VLOOKUP - 할인율 구하</span></a><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day17-4.asf" target="_blank">기</a></span> <p style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day17-1.asf" target="_blank">- </a><a href="excel2000-day17-5.asf" target="_blank"> </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day17-5.asf" target="_blank"><span style="font-size:12pt;">HLOOKUP함수</span></a></TD></TR> <TR> <TD width=43 bgcolor="#CDEDCD"> <P align=center style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;">18</span></TD> <TD width=150 bgcolor="#CDEDCD"> <P style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"> 셀서식(1)</span></TD> <TD width=442 bgcolor="#CDEDCD"> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day18-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day18-1.asf" target="_blank"><span style="font-size:12pt;">셀서식</span></a><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day18-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day18-2.asf" target="_blank"><span style="font-size:12pt;">셀서식 기능</span></a> <p style="line-height:150%; margin-top:0; margin-bottom:0;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day18-1.asf" target="_blank"><span style="font-size:12pt;">- </span></a><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day18-3.asf" target="_blank"><span style="font-size:12pt;">서식도구 모음줄로 셀 - 지정하기</span></a> <p style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day18-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day18-4.asf" target="_blank"><span style="font-size:12pt;">날짜&통화&회계</span></a></TD></TR> <TR> <TD width=43 height="33" bgcolor="#CDEDCD"> <P align=center style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;">19</span></TD> <TD width=150 height="33" bgcolor="#CDEDCD"> <P style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"> 셀서식(2)</span></TD> <TD width=442 height="33" bgcolor="#CDEDCD"> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day19-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day19-1.asf" target="_blank"><span style="font-size:12pt;">맞춤서식</span></a><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day19-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day19-2.asf" target="_blank"><span style="font-size:12pt;">글꼴서식</span></a></TD></TR> <TR> <TD width=43 height=48 bgcolor="#CDEDCD"> <P align=center style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;">20</span></TD> <TD width=150 height=48 bgcolor="#CDEDCD"> <P style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"> 셀서식(3)</span></TD> <TD width=442 height=48 bgcolor="#CDEDCD"> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day20-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day20-1.asf" target="_blank"><span style="font-size:12pt;">테두리서식</span></a><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day20-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day20-2.asf" target="_blank"><span style="font-size:12pt;">테두리서식 사용방법</span></a><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day20-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day20-3.asf" target="_blank"><span style="font-size:12pt;">무늬서식</span></a></TD></TR> <TR> <TD width=43 bgcolor="#CDEDCD"> <P align=center style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;">21</span></TD> <TD width=150 bgcolor="#CDEDCD"> <P style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"> 서식</span></TD> <TD width=442 bgcolor="#CDEDCD"> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day21-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day21-1.asf" target="_blank"><span style="font-size:12pt;">서식(자동서식등)</span></a><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day21-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day21-2.asf" target="_blank"><span style="font-size:12pt;">자동서식</span></a><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day21-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day21-3.asf" target="_blank"><span style="font-size:12pt;">조건부서식</span></a> <p style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day21-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day21-4.asf" target="_blank"><span style="font-size:12pt;">서식복사</span></a></TD></TR> <TR> <TD width=43 bgcolor="#CDEDCD"> <P align=center style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;">22</span></TD> <TD width=150 bgcolor="#CDEDCD"> <P style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;">기타서식</span></TD> <TD width=442 bgcolor="#CDEDCD"> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day22-1.asf" target="_blank">-</a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day22-1.asf" target="_blank"><span style="font-size:12pt;">스타일서식등</span></a><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day22-1.asf" target="_blank">-</a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day22-2.asf" target="_blank"><span style="font-size:12pt;">서식의 스타일적용</span></a><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day22-1.asf" target="_blank">-</a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day22-3.asf" target="_blank"><span style="font-size:12pt;">스타일의 복사.삭제</span></a><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day22-1.asf" target="_blank"></a></span> <p style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day22-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day22-4.asf" target="_blank"><span style="font-size:12pt;">시트서식</span></a> <p style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day22-1.asf" target="_blank">- </a><a href="excel2000-day22-5.asf" target="_blank"> </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day22-5.asf" target="_blank"><span style="font-size:12pt;">셀 보호기능</span></a></TD></TR> <TR> <TD width=43 bgcolor="#CDEDCD"> <P align=center style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;">23</span></TD> <TD width=150 bgcolor="#CDEDCD"> <P style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"> 챠트(1)</span></TD> <TD width=442 bgcolor="#CDEDCD"> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day23-1.asf" target="_blank"><span style="font-size:12pt;">-챠트 </span></a><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day23-1.asf" target="_blank">-</a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day23-2.asf" target="_blank"><span style="font-size:12pt;">챠트 서식</span></a><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day23-1.asf" target="_blank">-</a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day23-3.asf" target="_blank"><span style="font-size:12pt;">챠트 변경하기</span></a></TD></TR> <TR> <TD width=43 height=21 bgcolor="#CDEDCD"> <P align=center style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;">24</span></TD> <TD width=150 height=21 bgcolor="#CDEDCD"> <P style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"> 챠트(2)</span></TD> <TD width=442 height=21 bgcolor="#CDEDCD"> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day24-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day24-1.asf" target="_blank"><span style="font-size:12pt;">챠트총정리</span></a><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day24-1.asf" target="_blank">-</a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day24-1.asf" target="_blank"><span style="font-size:12pt;"> </span></a><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day24-2.asf" target="_blank"><span style="font-size:12pt;">챠트옵션등</span></a><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day24-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day24-3.asf" target="_blank"><span style="font-size:12pt;">챠트영역서식</span></a><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day24-1.asf" target="_blank"></a></span> <p style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day24-1.asf" target="_blank">-</a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day24-1.asf" target="_blank"><span style="font-size:12pt;"> </span></a><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day24-4.asf" target="_blank"><span style="font-size:12pt;">원본데이터등</span></a> <p style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day24-1.asf" target="_blank">-</a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day24-1.asf" target="_blank"><span style="font-size:12pt;"> </span></a><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day24-5.asf" target="_blank"><span style="font-size:12pt;">원형챠트만들기</span></a></TD></TR> <TR> <TD width=43 bgcolor="#CDEDCD"> <P align=center style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;">25</span></TD> <TD width=150 bgcolor="#CDEDCD"> <P style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"> 개체</span></TD> <TD width=442 bgcolor="#CDEDCD"> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day25-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day25-1.asf" target="_blank"><span style="font-size:12pt;">크립아트</span></a><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day25-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day25-2.asf" target="_blank"><span style="font-size:12pt;">그림</span></a><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day25-1.asf" target="_blank">-</a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day25-1.asf" target="_blank"><span style="font-size:12pt;"> </span></a><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day25-3.asf" target="_blank"><span style="font-size:12pt;">도형</span></a> <p style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day25-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day25-4.asf" target="_blank"><span style="font-size:12pt;">워드아트기능</span></a></TD></TR> <TR> <TD width=43 bgcolor="#CDEDCD"> <P align=center style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;">26</span></TD> <TD width=150 bgcolor="#CDEDCD"> <P style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"> 데이터 베이스</span></TD> <TD width=442 bgcolor="#CDEDCD"> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day26-1.asf" target="_blank"><span style="font-size:12pt;">- 데이터 베이스</span></a><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day26-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day26-2.asf" target="_blank"><span style="font-size:12pt;">데이터 정열</span></a><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day26-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day26-3.asf" target="_blank"><span style="font-size:12pt;">자동필터</span></a> <p style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day26-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day26-4.asf" target="_blank"><span style="font-size:12pt;">고급필터</span></a></TD></TR> <TR> <TD width=43 bgcolor="#CDEDCD"> <P align=center style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;">27</span></TD> <TD width=150 bgcolor="#CDEDCD"> <P style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"> 데이터 베이스</span></TD> <TD width=442 bgcolor="#CDEDCD"> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day27-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day27-1.asf" target="_blank"><span style="font-size:12pt;">엘셀의 데이터베이스 기능</span></a><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day27-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day27-2.asf" target="_blank"><span style="font-size:12pt;">부분합</span></a><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day27-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day27-3.asf" target="_blank"><span style="font-size:12pt;">부분합의 다른방법</span></a> <p style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day27-1.asf" target="_blank">-</a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day27-1.asf" target="_blank"><span style="font-size:12pt;"> </span></a><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day27-4.asf" target="_blank"><span style="font-size:12pt;">피벗테이블</span></a> <p style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day27-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day27-5.asf" target="_blank"><span style="font-size:12pt;">레코드 관리작업</span></a></TD></TR> <TR> <TD width=43 bgcolor="#CDEDCD"> <P align=center style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;">28</span></TD> <TD width=150 bgcolor="#CDEDCD"> <P style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"> 인쇄</span></TD> <TD width=442 bgcolor="#CDEDCD"> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;">-</span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day28-1.asf" target="_blank"><span style="font-size:12pt;"> 인쇄(미리보기등)</span></a><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day28-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day28-2.asf" target="_blank"><span style="font-size:12pt;">인쇄(여백기능)</span></a><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day28-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day28-3.asf" target="_blank"><span style="font-size:12pt;">인쇄(설정기능)</span></a> <p style="line-height:150%; margin-top:0; margin-bottom:0;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day28-1.asf" target="_blank"><span style="font-size:12pt;">- </span></a><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day28-4.asf" target="_blank"><span style="font-size:12pt;">인쇄(인쇄범위)</span></a> <p style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day28-1.asf" target="_blank">-</a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day28-1.asf" target="_blank"><span style="font-size:12pt;"> </span></a><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day28-5.asf" target="_blank"><span style="font-size:12pt;">인쇄(페이지 나누기)</span></a></TD></TR> <TR> <TD width=43 bgcolor="#CDEDCD"> <P align=center style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;">29</span></TD> <TD width=150 bgcolor="#CDEDCD"> <P style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"> 기타 기능(1)</span></TD> <TD width=442 bgcolor="#CDEDCD"> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day29-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day29-1.asf" target="_blank"><span style="font-size:12pt;">기타</span></a><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day29-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day29-2.asf" target="_blank"><span style="font-size:12pt;">메모기능</span></a><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day29-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day29-3.asf" target="_blank"><span style="font-size:12pt;">챠트를 워드프로세서와 연결</span></a><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day29-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day29-4.asf" target="_blank"><span style="font-size:12pt;">틀고정</span></a></TD></TR> <TR> <TD width=43 bgcolor="#CDEDCD"> <P align=center style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;">30</span></TD> <TD width=150 bgcolor="#CDEDCD"> <P style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"> 기타 기능(2)</span></TD> <TD width=442 bgcolor="#CDEDCD"> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day30-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day30-1.asf" target="_blank"><span style="font-size:12pt;">카메라등, 하이퍼링크등</span></a> <p style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day30-2.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day30-2.asf" target="_blank"><span style="font-size:12pt;">카메라기능</span></a> <p style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day30-1.asf" target="_blank">-</a><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day30-3.asf" target="_blank"> </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day30-3.asf" target="_blank"><span style="font-size:12pt;">결재란 카메라로이용하기</span></a> <p style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day30-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day30-4.asf" target="_blank"><span style="font-size:12pt;">하이퍼링크 기능에 대해서</span></a> <p style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day30-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day30-5.asf" target="_blank"><span style="font-size:12pt;">찾기 바꾸기</span></a> <p style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;"><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day30-1.asf" target="_blank">- </a></span><a href="http://www.fire.seoul.kr/data/excel2000/excel2000-day30-6.asf" target="_blank"><span style="font-size:12pt;">시트보호와 통합문서 보호</span></a></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
<TABLE width=746 border=0> <TBODY> <TR> <TD width="366" colSpan=2> </TD> <TD width="370" colSpan=2> </TD></TR> <TR> <TD width=740 colSpan=4> <TABLE width=740 border="2" bordercolor="white"> <TBODY> <TR> <TD width=128 bgColor="#CDEDCD" bordercolorlight="#CDEDCD"> <P align=center><B>과 정 이 름</B></TD> <TD width=596 bgcolor="#CDEDCD" bordercolorlight="#CDEDCD"> <P align=left> 엑셀2000 중급과정</TD></TR> <TR> <TD width=128 bgColor="#CDEDCD" bordercolorlight="#CDEDCD"> <P align=center><B>강 사 명</B></TD> <TD width=596 bgcolor="#CDEDCD" bordercolorlight="#CDEDCD"> <P align=left> 곽 성 숙</TD></TR></TBODY></TABLE></TD></TR> <TR> <TD width=133> </TD> <TD width="229"> </TD> <TD width="184"> </TD> <TD width=182> </TD></TR> <TR> <TD width="366" colSpan=2> <B>세부일정소개</B></TD> <TD width="370" colSpan=2> 해당강의목록을 클릭하시면 동영상이 실행됩니다</TD></TR> <TR> <TD width=740 colSpan=4> <TABLE width=740 border="2" bordercolor="white"> <TBODY> <TR> <TD width=43 bgColor="#CDEDCD"> <P align=center><span style="font-size:12pt;">회 수</span></TD> <TD width=150 bgColor="#CDEDCD"> <P align=center><span style="font-size:12pt;">강 의 제 목</span></TD> <TD width=442 bgColor="#CDEDCD"> <P align=center><span style="font-size:12pt;">강 의 내 용</span></TD></TR><TR> <TD width=43 bgcolor="#CDEDCD"> <P align=center style="line-height:100%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;">0</span></TD> <TD width=150 bgcolor="#CDEDCD"> 간단한 도움말</span> <P style="line-height:100%; margin-top:0; margin-bottom:0;"><SPAN style="font-size:12pt;"><FONT face=굴림체,굴림체></FONT></SPAN></TD> <TD width=442 bgcolor="#CDEDCD"> <P style="line-height:150%; margin-top:0; margin-bottom:0;"><span style="font-size:12pt;">엑셀은 가계부나 서류정리 여러가지을 하실수 있읍니다가계 가시면 컴퓨터로 계산을 하시는것을 보셨을것입니다그런기능이라 생각을 하시면 됩니다물론 그것과 틀리지만 그런기능이 아마 이것이 발전해서 만들어 졌다고 하더군요엑셀은 사무실에서 매우 유용하게 사용을 하고 있읍니다시간은 오래 걸리지만 배워 두시면 집 사무실 어디에서나 사용을 하실수 있읍니다</TD></TR><TR><TD height=104 width=43 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=center>1</TD><TD height=104 width=150 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P style="MARGIN-LEFT: 3mm"><FONT size=2>워크시트 다루기</font></TD><TD height=104 width=442 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align="left" style="MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px">- <a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day1-1.asf" target="-blank"><span style="font-size:12pt;">수식을 통하여 다른 워크시트와 연결</a><P style="MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px" align="left">- <a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day1-2.asf" target="-blank"><span style="font-size:12pt;">다른 워크시트의 데이터 참조하기</a><P style="MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px" align="left">- <a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day1-3.asf" target="-blank"><span style="font-size:12pt;">연결하여 붙여넣기</a><P style="MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px" align="left">- <a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day1-4.asf" target="-blank""><span style="font-size:12pt;">연결하여 붙여넣기1</a><P align="left" style="MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px">- <a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day1-5.asf" target="-blank"><span style="font-size:12pt;">범위 이름을 지정하여 데이터 참조하기</a><P align="left" style="MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href=" http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day1-6.asf" traget="-blank">- </a><a href=" http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day1-6.asf" traget="-blank"><span style="font-size:12pt;">범위 이름을 지정하여 데이터 참조하기</a><P align="left" style="MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href=" http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day1-7.asf" traget="-blank">- </a><a href=" http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day1-7.asf" traget="-blank"><span style="font-size:12pt;">수식을 통하여 다른 통합문서와 연결하기</a> <p align="left" style="text-indent:0px; margin-top:0px; margin-right:2px; margin-bottom:0px; margin-left:3mm;"><a href=" http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day1-8.asf" traget="-blank">- </a><a href=" http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day1-8.asf" traget="-blank"> <span style="font-size:12pt;">작업상태 파일만들</a><a href=" http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day1-8.asf" traget="-blank">기</a></TD></TR><TR><TD height=103 width=43 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=center><FONT size=2>2</FONT></TD><TD height=103 width=150 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P style="MARGIN-LEFT: 3mm"><FONT size=2>엑셀 함수1</FONT></TD><TD height=103 width=442 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=justify style="MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day2-1.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day2-1.asf" traget="-blank"><span style="font-size:12pt;">IF함수의 응용</a><P align=justify style="MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day2-2.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day2-2.asf" traget="-blank"><span style="font-size:12pt;">사용 함수 목록</a><DIV align=justify><P style="MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day2-3.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day2-3.asf" traget="-blank"><span style="font-size:12pt;">예제를 통해 함수 확인하기1</a><P style="MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day2-4.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day2-4.asf" traget="-blank"><span style="font-size:12pt;">예제를 통해 함수 확인하기2</a></DIV><P align=justify style="MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day2-5.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day2-5.asf" traget="-blank"><span style="font-size:12pt;">컨트롤 개체와 셀의 연결</a><DIV align=justify><P style="MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day2-6.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day2-6.asf" traget="-blank"><span style="font-size:12pt;">컨트롤 개체란?</a><P style="MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day2-7.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day2-7.asf" traget="-blank"><span style="font-size:12pt;">컨트롤의 종류</a></DIV></TD></TR><TR><TD height="95" width=43 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=center><FONT size=2>3</FONT></TD><TD height="95" width=150 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P style="MARGIN-LEFT: 3mm"><FONT size=2>엑셀의 오류값과 엑셀 함수2</FONT></TD><TD height="95" width=442 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=justify style="MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day3-1.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day3-1.asf" traget="-blank"><span style="font-size:12pt;">수식에서 발생되는 오류값의 종류와 원인</a> <p align="justify" style="text-indent:0px; margin-top:0px; margin-right:2px; margin-bottom:0px; margin-left:3mm;">-<a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day3-2.asf" traget="-blank"> </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day3-2.asf" traget="-blank"><span style="font-size:12pt;">오류값을 표시하지 않으려면?</a><DIV align=justify><P style="MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day3-3.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day3-3.asf" traget="-blank"><span style="font-size:12pt;">INDEX, MATCH 함수</a><P style="MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day3-4.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day3-4.asf" traget="-blank"><span style="font-size:12pt;">INDEX, MATCH 함수1</a><P style="MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day3-5.asf" traget="-blank">-</a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day3-5.asf" traget="-blank"> <span style="font-size:12pt;">INDEX, MATCH 함수2</a></DIV> <p align="justify" style="text-indent:0px; margin-top:0px; margin-right:2px; margin-bottom:0px; margin-left:3mm;"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day3-6.asf" traget="-blank">-</a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day3-6.asf" traget="-blank"><span style="font-size:12pt;">콤보상자와 셀의 연결</a></TD></TR><TR><TD height=69 width=43 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=center><FONT size=2>4</FONT></TD><TD height=69 width=150 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P style="MARGIN-LEFT: 3mm"><FONT size=2>엑셀 함수3-날짜, 시간 함수</FONT></TD><TD height=69 width=442 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day4-1.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day4-1.asf" traget="-blank"><span style="font-size:12pt;">날짜, 시간 함수</a><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day4-2.asf" traget="-blank">-</a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day4-2.asf" traget="-blank"><span style="font-size:12pt;"> datedif 함수</a><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day4-3.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day4-3.asf" traget="-blank"><span style="font-size:12pt;">날짜, 시간 계산하기</a> <p align="justify" style="text-indent:0px; line-height:110%; margin-top:0px; margin-right:2px; margin-bottom:0px; margin-left:3mm;"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day4-4.asf" traget="-blank">-</a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day4-4.asf" traget="-blank"> <span style="font-size:12pt;">예제 - 근무 년수 구하기</a></TD></TR><TR><TD height=75 width=43 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=center><FONT size=2>5</FONT></TD><TD height=75 width=150 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><FONT size=2>엑셀함수4-OFFSET 함수</FONT></TD><TD height=75 width=442 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day5-1.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day5-1.asf" traget="-blank"><span style="font-size:12pt;">OFFSET 함수</a><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day5-2.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day5-2.asf" traget="-blank"><span style="font-size:12pt;">OFFSET 함수1</a><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day5-3.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day5-3.asf" traget="-blank"><span style="font-size:12pt;">임의의 범위 데이터 계산하기</a><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day5-4.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day5-4.asf" traget="-blank"><span style="font-size:12pt;">임의의 범위 데이터 계산하기1</a><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day5-5.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day5-5.asf" traget="-blank"><span style="font-size:12pt;">OFFSET 함수와 INDEX 함수</a><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day5-6.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day5-6.asf" traget="-blank"><span style="font-size:12pt;">컨트롤과 연결하여 가격 구하기</a></TD></TR><TR><TD height=72 width=43 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=center><FONT size=2>6</FONT></TD><TD height=72 width=150 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><FONT size=2>사용자 정의 서식</FONT></TD><TD height=72 width=442 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day6-1.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day6-1.asf" traget="-blank"><span style="font-size:12pt;">사용자 정의 서식 기호</a><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day6-2.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day6-2.asf" traget="-blank"><span style="font-size:12pt;">숫자 서식 코드</a><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day6-3.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day6-3.asf" traget="-blank"><span style="font-size:12pt;">날짜, 시간 서식 코드</a><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day6-4.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day6-4.asf" traget="-blank"><span style="font-size:12pt;">사용자 정의 서식 응용하기</a><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day6-5.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day6-5.asf" traget="-blank"><span style="font-size:12pt;">사용자 정의 서식에 조건주기</a><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day6-6.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day6-6.asf" traget="-blank"><span style="font-size:12pt;">사용자 정의 서식 Tip</a></TD></TR><TR><TD height=73 width=43 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=center><FONT size=2>7</FONT></TD><TD height=73 width=150 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P style="MARGIN-LEFT: 3mm"><FONT size=2>차트 그리기</FONT></TD><TD height=73 width=442 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day7-1.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day7-1.asf" traget="-blank"><span style="font-size:12pt;">차트에 동적 데이터 연결하기</a><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day7-2.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day7-2.asf" traget="-blank"><span style="font-size:12pt;">차트 데이터 연결 수식</a><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day7-3.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day7-3.asf" traget="-blank"><span style="font-size:12pt;">다중 계열 차트에 연결</a><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day7-4.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day7-4.asf" traget="-blank"><span style="font-size:12pt;">그림 차트 작성하기</a><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day7-5.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day7-5.asf" traget="-blank"><span style="font-size:12pt;">이중 차트 작성하기</a></TD></TR><TR><TD height=87 width=43 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=center><FONT size=2>8</FONT></TD><TD height=87 width=150 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P style="MARGIN-LEFT: 3mm"><FONT size=2>자료 분석과 요약1</FONT></TD><TD height=87 width=442 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day8-1.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day8-1.asf" traget="-blank"><span style="font-size:12pt;">고급 필터 작성하기</a><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day8-2.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day8-2.asf" traget="-blank"><span style="font-size:12pt;">고급 필터에 조건주기</a><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day8-3.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day8-3.asf" traget="-blank"><span style="font-size:12pt;">고급 필터의 비교 조건 종류</a><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day8-4.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day8-4.asf" traget="-blank"><span style="font-size:12pt;">부분합 만들기</a><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day8-5.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day8-1.asf" traget="-blank"><span style="font-size:12pt;">부분합 작성 방법</a></TD></TR><TR><TD height=85 width=43 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=center><FONT size=2>9</FONT></TD><TD height=85 width=150 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P style="MARGIN-LEFT: 3mm"><FONT size=2>자료 분석과 요약2</FONT></TD><TD height=85 width=442 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day9-1.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day9-1.asf" traget="-blank"><span style="font-size:12pt;">피벗 테이블 만들기</a><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day9-2.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day9-2.asf" traget="-blank"><span style="font-size:12pt;">다른 피벗 테이블로 피벗 테이블 만들기</a><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px">-<a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day9-3.asf" traget="-blank"> </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day9-3.asf" traget="-blank"><span style="font-size:12pt;">다중 통합 범위로 피벗 테이블 만들기</a><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day9-4.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day9-4.asf" traget="-blank"><span style="font-size:12pt;">데이터 통합하기</a><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day9-5.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day9-5.asf" traget="-blank"><span style="font-size:12pt;">항목을 기준으로 데이터 통합</a></TD></TR><TR><TD height=87 width=43 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=center><FONT size=2>10</FONT></TD><TD height=87 width=150 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P style="MARGIN-LEFT: 3mm"><FONT size=2>자료 분석과 요약3</FONT></TD><TD height=87 width=442 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P style="LINE-HEIGHT: 100%; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 3mm; MARGIN-TOP: 0px"><FONT size=2><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day10-1.asf">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day10-1.asf"><span style="font-size:12pt;">외부 데이터 가져오기</a></FONT><P style="LINE-HEIGHT: 100%; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 3mm; MARGIN-TOP: 0px"><FONT size=2><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day10-2.asf">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day10-2.asf"><span style="font-size:12pt;">외부 데이터를 가져오는 방법</a></FONT><P style="LINE-HEIGHT: 100%; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 3mm; MARGIN-TOP: 0px"><FONT size=2><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day10-3.asf">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day10-3.asf"><span style="font-size:12pt;">외부 데이터로 피벗 테이블 만들기</a></FONT></TD></TR><TR><TD height=72 width=43 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=center><FONT size=2>11</FONT></TD><TD height=72 width=150 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><FONT size=2>값을 예측하기1</FONT></TD><TD height=72 width=442 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=justify style="LINE-HEIGHT: 100%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px">- <a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day11-1.asf" traget="-blank"><span style="font-size:12pt;">값을 예측하기</a> <p align="justify" style="text-indent:0px; line-height:100%; margin-top:0px; margin-right:2px; margin-bottom:0px; margin-left:3mm;"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day11-2.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day11-2.asf" traget="-blank"><span style="font-size:12pt;">변수가 두개인 표 작성하기</a><P align=justify style="LINE-HEIGHT: 100%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day11-3.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day11-1.asf" traget="-blank"><span style="font-size:12pt;">목표값 찾기</a></TD></TR><TR><TD height=72 width=43 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=center><FONT size=2>12</FONT></TD><TD height=72 width=150 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><FONT size=2>값을 예측하기2</FONT></TD><TD height=72 width=442 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=justify style="LINE-HEIGHT: 100%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day12-1.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day12-1.asf" traget="-blank"><span style="font-size:12pt;">시나리오</a> <p align="justify" style="text-indent:0px; line-height:100%; margin-top:0px; margin-right:2px; margin-bottom:0px; margin-left:3mm;"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day12-2.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day12-2.asf" traget="-blank"><span style="font-size:12pt;">도구모음으로 표시하기</a><P align=justify style="LINE-HEIGHT: 100%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day12-3.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day12-3.asf" traget="-blank"><span style="font-size:12pt;">시나리오 요약 보고서 만들기</a></TD></TR><TR><TD height=73 width=43 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=center><FONT size=2>13</FONT></TD><TD height=73 width=150 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><FONT size=2>양식 도구의 활용1</FONT></TD><TD height=73 width=442 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P style="LINE-HEIGHT: 100%; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 3mm; MARGIN-TOP: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day13-1.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day13-1.asf" traget="-blank"><span style="font-size:12pt;">양식 도구의 종류</a><P style="LINE-HEIGHT: 100%; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 3mm; MARGIN-TOP: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day13-2.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day13-2.asf" traget="-blank"><span style="font-size:12pt;">회전자와 스크롤 막대</a> <p style="line-height:100%; margin-top:0px; margin-bottom:0px; margin-left:3mm;"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day13-3.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day13-3.asf" traget="-blank"><span style="font-size:12pt;">옵션 단추와 확인란</a></TD></TR><TR><TD height=81 width=43 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=center><FONT size=2>14</FONT></TD><TD height=81 width=150 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><FONT size=2>양식 도구의 활용2</FONT></TD><TD height=81 width=442 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P style="LINE-HEIGHT: 100%; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 3mm; MARGIN-TOP: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day14-1.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day14-1.asf" traget="-blank"><span style="font-size:12pt;">사용자 입력 화면 꾸미기</a><P style="LINE-HEIGHT: 100%; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 3mm; MARGIN-TOP: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day14-2.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day14-2.asf" traget="-blank"><span style="font-size:12pt;">카메라 활용하기</a><P style="LINE-HEIGHT: 100%; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 3mm; MARGIN-TOP: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day14-3.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day14-3.asf" traget="-blank"><span style="font-size:12pt;">컨트롤 서식 지정하기</a></TD></TR><TR><TD height=56 width=43 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=center><FONT size=2>15</FONT></TD><TD height=56 width=150 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><FONT size=2>유효성 검사의 활용</FONT></TD><TD height=56 width=442 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=justify style="LINE-HEIGHT: 100%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day15-1.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day15-1.asf" traget="-blank"><span style="font-size:12pt;">유효성 검사</a><P align=justify style="LINE-HEIGHT: 100%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day15-2.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day15-2.asf" traget="-blank"><span style="font-size:12pt;">설명 메시지와 오류 메시지</a><P align=justify style="LINE-HEIGHT: 100%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day15-3.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day15-3.asf" traget="-blank"><span style="font-size:12pt;">잘못된 데이터 추적</a><P align=justify style="LINE-HEIGHT: 100%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day15-4.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day15-4.asf" traget="-blank"><span style="font-size:12pt;">유효성 검사 활용 예</a></TD></TR><TR><TD height=67 width=43 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=center><FONT size=2>16</FONT></TD><TD height=67 width=150 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><FONT size=2>매크로의 활용1</FONT></TD><TD height=67 width=442 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day16-1.asf">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day16-1.asf"><span style="font-size:12pt;">매크로 활용</a><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day16-2.asf">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day16-2.asf"><span style="font-size:12pt;">상대 참조</a><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day16-3.asf">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day16-3.asf"><span style="font-size:12pt;">매크로 실행</a><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day16-4.asf">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day16-4.asf"><span style="font-size:12pt;">도구 모음 단추를 사용하여 실행</a> <p align="justify" style="text-indent:0px; line-height:110%; margin-top:0px; margin-right:2px; margin-bottom:0px; margin-left:3mm;"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day16-5.asf">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day16-5.asf"><span style="font-size:12pt;">매뉴를 사용하여 실행</a></TD></TR><TR><TD height=79 width=43 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=center><FONT size=2>17</FONT></TD><TD height=79 width=150 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><FONT size=2>매크로의 활용2</FONT></TD><TD height=79 width=442 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day17-1.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day17-1.asf" traget="-blank"><span style="font-size:12pt;">Visual Basic Editor</a><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day17-2.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day17-2.asf" traget="-blank"><span style="font-size:12pt;">Visual Basic Editor 창 구성 요소</a><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day17-3.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day17-3.asf" traget="-blank"><span style="font-size:12pt;">매크로 수정</a><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day17-4.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day17-4.asf" traget="-blank"><span style="font-size:12pt;">매크로 내용 수정</a></TD></TR><TR><TD height=50 width=43 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=center><FONT size=2>18</FONT></TD><TD height=50 width=150 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><FONT size=2>VBA 이해1</FONT></TD><TD height=50 width=442 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day18-1.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day18-1.asf" traget="-blank"><span style="font-size:12pt;">개체, 속성, 메서드</a><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day18-2.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day18-2.asf" traget="-blank"><span style="font-size:12pt;">속성</a> <p align="justify" style="text-indent:0px; line-height:110%; margin-top:0px; margin-right:2px; margin-bottom:0px; margin-left:3mm;"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day18-3.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day18-3.asf" traget="-blank"><span style="font-size:12pt;">메서드</a></TD></TR><TR><TD height=51 width=43 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=center><FONT size=2>19</FONT></TD><TD height=51 width=150 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><FONT size=2>VBA 이해2</FONT></TD><TD height=51 width=442 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day19-1.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day19-1.asf" traget="-blank"><span style="font-size:12pt;">프로시저의 이해</a><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day19-2.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day19-2.asf" traget="-blank"><span style="font-size:12pt;">Sub 프로시</a>져<P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day19-3.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day19-3.asf" traget="-blank"><span style="font-size:12pt;">개체의 활용1</a><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day19-4.asf" traget="-blank">-</a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day19-4.asf" traget="-blank"><span style="font-size:12pt;"> Workbook 개체</a></TD></TR><TR><TD height=52 width=43 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=center><FONT size=2>20</FONT></TD><TD height=52 width=150 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P style="MARGIN-LEFT: 3mm"><FONT size=2>VBA 이해3</FONT></TD><TD height=52 width=442 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P style="LINE-HEIGHT: 100%; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 3mm; MARGIN-TOP: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day20-1.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day20-1.asf" traget="-blank"><span style="font-size:12pt;">개체의 활용2</a><P style="LINE-HEIGHT: 100%; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 3mm; MARGIN-TOP: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day20-2.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day20-2.asf" traget="-blank"><span style="font-size:12pt;">Range 개체</a></TD></TR><TR><TD height=57 width=43 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=center><FONT size=2>21</FONT></TD><TD height=57 width=150 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><FONT size=2>VBA 이해4</FONT></TD><TD height=57 width=442 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day21-1.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day21-1.asf" traget="-blank"><span style="font-size:12pt;">변수데이터 형식</a><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day21-2.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day21-2.asf" traget="-blank"><span style="font-size:12pt;">변수의 수명</a><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day21-3.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day21-3.asf" traget="-blank"><span style="font-size:12pt;">상수</a></TD></TR><TR><TD height=66 width=43 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=center><FONT size=2>22</FONT></TD><TD height=66 width=150 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><FONT size=2>VBA 이해5</FONT></TD><TD height=66 width=442 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day22-1.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day22-1.asf" traget="-blank"><span style="font-size:12pt;">일차원 배열</a><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day22-2.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day22-2.asf" traget="-blank"><span style="font-size:12pt;">InputBox 함수와 MsgBox 함수</a><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day22-3.asf" traget="-blank">-</a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day22-3.asf" traget="-blank"><span style="font-size:12pt;"> MsgBox 함수</a></TD></TR><TR><TD height="51" width=43 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=center><FONT size=2>23</FONT></TD><TD height="51" width=150 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P style="MARGIN-LEFT: 3mm"><FONT size=2>VBA 이해6</FONT></TD><TD height="51" width=442 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day23-1.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day23-1.asf" traget="-blank"><span style="font-size:12pt;">제어문1 - If ~ Then문</a><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day23-2.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day23-2.asf" traget="-blank"><span style="font-size:12pt;">For ~ Next문</a></TD></TR><TR><TD height=53 width=43 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=center><FONT size=2>24</FONT></TD><TD height=53 width=150 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><FONT size=2>VBA 이해7</FONT></TD><TD height=53 width=442 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day24-1.asf" traget="-blank">-</a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day24-1.asf" traget="-blank"> <span style="font-size:12pt;">Select ~ case문</a><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day24-2.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day24-2.asf" traget="-blank"><span style="font-size:12pt;">Do ~ Loop문</a><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day24-3.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day24-3.asf" traget="-blank"><span style="font-size:12pt;">On Error GoTo문</a></TD></TR><TR><TD height=52 width=43 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=center><FONT size=2>25</FONT></TD><TD height=52 width=150 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><FONT size=2>사용자 정의 대화 상자1</FONT></TD><TD height=52 width=442 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"> <P style="LINE-HEIGHT: 100%; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 3mm; MARGIN-TOP: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day25-1.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day25-1.asf" traget="-blank"><span style="font-size:12pt;">사용자 정의 폼 만들기</a><P style="LINE-HEIGHT: 100%; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 3mm; MARGIN-TOP: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day25-2.asf" traget="-blank">-</a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day25-2.asf" traget="-blank"><span style="font-size:12pt;"> 컨트롤의 사용</a><P style="LINE-HEIGHT: 100%; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 3mm; MARGIN-TOP: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day25-3.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day25-3.asf" traget="-blank"><span style="font-size:12pt;">컨트롤 활용하기</a></TD></TR><TR><TD height=54 width=43 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=center><FONT size=2>26</FONT></TD><TD height=54 width=150 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><FONT size=2>사용자 정의 대화 상자2</FONT></TD><TD height=54 width=442 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day26-1.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day26-1.asf" traget="-blank"><span style="font-size:12pt;">사용자 정의 대화 상자의 활용</a><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day26-2.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day26-2.asf" traget="-blank"><span style="font-size:12pt;">이벤트프로시져 사용하기</a><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day26-3.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day26-3.asf" traget="-blank"><span style="font-size:12pt;">날짜 확인 대화 상자</a></TD></TR><TR><TD height=50 width=43 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=center><FONT size=2>27</FONT></TD><TD height=50 width=150 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P style="MARGIN-LEFT: 3mm"><FONT size=2>사용자 정의 대화 상자3</FONT></TD><TD height=50 width=442 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day27-1.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day27-1.asf" traget="-blank"><span style="font-size:12pt;">사용자 정의 대화 상자의 활용3</a> <p align="justify" style="text-indent:0px; line-height:110%; margin-top:0px; margin-right:2px; margin-bottom:0px; margin-left:3mm;"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day27-2.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day27-2.asf" traget="-blank"><span style="font-size:12pt;">이벤트프로시져 작성하기</a> <p align="justify" style="text-indent:0px; line-height:110%; margin-top:0px; margin-right:2px; margin-bottom:0px; margin-left:3mm;"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day27-3.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day27-3.asf" traget="-blank"><span style="font-size:12pt;">워크시트에 실행단추 사용하기</a></TD></TR><TR><TD height=53 width=43 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=center><FONT size=2>28</FONT></TD><TD height=53 width=150 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P style="MARGIN-LEFT: 3mm"><FONT size=2>사용자 정의 대화 상자4</FONT></TD><TD height=53 width=442 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P style="LINE-HEIGHT: 100%; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 3mm; MARGIN-TOP: 0px"><a href="28일/exl2000ad-day28-1.asf" traget="-blank">- </a><a href="exl2000ad-day28-1.asf" traget="-blank"><span style="font-size:12pt;">사용자 정의대화상자 4</a><P style="LINE-HEIGHT: 100%; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 3mm; MARGIN-TOP: 0px"><a href="28일/exl2000ad-day28-2.asf" traget="-blank">- </a><a href="exl2000ad-day28-2.asf" traget="-blank"><span style="font-size:12pt;">도서 대출 카드 대화 상자 만들기</a> <p style="line-height:100%; margin-top:0px; margin-bottom:0px; margin-left:3mm;"><a href="28일/exl2000ad-day28-3.asf" traget="-blank">- </a><a href="exl2000ad-day28-3.asf" traget="-blank"><span style="font-size:12pt;">이벤트프로시져 작성하기</a></TD></TR><TR><TD height=53 width=43 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=center><FONT size=2>29</FONT></TD><TD height=53 width=150 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P style="MARGIN-LEFT: 3mm"><FONT size=2>VBA 활용 Tip</FONT></TD><TD height=53 width=442 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P style="LINE-HEIGHT: 100%; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 3mm; MARGIN-TOP: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day29-1.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day29-1.asf" traget="-blank"><span style="font-size:12pt;">자동 실행 프로시저</a><P style="LINE-HEIGHT: 100%; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 3mm; MARGIN-TOP: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day29-2.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day29-2.asf" traget="-blank"><span style="font-size:12pt;">자동 실행 프로시저 1</a> <p style="line-height:100%; margin-top:0px; margin-bottom:0px; margin-left:3mm;"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day29-3.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day29-3.asf" traget="-blank"><span style="font-size:12pt;">auto_close()</a></TD></TR><TR><TD height=62 width=43 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=center><FONT size=2>30</FONT></TD><TD height=62 width=150 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P style="MARGIN-LEFT: 3mm"><FONT size=2>차트 활용하기</FONT></TD><TD height=62 width=442 bgcolor="#CDEDCD" bordercolordark="#CDEDCD" bordercolorlight="#CDEDCD"><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day30-1.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day30-1.asf" traget="-blank"><span style="font-size:12pt;">차트 속성과 메서드</a> <p align="justify" style="text-indent:0px; line-height:110%; margin-top:0px; margin-right:2px; margin-bottom:0px; margin-left:3mm;"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day30-2.asf" traget="-blank">-</a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day30-2.asf" traget="-blank"><span style="font-size:12pt;">작성된 매크로 확인</a><P align=justify style="LINE-HEIGHT: 110%; MARGIN: 0px 2px 0px 3mm; TEXT-INDENT: 0px"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day30-3.asf" traget="-blank">- </a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day30-3.asf" traget="-blank"><span style="font-size:12pt;">차트 작성 프로시저</a> <p align="justify" style="text-indent:0px; line-height:110%; margin-top:0px; margin-right:2px; margin-bottom:0px; margin-left:3mm;"><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day30-4.asf" traget="-blank">-</a><a href="http://www.fire.seoul.kr/data/excel2000(1)/exl2000ad-day30-4.asf" traget="-blank"><span style="font-size:12pt;">작성된 프로그램 내용 확인하기</a></TD></TR></TBODY></TABLE></TD></TR></table>
엑셀강좌
<table border="0" cellpadding="15" cellspacing="0" width="100%">
<tr valign="top">
<TABLE id=AutoNumber4 style="BORDER-COLLAPSE: collapse" borderColor=#111111 height=643 cellSpacing=1 cellPadding=2 width=770 border=0>
<TBODY>
<TR>
<TD align=middle width="13%" bgColor=#5a96d6 height=16><B><FONT face=Tahoma color=#ffffff size=2>강좌 번호</FONT></B></TD>
<TD align=middle width="30%" bgColor=#5a96d6 height=16><B><FONT face=Tahoma color=#ffffff size=2>강좌명</FONT></B></TD>
<TD align=middle width="83%" bgColor=#5a96d6 height=16><B><FONT face=Tahoma color=#ffffff size=2>Description</FONT></B></TD></TR>
<TR>
<TD align=middle width="13%" bgColor=#ffffff height=1><FONT face=Tahoma size=2><A HREF="http://blog.empas.com/kkcooler/MyXls/Lectures/X0101.zip">X0101.zip</A></FONT></TD>
<TD align=left width="30%" bgColor=#ffffff height=1><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0101.zip">자리수 변경하기</A></FONT></TD>
<TD width="53%" bgColor=#ffffff height=1>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>사용자 정의 서식을 응용한 자리수 변경방법</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=1><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0102.zip">X0102.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=1><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0102.zip">유효성 검사Ⅴ</A></FONT></TD>
<TD bgColor=#ffffff height=1>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>콤보 박스를 사용해서 자료 입력하는 방법</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0103.zip">X0103.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0103.zip">유효성 검사Ⅵ</A></FONT></TD>
<TD bgColor=#ffffff height=18>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>문자열 입력시 자리수 제한하기</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0104.zip">X0104.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0104.zip">자리수 변경하기Ⅱ</A></FONT></TD>
<TD bgColor=#ffffff height=18>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>원단위를 천원으로, 천원단위를 백만원 단위로</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0105.zip">X0105.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0105.zip">타이틀 반복 인쇄하기</A></FONT></TD>
<TD bgColor=#ffffff height=18>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>행과 열 반복 인쇄하기</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0106.zip">X0106.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0106.zip">부서별 인원 추려내기</A></FONT></TD>
<TD bgColor=#ffffff height=18>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>배열수식을 활용한 부서별 상위 3명 추려내기</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0107.zip">X0107.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0107.zip">숫자만 발췌하려면?</A></FONT></TD>
<TD bgColor=#ffffff height=18>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>문자열 중에서 숫자만 뽑아 내기</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0108.zip">X0108.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0108.zip">짝수행만 합계 구하기</A></FONT></TD>
<TD bgColor=#ffffff height=18>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>짝수행/홀수행 합계 구하기</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0109.zip">X0109.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0109.zip">짝수행만 합계 구하기Ⅱ</A></FONT></TD>
<TD bgColor=#ffffff height=18>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>짝수행/홀수행 합계 구하기</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0110.zip">X0110.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0110.zip">일정 행마다 더하기</A></FONT></TD>
<TD bgColor=#ffffff height=18>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>일정 행마다 합계 구하기</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0111.zip">X0111.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0111.zip">반편성 하기</A></FONT></TD>
<TD bgColor=#ffffff height=18>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>배열수식을 활용한 반편성 하기</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0112.zip">X0112.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0112.zip">목록상자를 통한 자료 입력</A></FONT></TD>
<TD bgColor=#ffffff height=18>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>목록상자를 사용해서 자료 입력하기</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0113.zip">X0113.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0113.zip">두 조건을 만족하는 자료검색</A></FONT></TD>
<TD bgColor=#ffffff height=18>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>두가지 조건을 만족하는 자료의 검색</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0114.zip">X0114.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0114.zip">SumProduct()함수</A></FONT></TD>
<TD bgColor=#ffffff height=18>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>SumProduct 함수에 대한 설명 및 활용 예제</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0115.zip">X0115.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0115.zip">글자크기 자동 조절하기</A></FONT></TD>
<TD bgColor=#ffffff height=18>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>셀크기에 따라 글자크기 자동 조절되도록 하기</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0116.zip">X0116.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0116.zip">* 문자 없애기</A></FONT></TD>
<TD bgColor=#ffffff height=18>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>시트 내의 별표(*) 모두 없애기</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0117.zip">X0117.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0117.zip">Mid 함수</A></FONT></TD>
<TD bgColor=#ffffff height=18>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>Mid() 함수의 모든 것!</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0118.zip">X0118.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0118.zip">숫자의 한글 변환</A></FONT></TD>
<TD bgColor=#ffffff height=18>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>사용자 정의 서식 사용, 숫자의 한글/한자 전환</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0119.zip">X0119,zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0119.zip">SumIf 함수에 대하여</A></FONT></TD>
<TD bgColor=#ffffff height=18>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>SumIf() 함수에 대한 Q & A</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0120.zip">X0120.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0120.zip">음수기호 바꾸기</A></FONT></TD>
<TD bgColor=#ffffff height=18>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>음수기호(-)를 "△"로 바꾸려면?</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0121.zip">X0121.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0121.zip">Letter From Abroad</A></FONT></TD>
<TD bgColor=#ffffff height=18>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>영역 내의 중복되지 않는 자료 數 카운팅 하기</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0122.zip">X0122.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0122.zip">음수기호 바꾸기Ⅱ</A></FONT></TD>
<TD bgColor=#ffffff height=18>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>음수기호를 △로 바꾸고 콤마 표시하기</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0123.zip">X0123.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0123.zip">카메라가 기능이 이상할 때</A></FONT></TD>
<TD bgColor=#ffffff height=18>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>카메라 기능이 제대로 작동하지 않을 때 대처법</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0124.zip">X0124.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0124.zip">"0"(Zero)을 중복해서 쓰려면</A></FONT></TD>
<TD bgColor=#ffffff height=18>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>"0" 중복 입력하기(관련 강좌 : <A HREF="http://www.iexceller.com/MyXls/Lectures/X0201.zip">X0201</A>)</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=8><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0125.zip">X0125.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=8><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0125.zip">사용자 정의 서식 총정리</A></FONT></TD>
<TD bgColor=#ffffff height=8>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>사용자 정의 서식의 완결판(총정리)</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=1><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0126.zip">X0126.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=1><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0126.zip">파일 확장자 정리Ⅰ</A></FONT></TD>
<TD bgColor=#ffffff height=1>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>자주 사용되는 파일의 확장자 정리</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0127.zip">X0127.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0127.zip">파일 확장자 정리Ⅱ</A></FONT></TD>
<TD bgColor=#ffffff height=18>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>자주 사용되는 파일의 확장자 정리2</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0128.zip">X0128.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0128.zip">배열수식 활용 예제 한가지</A></FONT></TD>
<TD bgColor=#ffffff height=18>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>거래처별/제품별 판매내역 산출 실전 예제</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0129.zip">X0129.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0129.zip">자리수 변경하기Ⅲ</A></FONT></TD>
<TD bgColor=#ffffff height=18>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>사용자 지정 서식 사용 자리수 변경하기 3탄</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0130.zip">X0130.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0130.zip">여러 시트의 머리글/바닥글 지정</A></FONT></TD>
<TD bgColor=#ffffff height=18>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>여러 시트의 머리글/바닥글 등 한번에 지정하기</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0131.zip">X0131.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0131.zip">작업표시줄에 창 표시하기</A></FONT></TD>
<TD bgColor=#ffffff height=18>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>새로운 방법으로 워크북 넘나들기</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0132.zip">X0132.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0132.zip">작업폴더 지정하기</A></FONT></TD>
<TD bgColor=#ffffff height=18>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>자신만의 작업폴더를 지정하는 방법 설명</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0133.zip">X0133.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0133.zip">단축키 정리</A></FONT></TD>
<TD bgColor=#ffffff height=18>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>Excel에서 빈번히 사용되는 단축키 정리</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0134.zip">X0134.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0134.zip">단축키 정리Ⅱ</A></FONT></TD>
<TD bgColor=#ffffff height=18>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>Excel에서 빈번히 사용되는 단축키 정리 제 2탄</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0135.zip">X0135.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0135.zip">화살표 없애기</A></FONT></TD>
<TD bgColor=#ffffff height=18>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>바탕화면 단축아이콘의 화살표를 손쉽게 없애기</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0136.zip">X0136.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0136.zip">특수 원문자 입력하기</A></FONT></TD>
<TD bgColor=#ffffff height=18>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>16~99까지의 특수 원문자를 입력하는 방법</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0137.zip">X0137.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0137.zip">Rank 함수 응용 예제</A></FONT></TD>
<TD bgColor=#ffffff height=18>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>특정 항목에 가중치를 부여한 석차 매기기</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0138.zip">X0138.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0138.zip">조건부 서식 활용 예제</A></FONT></TD>
<TD bgColor=#ffffff height=18>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>두 가지 조건을 만족하는 자료에 서식 입히기</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0139.zip">X0139.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0139.zip">문자열 데이터를 숫자로 바꾸기</A></FONT></TD>
<TD bgColor=#ffffff height=18>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>문자열 형태의 숫자를 진짜 숫자로 바꾸기</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0140.zip">X0140.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0140.zip">Scandisk 못하게 하기</A></FONT></TD>
<TD bgColor=#ffffff height=18>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>시스템이 Scandisk 못하도록 설정하기</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0141.zip">X0141.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0141.zip">문자열 분리하기</A></FONT></TD>
<TD bgColor=#ffffff height=18>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>문자열 데이터를 여러 셀에 나누어 담기</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0142.zip">X0142.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0142.zip">즉석 계산기능Ⅱ</A></FONT></TD>
<TD bgColor=#ffffff height=18>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>범위 내의 합계/개수/최대값 등 자동 계산하기</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0143.zip">X0143.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0143.zip">Offset 함수 활용 예제 하나</A></FONT></TD>
<TD bgColor=#ffffff height=18>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>지정 범위의 합계와 평균을 실시간으로 구하기</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0144.zip">X0144.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0144.zip">석차구하기 & 열너비/폭 복사</A></FONT></TD>
<TD bgColor=#ffffff height=18>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>가중치 적용, 석차구하기 & 열 너비/폭 복사하기</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0145.zip">X0145.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0145.zip">자리수 변경하기Ⅳ</A></FONT></TD>
<TD bgColor=#ffffff height=18>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>고정소수점 설정을 통한 자리수 변경 방법</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0146.zip">X0146.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0146.zip">컴퓨터 한방에 종료하기</A></FONT></TD>
<TD bgColor=#ffffff height=18>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>시스템을 한방에 Shut down 시키는 방법</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0147.zip">X0147.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0147.zip">숫자만 발췌해서 계산하기</A></FONT></TD>
<TD bgColor=#ffffff height=18>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>문자열과 숫자가 섞인 데이터 연산하기</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0148.zip">X0148.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0148.zip">Excel로 신상명세서 만들기</A></FONT></TD>
<TD bgColor=#ffffff height=18>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>이름정의를 활용한 입체 신상명세서</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0149.zip">X0149.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0149.zip">주민등록번호를 날짜로 바꾸기</A></FONT></TD>
<TD bgColor=#ffffff height=18>
<DIV style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; LINE-HEIGHT: 100%"><FONT face=Tahoma size=2>주민등록번호를 날짜로 바꾸는 방법</FONT></DIV></TD></TR>
<TR>
<TD align=middle bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0150.zip">X0150.zip</A></FONT></TD>
<TD align=left bgColor=#ffffff height=18><FONT face=Tahoma size=2><A HREF="http://www.iexceller.com/MyXls/Lectures/X0150.zip">재미있는 계산방법 하나</A></FONT></TD>
<TD bgColor=#ffffff height=18><FONT face=Tahoma size=2>한 셀에 /로 구분된 두 정보의 각 합계 구하기</FONT></TD></TR></TBODY></TABLE></P>
<!-- -->
]]>
카페 게시글
┃컴초보강좌정보자료┃
▶컴강좌◀
엑셀 강좌 (초 중급 과정)
주찬양
추천 0
조회 1,713
06.06.28 13:23
댓글 7
다음검색
첫댓글 좋은 게시물이네요. 스크랩 해갈게요~^^
감사합니다.
좋은정보감사합니다
감사합니다..
좋은정보 감사합니다.퍼갈께요~^^*
공부할수 있는 좋은 자료라 스크랩 해갑니다 감사합니다
잘배우겠읍니다.