목차정보

목차정보
[목차정보]
서명 : (엑셀 좀하는 직장인에게 권하는) 엑셀 2007 함수의 기술
PART 01 함수의 기본

   CHAPTER 01 함수 사용에 필요한 엑셀 기본 개념

      01 함수와 수식 = 30

      02 엑셀의 데이터 형식 = 31

      03 날짜와 시간 = 33

      04 셀 참조 = 38

      05 연산자 = 41

      06 수식 오류값 = 45

      07 일반 수식과 배열 수식 = 49

   CHAPTER 02 함수 사용에 필요한 엑셀 기능

      01 수식 입력줄 = 52

      02 함수 마법사 = 55

      03 자동 채우기 기능과 참조 방식 = 58

      04 수식 계산 기능 = 65

      05 이름 정의 = 68

      06 엑셀 표 = 70

      07 목표값 찾기 = 73


PART 02 엑셀 필수 함수 98가지

   CHAPTER 01 판단 함수

      01 특정 상황에 따라 다른 결과 반환하기 = 78

        IF

        IFERROR

        ISERROR

      02 복잡한 판단이 필요하고 그에 따라 다른 결과 반환하기 = 81

        AND

        OR

        NOT

      03 1, 2, 3, … 등의 일련번호를 반환하는 조건에 따른 결과 반환하기 = 84

        CHOOSE

   CHAPTER 02 편집 함수

      01 셀에 입력된 값 중 일부분 잘라내기 = 86

        LEFT

        MID

        RIGHT

      02 셀에 입력된 값 중 특정 문자 위치에 따라 일부 잘라내기 = 89

        FIND

        SEARCH

        LEN

      03 셀에 입력된 값 중 일부 변경하기 = 92

        SUBTITUTE

      04 셀에 입력된 값을 원하는 형태로 변환하기 = 94

        TEXT

        NUMBERSTRING

        WON

      05 여러 셀에 흩어진 값을 하나로 합치기 = 97

        CONCATENATE

        PHONETIC

   CHAPTER 03 계산, 집계, 통계 함수

      01 숫자 변환 = 101

        VALUE

      02 개수 세기 = 103

        COUNT

        COUNTA

        COUNTBLANK

        COUNTIF

        COUNTIFS

      03 합계 계산 = 108

        SUM

        SUMIF

        SUMIFS

        SUMPRODUCT

      04 평균 계산 = 113

        AVERAGE

        AVERAGEIF

        AVERAGEIFS

      05 최대값, 최소값, n번째 큰 값, 작은 값 구하기 = 116

        MAX

        MIN

        LARGE

        SMALL

      06 순위 계산하기 = 119

        RANK

        COUNTIFS

      07 반올림, 올림, 내림 처리하기 = 122

        ROUND

        ROUNDDOWN

        ROUNDUP

        INT

        TRUNC

      08 몫과 나머지 구하기 = 126

        QUOTIENT

        MOD

      09 숨겨진 셀을 제외하고 데이터 요약하기 = 128

        SUBTOTAL

      10 색상으로 구분해 데이터 요약하기 = 132

        GET.CELL

      11 미래 예측하기 = 137

        FORECAST

   CHAPTER 04 날짜, 시간 함수

      01 오늘 날짜와 현재 시간 입력하기 = 139

        TODAY

        NOW

      02 잘못된 날짜와 시간 데이터를 올바른 형식으로 변환하기 = 143

        DATEVALUE

        TIMEVALUE

      03 날짜 계산하기 = 147

        DATE

        YEAR

        MONTH

        DAY

        WEEKDAY

        EDATE

        EOMONTH

      04 시간 계산하기 = 155

        TIME

        HOUR

        MINUTE

        SECOND

      05 두 날짜의 차이 계산하기 = 157

        DATEDIF

        NETWORKDAYS

        WORKDAY

      06 시간 차이 계산하기 = 163

      07 날짜 분류하기 = 164

        WEEKNUM

      08 시간 분류하기 = 168

   CHAPTER 05 참조 함수

      01 셀 주소로 원하는 값 참조하기 = 171

      02 행 방향의 표에서 값 참조하기 = 176

        VLOOKUP

        LOOKUP

      03 열 방향의 표에서 값 참조하기 = 179

        HLOOKUP

      04 열과 행이 교차하는 표에서 값 참조하기 = 181

        INDEX

        MATCH(1)

      05 다중 조건을 처리하는 참조 함수 사용하기 = 185

        MATCH(2)

      06 행, 열을 바꿔 참조하기 = 187

        OFFSET

        ROW

        COLUMN

        TRANSPOSE

   CHAPTER 06 데이터베이스 함수

      01 조건 목록을 이용한 개수 세기 = 192

        DCOUNT

        DCOUNTA

      02 조건 목록을 이용한 합계와 평균 계산하기 = 196

        DSUM

        DAVERAGE

      03 조건 목록을 이용한 최대, 최소 구하기와 값 참조하기 = 199

        DMAX

        DMIN

        DGET

   CHAPTER 07 기타 함수

      01 홀수, 짝수 구분하기 = 203

        ISEVEN

        ISODD

      02 지정한 횟수만큼 반복하기 = 207

        REPT

      03 필요한 정보(버전, 파일명, 폴더, 시트 개수 등) 확인하기 = 213

        CELL

        INFO

      04 페이지 번호 계산하기 = 218

        GET.DOCUMENT

      05 텍스트 값을 참조로 변환하기 = 222

        INDIRECT

      06 하이퍼링크 설정하기 = 226

        HYPERLINK

      07 배수로 반올림, 올림, 내림 처리하기 = 229

        MROUND

        CEILING

        FLOOR

      08 상위, 하위 n% 데이터 추출하기 = 234

        PERCENTRANK

      09 임의의 수 만들기 = 240

        RAND

        RANDBETWEEN

      SPECIAL 01 TEXT 함수의 서식 코드 = 244

      SPECIAL 02 한글 자음에 할당된 특수 문자표 = 246


PART 03 함수를 사용한 자동화 서식

   PROJECT 01 금전 출납부 = 250

      01 금전 출납부 구성하기 = 252

      02 집계표 만들기 = 258

      03 출납 현황 차트 만들기 = 266

      04 금전 출납부 수정 및 보완하기 = 274

   PROJECT 02 매출 통계 (1) - 월별 집계 = 276

      01 거래내역 표 관리하기 = 278

      02 집계표 만들기 = 280

      03 차트 구성하기 = 290

      SPECIAL 03 차트의 각 부분 명칭 = 295

   PROJECT 03 매출 통계 (2) - 달력을 이용한 집계 = 296

      01 거래 내역 데이터 관리하기 = 298

      02 집계표 만들기 = 299

      03 달력 만들어 매출 표시하기 = 305

      04 달력과 연동되는 차트 만들기 = 313

   PROJECT 04 매출 통계 (3) - 상, 하위 n개 데이터 추출 = 318

      01 거래 내역 데이터 관리하기 = 320

      02 월 집계표 만들기 = 322

      03 상, 하위 n개 제품 추출하기 = 328

      04 차트 만들어 연결하기 = 335

   PROJECT 05 매출 통계 (4) - 제품별 손익 = 338

      01 원가 참고해 판매된 제품의 손익 계산하기 = 340

      02 집계표 만들기 = 344

      03 손익 차트 만들기 = 354

   PROJECT 06 근태 관리 = 360

      01 근태내역 관리하기 = 362

      02 만년달력을 이용한 근태관리 표 만들기 = 364

      03 차트 만들어 표시하기 = 376

   PROJECT 07 라벨 인쇄 = 382

      01 고객 명단 정리하기 = 384

      02 '레이블 인쇄' 추가 기능을 이용해 라벨 인쇄하기 = 390

      03 라벨 서식을 만들어 라벨 인쇄하기 = 395

   PROJECT 08 급여명세서 = 407

      01 급여내역서 완성하기 = 410

      02 급여명세서 서식 만들기 = 417

   PROJECT 09 재고 관리 = 431

      01 입출고내역 관리하기 = 434

      02 재고 관리하기 = 436

      03 입출고 현황 분석하기 = 442

      04 입출고 현황 차트로 표시하기 = 449

   PROJECT 10 견적서 = 456

      01 견적서 관리표 구성하기 = 459

      02 견적서 완성하기 = 474

      03 견적서 메일로 발송하기 = 483


색인 = 486