컴퓨터활용 EXCEL 2016 POWERPOINT 2016
작가 소개
null
목 차
제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
제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
01. 반품기한
- 단순 변심인 경우 : 상품 수령 후 7일 이내 신청
- 상품 불량/오배송인 경우 : 상품 수령 후 3개월 이내, 혹은 그 사실을 알게 된 이후 30일 이내 반품 신청 가능
02. 반품 배송비
| 반품사유 | 반품 배송비 부담자 |
|---|---|
| 단순변심 | 고객 부담이며, 최초 배송비를 포함해 왕복 배송비가 발생합니다. 또한, 도서/산간지역이거나 설치 상품을 반품하는 경우에는 배송비가 추가될 수 있습니다. |
| 고객 부담이 아닙니다. |
03. 배송상태에 따른 환불안내
| 진행 상태 | 결제완료 | 상품준비중 | 배송지시/배송중/배송완료 |
|---|---|---|---|
| 어떤 상태 | 주문 내역 확인 전 | 상품 발송 준비 중 | 상품이 택배사로 이미 발송 됨 |
| 환불 | 즉시환불 | 구매취소 의사전달 → 발송중지 → 환불 | 반품회수 → 반품상품 확인 → 환불 |
04. 취소방법
- 결제완료 또는 배송상품은 1:1 문의에 취소신청해 주셔야 합니다.
- 특정 상품의 경우 취소 수수료가 부과될 수 있습니다.
05. 환불시점
| 결제수단 | 환불시점 | 환불방법 |
|---|---|---|
| 신용카드 | 취소완료 후, 3~5일 내 카드사 승인취소(영업일 기준) | 신용카드 승인취소 |
| 계좌이체 |
실시간 계좌이체 또는 무통장입금 취소완료 후, 입력하신 환불계좌로 1~2일 내 환불금액 입금(영업일 기준) |
계좌입금 |
| 휴대폰 결제 |
당일 구매내역 취소시 취소 완료 후, 6시간 이내 승인취소 전월 구매내역 취소시 취소 완료 후, 1~2일 내 환불계좌로 입금(영업일 기준) |
당일취소 : 휴대폰 결제 승인취소 익월취소 : 계좌입금 |
| 포인트 | 취소 완료 후, 당일 포인트 적립 | 환불 포인트 적립 |
06. 취소반품 불가 사유
- 단순변심으로 인한 반품 시, 배송 완료 후 7일이 지나면 취소/반품 신청이 접수되지 않습니다.
- 주문/제작 상품의 경우, 상품의 제작이 이미 진행된 경우에는 취소가 불가합니다.
- 구성품을 분실하였거나 취급 부주의로 인한 파손/고장/오염된 경우에는 취소/반품이 제한됩니다.
- 제조사의 사정 (신모델 출시 등) 및 부품 가격변동 등에 의해 가격이 변동될 수 있으며, 이로 인한 반품 및 가격보상은 불가합니다.
- 뷰티 상품 이용 시 트러블(알러지, 붉은 반점, 가려움, 따가움)이 발생하는 경우 진료 확인서 및 소견서 등을 증빙하면 환불이 가능하지만 이 경우, 제반 비용은 고객님께서 부담하셔야 합니다.
- 각 상품별로 아래와 같은 사유로 취소/반품이 제한 될 수 있습니다.
| 상품군 | 취소/반품 불가사유 |
|---|---|
| 의류/잡화/수입명품 | 상품의 택(TAG) 제거/라벨 및 상품 훼손으로 상품의 가치가 현저히 감소된 경우 |
| 계절상품/식품/화장품 | 고객님의 사용, 시간경과, 일부 소비에 의하여 상품의 가치가 현저히 감소한 경우 |
| 가전/설치상품 | 전자제품 특성 상, 정품 스티커가 제거되었거나 설치 또는 사용 이후에 단순변심인 경우, 액정화면이 부착된 상품의 전원을 켠 경우 (상품불량으로 인한 교환/반품은 AS센터의 불량 판정을 받아야 합니다.) |
| 자동차용품 | 상품을 개봉하여 장착한 이후 단순변심의 경우 |
| CD/DVD/GAME/BOOK등 | 복제가 가능한 상품의 포장 등을 훼손한 경우 |
| 상품의 시리얼 넘버 유출로 내장된 소프트웨어의 가치가 감소한 경우 | |
| 노트북, 테스크탑 PC 등 | 홀로그램 등을 분리, 분실, 훼손하여 상품의 가치가 현저히 감소하여 재판매가 불가할 경우 |