목차
01. 기본작업
데이터 입 력 ·································································· 8
셀서식 ·············································································· 10
선택하여 붙여넣기/연결하여 붙여넣기 ············ 25
외부 데이터 가져오기 ············································ 28
텍스트 나누기 ····························································· 36
조건부 서식 ································································· 41
자동필터 ······································································· 50
고급필터 ······································································· 58
02. 계산작업
날짜와 시간 함수 ···················································· 65
논리 함수 ···································································· 73
데이터 베이스 함수 ··············································· 77
문자열 함수 ······························································ 81
수학과 삼각 함수 ··················································· 88
통계 함수 ···································································· 96
찾기/참조 함수 ························································109
함수문제 유형 1~3 ········································ 116
03. 분석작업
정렬 ············································································· 124
부분합 ········································································· 128
통합 ············································································· 135
목표값 찾기 ···························································· 138
시나리오 ····································································141
데이터 표 ·································································· 152
피벗 테이블 ···························································· 156
04. 기타작업
매크로 ··································································· 168
차트 ······································································· 186
05. 기출문제유형
기출문제유형 1 ······················································ 200
기출문제유형 2 ······················································ 233
기출문제유형 3 ······················································ 256
부록 : 함수사전
실전 계산작업 유형 1~5
