ITQ 정보기술자격증 엑셀2010 내용설명 문제풀이

☞컴퓨터 프로그램 동영상 교육 전문으로 교육청에 등록된 평생교육시설입니다.
동영상 강의로 쉽게 배울수 있어 학점과 자격증 취득, 취업 및 실무에 크게 도움이 됩니다.

♥
망설이지 말고 동영상 어플로 쉽게 배우세요

[동영상강좌 교육 내용 목차]
[1]ITQ시험소개 및 응시방법 EXCEL 출제항목 4 패턴에 대해 알아보기
[2]엑셀의 기초작업[엑셀 화면구성,열기, 저장, 새로만들기,셀 선택,시트관리]
[3]데이터 입력, 행/열관리[숫자, 날짜/시간, 문자,한자, 특수문자,수식,행/열 추가, 삭제, 높이/너비 지정]
[4]데이터 편집[셀 이동, 복사,채우기핸들, 사용자지정 목록,선택하여 붙여넣기,카메라]
[5]셀 서식[글꼴, 맞춤, 테두리,셀 스타일,표서식, 표 옵션,메모]
[6]표시형식, 조건부서식[셀서식(표시형식),사용자지정 표시형식,조건부서식 1 (셀 값 기준 조건부)]
[7]그래픽요소[그림, 클립아트,도형,워드아트]
[8]중간 점검 : 예제 따라하기
[9]셀참조[상대참조, 절대참조, 혼합참조,기본함수 ,SUM, AVERAGE, MAX, MIN, COUNT]
[10]데이터관리 1[중복 항목 제거,조건부서식 2 (수식을 사용한 조건부),유효성검사]
[11]데이터관리 2[자동필터,고급필터]
[12]통계함수[(COUNTA, COUNTIF, LARGE, SMALL, MEDIEN, RANK, &연산자)
[13]수학/삼각함수(ROUND, ROUNDUP, ROUNDDOWN, MOD, PRODUCT, SUMPRODUCT, SUMIF)
[14]논리함수(IF, AND, OR, NOT, TRUE, FALSE)
[15]텍스트함수(LEFT, RIGHT, MID, VALUE, REPT)날짜/시간함수(TODAY, NOW, YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, DATE, TIME, WEEKDAY
[16]데이터베이스함수(DSUM, DAVERAGE, DCOUNT, DCOUNTA, DMAX, DMIN, DGET)정보함수
[17]찾기/참조함수(VLOOKUP, HLOOKUP, CHOOSE, MATCH, INDEX)
[18]중간 점검 : 예제 따라하기 2
[19]데이터 관리 3[정렬,부분합,윤곽선,목표값 찾기]
[20]피벗테이블
[21]차트
[22]중간 점검 : 예제 따라하기 3
[23]기출문제풀이 목표값,필터,정렬,부분합 1-1
[24]기출문제풀이 목표값,필터,정렬,부분합 1-2
[25]기출문제풀이 목표값,필터,정렬,부분합 1-3
[26]기출문제풀이 목표값,필터,정렬,부분합 2-1
[27]기출문제풀이 목표값,필터,정렬,부분합 2-2
[28]기출문제풀이 필터,표 서식 피벗테이블 1-1
[29]기출문제풀이 필터,표 서식 피벗테이블 1-2
[30]기출문제풀이 필터,표 서식 피벗테이블 2-1
[31]기출문제풀이 필터,표 서식 피벗테이블 2-2
----
개발자 연락처 :
02-584-2478
강남구 대치동 901-55

☞ Video Training specializes in computer programs registered with the Department of Education is a lifelong education facilities.
There is a video tutorial to grasp credits and qualifications, employment and in practice is very helpful.

♥
Please do not hesitate to learn and easy video applications

[Video Course Training Table of Contents]
[1] ITQ to take the test and how to introduce four patterns EXCEL questions Learn about this item
[2] basic work in Excel [Excel Screen Layout, Open, Save, New, and select cells, sheets Administration
[3] data input, line / thermal management [number, date / time, letters, Chinese characters, special characters, formulas, row / column add, delete, and height / width Specify
[4] Edit Data Cell, move, copy, fill handle, custom lists, choose Paste Special, camera]
[5] Format Cells [font, alignment, borders, cell styles, table formats, list options, notes]
[6], the display format, conditional formatting, Cell formatting (Display Format), a custom display format, conditional formatting, one (based on a cell value conditional)]
[7] graphic elements [pictures, clip art, shapes, word art]
[8] Medium inspection: an example to follow
[9] See the cell [relative, absolute reference, mixed reference, the main function, SUM, AVERAGE, MAX, MIN, COUNT]
[10] Data Management 1 [duplicates removed, two conditional formatting (conditional formula used), Validation
[11] Data Management 2 [Auto Filter, Advanced Filter
[12] Statistical Functions [(COUNTA, COUNTIF, LARGE, SMALL, MEDIEN, RANK, & operator)
[13] math / trigonometry functions (ROUND, ROUNDUP, ROUNDDOWN, MOD, PRODUCT, SUMPRODUCT, SUMIF)
[14] The logical function (IF, AND, OR, NOT, TRUE, FALSE)
[15] text functions (LEFT, RIGHT, MID, VALUE, REPT) Date / Time functions (TODAY, NOW, YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, DATE, TIME, WEEKDAY
[16] database functions (DSUM, DAVERAGE, DCOUNT, DCOUNTA, DMAX, DMIN, DGET) Information Functions
[17] find / reference functions (VLOOKUP, HLOOKUP, CHOOSE, MATCH, INDEX)
[18] Mid-check: to follow the example 2
[19] Data Management 3 [sort, subtotal, outlines, Goal Seek]
[20] The Pivot Table
[21] Charts
[22] Mid-check: to follow the example 3
[23] The target value past exam pool, filter, sort, subtotal, 1-1
[24] The target value past exam pool, filter, sort, subtotal, 1-2
[25] The target value past exam pool, filter, sort, subtotal, 1-3
[26] past exam pool target value, filter, sort, subtotal, 2-1
[27] The target value past exam pool, filter, sort, subtotal, 2-2
[28] past exam pool filters, pivot tables Formatting tables 1-1
[29] past exam pool filters, pivot tables Formatting tables 1-2
[30] past exam pool filters, pivot tables Formatting tables 2-1
[31] past exam pool filters, pivot tables Formatting tables 2-2