엑셀 사용및 사용법

<td class="bg_board_title_02" colspan="2" height="1" style="overflow:hidden; padding:0px"></td></tr> </table> <table width="100%" cellpadding="0" cellspacing="0" border="0"> <tr valign="top"> <td style="padding:15px 5px 0px 15px">   </td> <td style="padding:15px 15px 0px 0px" align="right">   </td> </tr> </table> <table border="0" cellpadding="15" cellspacing="0" width="100%"> <tr valign="top">  <td bgcolor="#ffffff" width="100%" class="text" style="padding-bottom:8px" id="clix_content"> <table border="0" cellpadding="15" cellspacing="0" width="100%"> <tr valign="top">  <td bgcolor="#ffffff" width="100%" class="text" style="padding-bottom:8px" id="clix_content"> <TABLE cellSpacing=0 cellPadding=15 width="100%" border=0> <TBODY> <TR vAlign=top> <TD class=text id=clix_content style="PADDING-BOTTOM: 8px" width="100%" bgColor=#ffffff> <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0> <TBODY> <TR> <TD vAlign=top><IMG height=30 src="https://img1.daumcdn.net/relay/cafe/original/?fname=http%3A%2F%2Fsoongin.new21.net%2Fexcel%2Fbasic%2Ftitle.gif" width=150 border=0 omload="chgimgWidth(this)"> <TABLE borderColor=teal cellSpacing=0 width=244 bgColor=#ccffcc border=1> <TBODY> <TR> <TD width=244> <DIV>1. <A class=con_link href="http://soongin.new21.net/excel/basic/basic1.htm" target=_blank>엑셀은 어디에 사용하는가?</A> 2. <A class=con_link href="http://soongin.new21.net/excel/basic/basic2.htm" target=_blank>엑셀 2000에서 달라진 내용</A> 3. <A class=con_link href="http://soongin.new21.net/excel/basic/basic3.htm" target=_blank target?="blank">엑셀 2000 설치하기</A> 4. <A class=con_link href="http://soongin.new21.net/excel/basic/basic4.htm" target=_blank>엑셀의 화면 구성 살펴보기</A> 5. <A class=con_link href="http://soongin.new21.net/excel/basic/basic5.htm" target=_blank>엑셀에서의 파일 관리</A> 6. <A class=con_link href="http://soongin.new21.net/excel/basic/basic6.htm" target=_blank>데이터의 입력</A> 7. <A class=con_link href="http://soongin.new21.net/excel/basic/basic7.htm" target=_blank>기본적인 수식/함수 사용</A> 8. <A class=con_link href="http://soongin.new21.net/excel/basic/basic8.htm" target=_blank>자동 채우기</A> 9. <A class=con_link href="http://soongin.new21.net/excel/basic/basic9.htm" target=_blank>메모와 윗주 삽입하기</A> 10. <A class=con_link href="http://soongin.new21.net/excel/basic/basic10.htm" target=_blank>선택하여 붙여넣기</A> 11. <A class=con_link href="http://soongin.new21.net/excel/basic/basic11.htm" target=_blank>편집(복사/이동 등)</A> 12. <A class=con_link href="http://soongin.new21.net/excel/basic/basic12.htm" target=_blank>엑셀에서의 서식 작업</A> 13. <A class=con_link href="http://soongin.new21.net/excel/basic/basic13.htm" target=_blank>스타일(Style) 기능 활용</A> 14. <A class=con_link href="http://soongin.new21.net/excel/basic/basic14.htm" target=_blank ?>조건부 서식 지정하기</A> 15. <A class=con_link href="http://soongin.new21.net/excel/basic/basic15.htm" target=_blank>사용자 서식 지정하기</A> 16. <A class=con_link href="http://soongin.new21.net/excel/basic/basic16.htm" target=_blank>그리기 개체 이용하기</A> 17. <A class=con_link href="http://soongin.new21.net/excel/basic/basic17.htm" target=_blank>인쇄하기 </A></DIV></TD></TR></TBODY></TABLE> <DIV></DIV> <DIV><A class=con_link href="http://soongin.new21.net/" target=_blank></A></DIV></TD></TR></TBODY></TABLE> <DIV><IMG height=30 src="https://img1.daumcdn.net/relay/cafe/original/?fname=http%3A%2F%2Fsoongin.new21.net%2Fexcel%2Fmid%2Ftitle.gif" width=160 border=0 omload="chgimgWidth(this)"></DIV> <TABLE borderColor=teal cellSpacing=0 width=244 bgColor=#ccffcc border=1> <TBODY> <TR> <TD width=244> <DIV>1. <A class=con_link href="http://soongin.new21.net/excel/mid/mid1.htm" target=_blank>수식에 관한 전문적인 이야기</A> 2. <A class=con_link href="http://soongin.new21.net/excel/mid/mid2.htm" target=_blank>상대참조와 절대참조</A> 3. <A class=con_link href="http://soongin.new21.net/excel/mid/mid3.htm" target=_blank>3차원 참조하기</A> 4. <A class=con_link href="http://soongin.new21.net/excel/mid/mid4.htm" target=_blank>이름 지정하기</A> 5. <A class=con_link href="http://soongin.new21.net/excel/mid/mid5.htm" target=_blank>IF 함수 정복하기</A> 6. <A class=con_link href="http://soongin.new21.net/excel/mid/mid6.htm" target=_blank>함수 중첩하기</A> 7. <A class=con_link href="http://soongin.new21.net/excel/mid/mid7.htm" target=_blank>배열 완전 정복!</A> 8. <A class=con_link href="http://soongin.new21.net/excel/mid/mid8.htm" target=_blank>SUMIF와 COUNTIF 함수</A> 9. <A class=con_link href="http://soongin.new21.net/excel/mid/mid9.htm" target=_blank>RANK 함수로 순위 구하기</A> 10. <A class=con_link href="http://soongin.new21.net/excel/mid/mid10.htm" target=_blank>VLOOKUP과 HLOOKUP 함수</A> 11. <A class=con_link href="http://soongin.new21.net/excel/mid/mid11.htm" target=_blank>PERCENTRANK로 % 순위 구하기</A> 12. <A class=con_link href="http://soongin.new21.net/excel/mid/mid12.htm" target=_blank>MATCH 함수로 내신등급 구하기</A> 13. <A class=con_link href="http://soongin.new21.net/excel/mid/mid13.htm" target=_blank>기타 중요한 함수들</A> [특별부록] <A class=con_link href="http://soongin.new21.net/excel/mid/function_list.htm" target=_blank>엑셀 함수 목록 총 정리</A> 14. <A class=con_link href="http://soongin.new21.net/excel/mid/mid14.htm" target=_blank>차트 만들고 관리하기</A> 15. <A class=con_link href="http://soongin.new21.net/excel/mid/mid15.htm" target=_blank>차트 편집하기</A> 16. <A class=con_link href="http://soongin.new21.net/excel/mid/mid16.htm" target=_blank>차트 편집 계속</A> 17. <A class=con_link href="http://soongin.new21.net/excel/mid/mid17.htm" target=_blank>이중 차트 만들기</A> 18. <A class=con_link href="http://soongin.new21.net/excel/mid/mid18.htm" target=_blank>오차막대와 추세선</A> 19. <A class=con_link href="http://soongin.new21.net/excel/mid/mid19.htm" target=_blank>추세선의 종류와 사용법</A> 20. <A class=con_link href="http://soongin.new21.net/excel/mid/mid20.htm" target=_blank>차트에 그림 붙이기</A> 21. <A class=con_link href="http://soongin.new21.net/excel/mid/mid21.htm" target=_blank>지도 차트 다루기</A> 22. <A class=con_link href="http://soongin.new21.net/excel/mid/mid22.htm" target=_blank>DB 1 - 목록/레코드</A> 23. <A class=con_link href="http://soongin.new21.net/excel/mid/mid23.htm" target=_blank>DB 2 - 정렬하기</A> 24. <A class=con_link href="http://soongin.new21.net/excel/mid/mid24.htm" target=_blank>DB 3 - 자동 필터링</A> 25. <A class=con_link href="http://soongin.new21.net/excel/mid/mid25.htm" target=_blank>DB 4 - 고급 필터링</A> 26. <A class=con_link href="http://soongin.new21.net/excel/mid/mid26.htm" target=_blank>DB 5 - 데이터 베이스 함수 정복</A> 27. <A class=con_link href="http://soongin.new21.net/excel/mid/mid27.htm" target=_blank>DB 6 - 부분합</A> 28. <A class=con_link href="http://soongin.new21.net/excel/mid/mid28.htm" target=_blank>DB 7 - 3차원 시트로 데이터 통합</A> 29. <A class=con_link href="http://soongin.new21.net/excel/mid/mid29.htm" target=_blank>DB 8 - 텍스트 파일을 엑셀에서!</A> 30. <A class=con_link href="http://soongin.new21.net/excel/mid/mid30.htm" target=_blank>Query로 외부 데이터 불러오기</A> 31. <A class=con_link href="http://soongin.new21.net/excel/mid/mid31.htm" target=_blank>Query로 Access 데이터 불러오기</A> 32. <A class=con_link href="http://soongin.new21.net/excel/mid/mid32.htm" target=_blank>미래값 예측 - 데이터 테이블</A> 33. <A class=con_link href="http://soongin.new21.net/excel/mid/mid33.htm" target=_blank>조건분석 - 시나리오 사용하기</A> 34. <A class=con_link href="http://soongin.new21.net/excel/mid/mid34.htm" target=_blank>가상분석 - 목표값 / 해찾기</A> 35. <A class=con_link href="http://soongin.new21.net/excel/mid/mid35.htm" target=_blank>셀 입력항목 유효화시키기</A></DIV></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE> </td> <td nowrap valign="top" align="right" style="padding-left:0px"> </td> <td nowrap valign="top" align="right" style="padding-left:0px">