MCAS Excel 2007

Chapter 01 의 특징 Excel
1.1 의 기본 화면 구성 Excel ·····················2
1.2 의 리본메뉴 Excel 2007 ·····················4
1.3 빠른 실행 도구 모음 ························6
1.4 기타기능 ··································7

Chapter 02 데이터 입력 및 편집
2.1 셀의 범위 지정 ····························14
2.2 하나의 워크시트에 워크시트 관리하기 ·········25
2.3 셀에 입력할 수 있는 자료의 종류 ············30
2.4 자동 채우기 ······························32
2.5 입력한 자료의 편집 방법 ···················37
2.6 저장 방법 ································47

Chapter 03 워크시트 꾸미기
3.1 셀 서식 대화상자의 이해 ···················54
3.2 자동 서식으로 워크시트 꾸미기 ··············59
3.3 조건부 서식으로 워크시트 꾸미기 ············60

Chapter 04 통합문서 관리
4.1 통합문서 관리 ····························66
4.2 서식 파일 만들기 ··························74
4.3 통합문서 보호 ····························79
4.4 메모 ····································89
4.5 데이터 통합 ······························92
4.6 변경 내용 추적 ···························95
4.7 통합문서 속성, 검사, 최종본으로 표시 ·······102

Chapter 05 함수
5.1 함수 사용 형식 ···························112
5.2 수식 입력 ·······························113
5.3 자동 합계 ·······························114
5.4 수식 자동 완성하기 ·······················115
5.5 함수 라이브러리에서 선택 ··················115
5.6 함수 마법사 ·····························116
5.7 셀 참조 ·································125
5.8 이름을 지정한 범위 작업 ···················127
5.9 함수의 종류 ·····························130

Chapter 06 차트 및 그리기 개체 활용
6.1 차트의 구성요소 알아보기 ··················156
6.2 차트 작성 ·······························158
6.3 차트 편집 ·······························159
6.4 차트 종류와 데이터 변경하기 ···············164
6.5 데이터 계열의 서식 설정하기 ···············168
6.6 차트를 구성하는 기타 요소 ·················174
6.7 그리기 개체 활용 ··························176
6.8 하이퍼링크 ······························177

Chapter 07 데이터베이스
7.1 정렬 ···································182
7.2 레코드 필터 ·····························186
7.3 고급 필터 ·······························189
7.4 부분합 ··································192
7.5 피벗 테이블 ·····························199

Chapter 08 통합문서 분석
8.1 데이터 유효성 검사 ·······················214
8.2 오류 추적 ·······························219
8.3 참조하는 셀 추적 / 참조되는 셀 추적 ·········220
8.4 조사식 ·································220
8.5 목표 값 찾기 ····························222
8.6 시나리오 ································223

Chapter 09 인쇄
9.1 빠른 인쇄 ·······························230
9.2 미리 보기 ·······························231
9.3 페이지 설정 ·····························232
9.4 인쇄 ···································240
9.5 여러 통합문서 한 번에 인쇄하기 ············241
9.6 한 문서에서 여러 시트 한 번에 인쇄하기 ·····242

Chapter 10 매크로
10.1 매크로 기록 ·····························246
10.2 매크로 실행 ·····························250
10.3 매크로 편집 ·····························254
10.4 매크로 삭제 ·····························255

Chapter 11 외부 데이터
11.1 텍스트 파일에서 데이터 가져오기 ···········260
11.2 액세스 데이터베이스 파일에서 데이터 가져오기 · 263
11.3 파일에서 데이터 가져오기 HTML ···········266
11.4 매핑 XML ······························268
11.5 다른 프로그램으로 데이터 내보내기 ··········275
11.6 웹 페이지로 만들기 ·······················276

Chapter 12 강화된 Excel 2007의 새로운 기능
12.1 새로운 인터페이스 ························282
12.2 새로운 기능 ·····························285

찾아보기 ?············································· 291