컴퓨터활용 Excel 2016 Powerpoint

제1편 엑셀 2016
제01장 엑셀 2016 기초
제01절 엑셀 2016 시작/종료하기 ····················································· 18
1. 엑셀 2016 시작하기 ······································································· 18
2. 엑셀의 종료···················································································· 19
제02절 화면 구성 살펴보기 ······························································ 20
요약 / 23 연습문제 / 24
제02장 데이터 입력 및 편집
제01절 데이터 입력하기 ··································································· 26
1. 숫자 데이터 입력··········································································· 26
2. 문자 데이터 입력··········································································· 27
3. 분수 데이터 입력하기 ···································································· 29
4. 날짜 데이터 입력하기 ···································································· 30
5. 시간 데이터 입력하기 ···································································· 31
6. 한자 입력하기················································································ 31
7. 특수 문자 입력하기······································································· 32
제02절 자동 채우기 ·········································································· 36
1. 숫자 자동 채우기··········································································· 36
2. 문자 자동 채우기··········································································· 39
3. 사용자 지정 목록 채우기······························································ 41

제03절 데이터 편집 ·········································································· 44
1. 데이터 수정···················································································· 44
2. 셀 선택하기···················································································· 45
3. 셀 이동하기···················································································· 47
요약 / 48 연습문제 / 49
제03장 문서 관리
제01절 파일 저장하기 ······································································· 52
1. 통합 문서 저장하기······································································· 52
제02절 통합 문서 불러오기 ······························································ 60
1. 엑셀 2016 통합 문서 불러오기 ····················································· 60
요약 / 63 연습문제 / 64
제04장 워크시트 관리 및 편집
제01절 워크시트 관리하기 ······························································· 66
1. 행 머리글 지정하기 ····································································· 66
2. 열 머리글 지정하기 ····································································· 67
3. 행 높이 조정하기········································································· 68
4. 열 너비 조정하기········································································· 70
5. 행/열 삽입하기············································································· 71
6. 행/열 삭제하기············································································· 74
7. 행/열 숨기기 ················································································ 75

8. 행/열 숨기기 취소 ······································································· 76
9. 워크시트 삽입 ·············································································· 78
10. 워크시트 삭제··············································································· 79
11. 워크시트 복사/이동······································································ 80
12. 워크시트 이름 바꾸기 ·································································· 84
13. 워크시트 탭 색············································································· 86
제02절 워크시트 편집하기 ······························································· 87
1. 복사하기와 붙여넣기······································································ 87
2. 잘라내기와 붙여넣기······································································ 90
요약 / 93 연습문제 / 94
제05장 셀 서식과 조건부 서식
제01절 셀 서식 ················································································· 98
1. 셀 서식 맞춤················································································ 100
2. 글꼴 꾸미기·················································································· 103
3. 표시 형식 ······················································································ 108
4. 셀 스타일······················································································ 114
제02절 조건부 서식 ········································································ 117
1. 셀 강조 규칙················································································ 117
2. 새 규칙 이용················································································ 120
요약 / 127 연습문제 / 128

제06장 차트(Chart)
제01절 차트(Chart) ··········································································· 132
1. 차트 종류 ······················································································ 132
제02절 차트의 구성요소 ································································· 134
제03절 차트 만들기 ········································································ 136
1. 추천 차트 삽입하기······································································ 136
제04절 차트 편집 ············································································ 140
1. 차트 종류 변경············································································· 140
2. 행/열 전환···················································································· 143
3. 데이터 선택 추가/제거································································· 145
4. 계열 이름 바꾸기········································································· 147
5. 차트 제목 ······················································································ 149
6. 차트 축 제목················································································ 151
7. 범례 ······························································································ 152
8. 데이터 레이블··············································································· 154
9. 데이터 표 ······················································································ 155
제05절 스파크라인 차트 ································································· 158
1. 스파크라인 차트 삽입 ·································································· 158
요약 / 163 연습문제 / 164
제07장 함수(Function)
제01절 함수란? ················································································ 168
1. 함수 마법사·················································································· 168
2. 자동 합계 ······················································································ 172

제02절 기본 함수 ············································································ 174
1. 통계함수······················································································· 174
2. 수학/삼각 함수············································································· 188
제03절 논리 함수 ············································································ 196
1. IF함수··························································································· 196
2. 논리 함수 ······················································································ 199
제04절 텍스트 함수 ········································································ 203
1. LEN 함수······················································································ 203
2. LEFT, RIGHT, MID 함수····························································· 204
제05절 날짜/시간 함수 ··································································· 206
제06절 찾기 함수 ············································································ 208
1. VLOOKUP 함수············································································ 208
2. HLOOKUP 함수············································································ 210
3. CHOOSE 함수 ·············································································· 211
제07절 데이터베이스 함수 ······························································ 213
1. DSUM 함수·················································································· 213
2. DGET 함수··················································································· 215
요약 / 218 연습문제 / 219
제08장 데이터 관리와 분석
제01절 데이터베이스란? ································································· 226
제02절 정렬(Sort) 및 필터(Filter) ······················································ 227
1. 정렬(Sort) 하기 ············································································· 227
2. 필터(Filter) ···················································································· 232

제03절 데이터 통합 ········································································ 245
1. 데이터 통합·················································································· 245
제04절 목표값 찾기 ········································································ 249
1. 목표값 찾기·················································································· 249
제05절 시나리오 ·············································································· 252
1. 시나리오······················································································· 252
제06절 부분합 ················································································· 257
1. 부분합··························································································· 257
제07절 피벗 테이블 ········································································ 264
1. 피벗 테이블 만들기······································································ 264
2. 피벗 테이블 필드 선택하기 ························································· 265
3. 피벗 테이블 보고서 꾸미기 ························································· 268
요약 / 271 연습문제 / 272



제2편 파워포인트 2016
제01장 파워포인트 입문하기
제01절 파워포인트 시작/종료하기 ················································· 282
1. 파워포인트 2016 시작하기························································· 282
2. 파워포인트 종료········································································· 284
제02절 화면 구성요소 살펴보기 ····················································· 285
제03절 프레젠테이션 다루기 ·························································· 288
1. 새 프레젠테이션 만들기····························································· 288
2. 새 슬라이드 삽입하기································································ 289
3. 레이아웃 변경하기······································································ 290
4. 파일 가져오기 ············································································· 292
5. 파일 저장하기 ············································································· 293
6. 파일 닫기···················································································· 295
7. 글꼴 꾸미기················································································ 297
8. 단락 꾸미기················································································ 299
9. 슬라이드 복제하기······································································ 301
10. 슬라이드 삭제하기······································································ 302
11. 글머리 기호················································································ 304
요약 / 307 연습문제 / 308
제02장 디자인 서식 꾸미기
제01절 워드아트 삽입하기 ······························································ 312

1. 워드아트 속성 변경······································································ 312
2. 워드아트 속성 지우기 ·································································· 314
제02절 도형 슬라이드 만들기 ························································ 316
1. 도형 삽입하기··············································································· 316
2. 도형 정렬하기··············································································· 319
3. 도형 배치하기··············································································· 321
4. 도형 그룹화 시키기······································································ 324
5. 도형 속성 변경하기······································································ 327
6. 도형 꾸미기·················································································· 331
제03절 SmartArt 그래픽 만들기 ······················································· 335
1. SmartArt 그래픽 계층 구조형 작성하기······································ 335
2. 텍스트를 SmartArt 그래픽으로 변환하기····································· 341
3. SmartArt 그래픽 색 지정····························································· 343
4. SmartArt 스타일 적용··································································· 345
5. SmartArt에서 도형으로 변환························································ 347
요약 / 350 연습문제 / 351
제03장 이미지로 화려한 슬라이드 만들기
제01절 그림 삽입하기 ····································································· 356
1. 슬라이드에 그림 삽입하기··························································· 356
2. 도형에 맞추어 그림 모양 변경하기············································· 359
3. 도형에 그림 삽입하기 ·································································· 361
4. 스마트아트에 그림 삽입하기 ························································ 364
5. 그림 꾸미기·················································································· 366

제02절 사진 앨범 만들기 ································································ 372
1. 사진 앨범에 이미지 삽입····························································· 372
2. 사진 앨범 편집하기······································································ 375
제03절 그림 자르기 ········································································ 378
요약 / 380 연습문제 / 381
제04장 시각적 활용자료 만들기
제01절 표 작성하기 ········································································ 384
1. 표 삽입하기·················································································· 384
2. 표 스타일 적용············································································· 389
3. 표 레이아웃 변경하기 ·································································· 392
제02절 차트 작성하기 ····································································· 400
1. 차트 삽입하기··············································································· 400
2. 차트 편집 ······················································································ 403
요약 / 417 연습문제 / 418
제05장 멀티미디어 삽입
제01절 멀티미디어 파일 삽입하기 ················································· 422
1. 오디오 파일 삽입하기 ·································································· 422
2. 동영상 삽입하기 ··········································································· 425
3. 동영상 효과·················································································· 428
4. 비디오 트리밍··············································································· 430

제02절 화면 전환 효과주기 ···························································· 432
1. 화면 전환 효과············································································· 432
제03절 애니메이션 효과주기 ·························································· 436
1. 애니메이션 지정하기···································································· 436
2. 애니메이션 트리거 설정······························································· 438
제04절 하이퍼링크 연결하기 ·························································· 442
1. 도형에 하이퍼링크 삽입하기 ························································ 442
2. 텍스트 하이퍼링크 삽입하기 ························································ 443
3. 도형 실행버튼 연결하기······························································· 445
요약 / 450 연습문제 / 451
제06장 슬라이드 마스터 작성하기와 인쇄
제01절 슬라이드 마스터 ································································· 458
1. 슬라이드 마스터 서식 설정························································· 458
2. 슬라이드 마스터 디자인······························································· 464
3. 머리글/바닥글 삽입······································································ 468
4. 유인물 마스터··············································································· 472
제02절 인 쇄 ··················································································· 475
1. 슬라이드 인쇄··············································································· 475
2. 슬라이드 노트 인쇄······································································ 479
제03절 다양한 형식으로 저장 ························································ 482
1. 파일 다른 이름으로 저장····························································· 482
2. 내보내기······················································································· 484
요약 / 486 연습문제 / 487