컴활용셤보구 화난 사람들의 모임[컴활1급 전문카페]

<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0> <TBODY> <TR> <TD class=pt_text name="hl"> <DIV id=cContentBody> <TABLE id=AutoNumber4 style="BORDER-COLLAPSE: collapse" borderColor=#111111 cellSpacing=1 cellPadding=2 width=560 border=0> <TBODY> <TR> <TD align=middle width="15%" bgColor=#5a96d6 height=16>강좌 번호</TD> <TD align=middle width="35%" bgColor=#5a96d6 height=16>강좌명</TD> <TD align=middle width="50%" bgColor=#5a96d6 height=16>Description</TD></TR> <TR> <TD align=middle width="13%" bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0051.zip" target=_blank>X0051.zip</A></TD> <TD align=left width="35%" bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0051.zip" target=_blank>고급필터 사용하기</A></TD> <TD bgColor=#ffffff>고급필터 사용 방법</TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0052.zip" target=_blank>X0052.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0052.zip" target=_blank>Dget 함수 에 대하여</A></TD> <TD bgColor=#ffffff>두 가지 이상의 조건을 만족하는 자료 검색 </TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0053.zip" target=_blank>X0053.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0053.zip" target=_blank>Datedif 함수에 대하여</A></TD> <TD bgColor=#ffffff>날짜 계산하기</TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0054.zip" target=_blank>X0054.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0054.zip" target=_blank>Datedif 함수 응용</A></TD> <TD bgColor=#ffffff>Datedif 함수를 응용한 날짜 계산하기 </TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0055.zip" target=_blank>X0055.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0055.zip" target=_blank>고급필터 사용하기Ⅱ</A></TD> <TD bgColor=#ffffff>고급필터 응용</TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0056.zip" target=_blank>X0056.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0056.zip" target=_blank>필터링한 자료의 피벗...</A></TD> <TD bgColor=#ffffff>필터링한 자료의 피벗테이블 작업 </TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0057.zip" target=_blank>X0057.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0057.zip" target=_blank>기발한 차 트 구현 방법</A></TD> <TD bgColor=#ffffff>Rept 함수를 사용한 기발한 차트 구현 방법 </TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0058.zip" target=_blank>X0058.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0058.zip" target=_blank>셀 보호하 기</A></TD> <TD bgColor=#ffffff>셀에 Password 걸어 보호하기</TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0059.zip" target=_blank>X0059.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0059.zip" target=_blank>이스터 에 그</A></TD> <TD bgColor=#ffffff>Easter Egg에 대하여</TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0060.zip" target=_blank>X0060.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0060.zip" target=_blank>양식과 컨 트롤 도구모음</A></TD> <TD bgColor=#ffffff>양식 도구모음과 컨트롤 도구모음의 구분 </TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0061.zip" target=_blank>X0061.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0061.zip" target=_blank>배열수식 활용의 결정판</A></TD> <TD bgColor=#ffffff>배열수식 활용의 결정판(By J.Walkenbach) </TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0062.zip" target=_blank>X0062.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0062.zip" target=_blank>다중수식 (MegaFormula)</A></TD> <TD bgColor=#ffffff>다중수식을 사용한 주소록 관리</TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0063.zip" target=_blank>X0063.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0063.zip" target=_blank>정보함수 </A></TD> <TD bgColor=#ffffff>Isnum, IsError 등의 함수에 대한 설명 </TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0064.zip" target=_blank>X0064.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0064.zip" target=_blank>상대주소/ 절대주소</A></TD> <TD bgColor=#ffffff>상대주소/절대주소 활용</TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0065.zip" target=_blank>X0065.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0065.zip" target=_blank>Dsum 함수 </A></TD> <TD bgColor=#ffffff>여러 조건을 충족하는 자료 검색 </TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0066.zip" target=_blank>X0066.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0066.zip" target=_blank>Dsum 함수 Ⅱ</A></TD> <TD bgColor=#ffffff>Dsum 함수와 콤보박스의 활용</TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0067.zip" target=_blank>X0067.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0067.zip" target=_blank>SubTotal( 부분합)</A></TD> <TD bgColor=#ffffff>다양한 부분합 산출하기</TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0068.zip" target=_blank>X0068.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0068.zip" target=_blank>피벗테이 블 활용하기Ⅲ</A></TD> <TD bgColor=#ffffff>피벗테이블 활용하기</TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0069.zip" target=_blank>X0069.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0069.zip" target=_blank>피벗테이 블 활용하기Ⅳ</A></TD> <TD bgColor=#ffffff>다중통합범위의 개념</TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0070.zip" target=_blank>X0070.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://blog.empas.com/kkcooler/MyXls/Lectures/X0070.zip" target=_blank>피 벗테이블 활용하기Ⅴ</A></TD> <TD bgColor=#ffffff>다중통합범위(Consolidate by Category) </TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0071.zip" target=_blank>X0071.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0071.zip" target=_blank>통합문서 시트수 설정하기 </A></TD> <TD bgColor=#ffffff>새 통합 문서의 시트수 지정하기 </TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0072.zip" target=_blank>X0072.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://blog.empas.com/kkcooler/MyXls/Lectures/X0072.zip" target=_blank>작업영역 저장 </A></TD> <TD bgColor=#ffffff>작업영역 저장하기</TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0073.zip" target=_blank>X0073.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://blog.empas.com/kkcooler/MyXls/Lectures/X0073.zip" target=_blank>나이 계산</A></TD> <TD bgColor=#ffffff>주민등록번호로 나이 계산하기</TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://blog.empas.com/kkcooler/MyXls/Lectures/X0074.zip" target=_blank>X0074.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0074.zip" target=_blank>패스워드에 대하여</A></TD> <TD bgColor=#ffffff>3가지 패스워드 거는 법 </TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0075.zip" target=_blank>X0075.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0075.zip" target=_blank>한/영 변환 제한하기 </A></TD> <TD bgColor=#ffffff>한/영 자동변환 기능 제한하기</TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0076.zip" target=_blank>X0076.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0076.zip" target=_blank>Hyperlink 함수</A></TD> <TD bgColor=#ffffff>Excel에서 홈페이지 직접 접속하는 방법 </TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0077.zip" target=_blank>X0077.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0077.zip" target=_blank>유효성검사Ⅱ</A></TD> <TD bgColor=#ffffff>유효성 검사 응용 예제</TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0078.zip" target=_blank>X0078.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0078.zip" target=_blank>유효성검사Ⅲ</A></TD> <TD bgColor=#ffffff>유효성 검사 응용 예제</TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0079.zip" target=_blank>X0079.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0079.zip" target=_blank>스타일 사용하기</A></TD> <TD bgColor=#ffffff>스타일 사용 해보기</TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0080.zip" target=_blank>X0080.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0080.zip" target=_blank>스타일 사용하기Ⅱ</A></TD> <TD bgColor=#ffffff>스타일 사용 해보기2</TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0081.zip" target=_blank>X0081.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0081.zip" target=_blank>생일자 찾아내기</A></TD> <TD bgColor=#ffffff>고객 DB에서 생일자 골라내기</TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0082.zip" target=_blank>X0082.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0082.zip" target=_blank>해찾기(Slover)</A></TD> <TD bgColor=#ffffff>해찾기(Solver) 사용법</TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0083.zip" target=_blank>X0083.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0083.zip" target=_blank>통합문서 공유하기Ⅰ </A></TD> <TD bgColor=#ffffff>엑셀에서 문서 공유하는 방법</TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0084.zip" target=_blank>X0084.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0084.zip" target=_blank>통합문서 공유하기Ⅲ </A></TD> <TD bgColor=#ffffff>엑셀에서 문서 공유/작업하는 방법 </TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0085.zip" target=_blank>X0085.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0085.zip" target=_blank>DM발송용 주소 인쇄</A></TD> <TD bgColor=#ffffff>DM 발송을 위한 주소록 인쇄 방법 </TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0086.zip" target=_blank>X0086.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0086.zip" target=_blank>부분합 결과를 다르게 표시하기 </A></TD> <TD bgColor=#ffffff>부분합 결과를 위에 표시하는 방법  </TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0087.zip" target=_blank>X0087.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0087.zip" target=_blank>문자열 함수 응용  </A></TD> <TD bgColor=#ffffff>여러 가지 문자열 함수 응용 예제 </TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0088.zip" target=_blank>X0088.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0088.zip" target=_blank>자동고침기능</A></TD> <TD bgColor=#ffffff>자동고침 기능 및 활용예제 한가지 </TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0089.zip" target=_blank>X0089.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0089.zip" target=_blank>NumberString 함수</A></TD> <TD bgColor=#ffffff>숫자를 한글/한자로 바꾸기</TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0090.zip" target=_blank>X0090.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0090.zip" target=_blank>서식파일에 대하여</A></TD> <TD bgColor=#ffffff>엑셀에서 사용하는 파일들 및 서식파일 사용법 </TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0091.zip" target=_blank>X0091.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://blog.empas.com/kkcooler/MyXls/Lectures/X0091.zip" target=_blank>서식파일에 대하여Ⅱ </A></TD> <TD bgColor=#ffffff>서식파일 사용법Ⅱ</TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0092.zip" target=_blank>X0092.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0092.zip" target=_blank>서식파일에 대하여Ⅲ </A></TD> <TD bgColor=#ffffff>파일을 열 때 항상 같은 형태가 나타나게 하기 </TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0093.zip" target=_blank>X0093.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0093.zip" target=_blank>유효성 검사에 대하여Ⅳ </A></TD> <TD bgColor=#ffffff>한글/영어 자동 전환 하기</TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0094.zip" target=_blank>X0094.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0094.zip" target=_blank>The Origin Of "@"</A></TD> <TD bgColor=#ffffff>@(골뱅이? 달팽이?)의 기원에 대 해... </TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0095.zip" target=_blank>X0095.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0095.zip" target=_blank>자동고침과 Text 함수 </A></TD> <TD bgColor=#ffffff>자동고침 기능과 Text() 함수의 사용법 및 예제 </TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0096.zip" target=_blank>X0096.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0096.zip" target=_blank>서식 복사하기</A></TD> <TD bgColor=#ffffff>서식 복사하기/연속 서식 복사하기 </TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0097.zip" target=_blank>X0097.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0097.zip" target=_blank>문자열 상자에 수식 넣기 </A></TD> <TD bgColor=#ffffff>문자열 상자에 수식 넣기 </TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0098.zip" target=_blank>X0098.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0098.zip" target=_blank>문자열 상자에 수식 넣기Ⅱ </A></TD> <TD bgColor=#ffffff>문자열 상자에 수식 넣기 응용</TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0099.zip" target=_blank>X0099.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0099.zip" target=_blank>캐리지 리턴에 대하여 </A></TD> <TD bgColor=#ffffff>캐리지 리턴(Carriage Return)에 대하여 </TD></TR> <TR> <TD align=middle bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0100.zip" target=_blank>X0100.zip</A></TD> <TD align=left bgColor=#ffffff><A class=con_link href="http://www.iexceller.com/MyXls/Lectures/X0100.zip" target=_blank>행과열 바꾸기</A></TD> <TD bgColor=#ffffff>표에서 행과 열 위치 바꾸기</TD></TR></TBODY></TABLE></DIV></TD></TR></TBODY></TABLE>   ==== 네이버 세상만사에서 발췌(너무 좋은 자료 감솨) ====