A | B | C | D | |
---|---|---|---|---|
1 | 원본위치 | Original | ||
2 | * 실습은 사본만들기 열(C열)의 링크를 클릭하여 사본을 생성한 뒤 진행해 주십시오. | |||
3 | * 원본에는 뷰어 권한만 부여됩니다. 뷰어 권한만 필요한 경우 D열의 링크를 클릭하세요. | |||
4 | ||||
5 | 파일과 폴더 목록 | |||
6 | 종류 | 이름 | 사본만들기 | 원본(뷰어 권한) |
7 | 폴더 | 1장 | https://drive.google.com/drive/folders/1tloC3qX8k_hMaVeR1OpbVjEdHCZ8Nx0V | |
8 | 폴더 | 2장 | https://drive.google.com/drive/folders/1DuCRgnmHUKe7nI6ystOFagPHqXRp5dKY | |
9 | 폴더 | 3장 | https://drive.google.com/drive/folders/1WUb-Rxg0DQNhwwu8jVmL0ujUEXmG3L1D | |
10 | 폴더 | 4장 | https://drive.google.com/drive/folders/1rhC_ekoDD06Ph5HKc85FjhLW8Iv1A5vZ | |
11 | 폴더 | 5장 | https://drive.google.com/drive/folders/1hCegkU3Xe_90zAJJ0ypsk8Km6KmyJCPm | |
12 | 폴더 | 6장 | https://drive.google.com/drive/folders/1Fw42Yon4g41G2-Oj-6vfqoZ8Al8I8UKJ | |
13 | 폴더 | 7장 | https://drive.google.com/drive/folders/1pstwc4AyMeEeVMWleeFe3ek076-YlR8R | |
14 | 폴더 | 8장 | https://drive.google.com/drive/folders/1PLHzVw5ZBJQpCvhFn3Cnhq-raf7tkz6u | |
15 | 스프레드시트 | 1.2.2. Hello World | 1.2.2. Hello World | https://docs.google.com/spreadsheets/d/1TOS8C-OFri-LHkLQVkN4HrzwU4mft2gJlteOmnHUJWI |
16 | 스프레드시트 | 1.3.2. Financial Sample_완성 | 1.3.2. Financial Sample_완성 | https://docs.google.com/spreadsheets/d/1rFnKIYP9fPEq_N2ocmlwx5Zgordrhx-eIfySZfKVX48 |
17 | XLSX | 1.3.2. Financial Sample.xlsx | 1.3.2. Financial Sample.xlsx | https://docs.google.com/spreadsheets/d/1AIPwT2GyNuHRF-cQy-1NQiFC-WT3yxAf |
18 | 스프레드시트 | 2.1.1.1 셀이동 | 2.1.1.1 셀이동 | https://docs.google.com/spreadsheets/d/1mVZDhFcvt1InV9B8OPIuaIbxQwYSNx6HBkLZR9RgeYc |
19 | 스프레드시트 | 2.1.1.2. 열과 행 추가 | 2.1.1.2. 열과 행 추가 | https://docs.google.com/spreadsheets/d/1fuczV56zo9H7kwX8bIFSsAwocM0_826naC46oFPwPXI |
20 | 스프레드시트 | 2.1.1.3. 문자와 숫자 | 2.1.1.3. 문자와 숫자 | https://docs.google.com/spreadsheets/d/1Xn28nh_sc3gWXxmGzHHMjGUVmiPsnlABzAgeRbrqap8 |
21 | 스프레드시트 | 2.1.2.1. 자동완성 | 2.1.2.1. 자동완성 | https://docs.google.com/spreadsheets/d/1DJHpDKwL9KLvwwyK5aFdijxAYTLWGToaV-fEc1LhkNI |
22 | 스프레드시트 | 2.1.2.2. 채워넣기 | 2.1.2.2. 채워넣기 | https://docs.google.com/spreadsheets/d/1gj94XETjw4K77VFls8tPnwX2BYlLFEMmq9e-IW3YTSU |
23 | 스프레드시트 | 2.1.2.3. 일괄 입력하기_완성 | 2.1.2.3. 일괄 입력하기_완성 | https://docs.google.com/spreadsheets/d/1rCgBHw5a9sqLc6955KP46zIaXGaLkinaNtkDvOZ_2ao |
24 | 스프레드시트 | 2.1.2.4. 선택하여 붙여넣기 | 2.1.2.4. 선택하여 붙여넣기 | https://docs.google.com/spreadsheets/d/14iKUXuIDoKfHbvdSUbKHTfOOG0KyUglk9knWlTbI6Gw |
25 | 스프레드시트 | 2.1.3. 셀 찾기/바꾸기 | 2.1.3. 셀 찾기/바꾸기 | https://docs.google.com/spreadsheets/d/1OCSB_QZLu0oC_xqVtilzk7dJXFj1mDK9gXBN-OSi8RU |
26 | 스프레드시트 | 2.2.1. 간단한 수식 | 2.2.1. 간단한 수식 | https://docs.google.com/spreadsheets/d/1Waubr829wT7Il778qxftIRZUxkw1ClvQR5JmdjI52Is |
27 | 스프레드시트 | 2.2.2. 상대참조/절대참조 | 2.2.2. 상대참조/절대참조 | https://docs.google.com/spreadsheets/d/1_yghy8XdcwYIsUr21LUQc5vRp96hg7rAOsPZOeA3_wM |
28 | 스프레드시트 | 2.2.2. 열린 참조 | 2.2.2. 열린 참조 | https://docs.google.com/spreadsheets/d/1EZ24Db7CL64McSGPMwSTtQoZduziKZmqHxMZBXgoTpw |
29 | 스프레드시트 | 2.3.1. 시트 추가 삭제_완성 | 2.3.1. 시트 추가 삭제_완성 | https://docs.google.com/spreadsheets/d/1HB-qNSGqZFwJf9FiF87ZA3tZhaUsaiiroqwCKqlpnc4 |
30 | 스프레드시트 | 2.3.2. 시트 참조 | 2.3.2. 시트 참조 | https://docs.google.com/spreadsheets/d/12qyJgCnDacLW6V7BXYOFOV4Qmxhqh7QDEcoweu1erco |
31 | 스프레드시트 | 2.4.1. 글꼴과 서식 | 2.4.1. 글꼴과 서식 | https://docs.google.com/spreadsheets/d/1api6GQ3tcFh7LQrNHAhuSLmK6QTq_LJc7w-fOsS8J_U |
32 | 스프레드시트 | 2.4.4.1. 숫자서식 | 2.4.4.1. 숫자서식 | https://docs.google.com/spreadsheets/d/1SHu608Z3r0t85djk4lgctsMSjP9xhzFezWyAi4Z6DP8 |
33 | 스프레드시트 | 2.4.4.2. 서식 복사하기 | 2.4.4.2. 서식 복사하기 | https://docs.google.com/spreadsheets/d/1WKUH7kJTur6jNosKa0uBcdEjnuHpKfIIbp0B8cDm_w8 |
34 | 스프레드시트 | 2.4.4.3. 맞춤 숫자 형식 | 2.4.4.3. 맞춤 숫자 형식 | https://docs.google.com/spreadsheets/d/1cazOouqC78QR8GpcGIpaMv1jQb4pPX04O_q9WwVTMFk |
35 | 스프레드시트 | 2.4.5. 셀 테두리와 색상 | 2.4.5. 셀 테두리와 색상 | https://docs.google.com/spreadsheets/d/1LB5efBeeRZI6zapTktXHv6Ka_wg5tz51Gt5Xm3PTJqg |
36 | 스프레드시트 | 2.4.6. 고정 | 2.4.6. 고정 | https://docs.google.com/spreadsheets/d/1AT3lBlqibfns2qzisSGmsLWABtQv0CH2G8pEtz2n1QQ |
37 | 스프레드시트 | 2.5.2. 댓글 채팅 | 2.5.2. 댓글 채팅 | https://docs.google.com/spreadsheets/d/19bmdPTVgFbQUqp8XpWPp6YT0vj4MDDccfIT5XawUm8g |
38 | 스프레드시트 | 3.1.2. 연산자 | 3.1.2. 연산자 | https://docs.google.com/spreadsheets/d/1bMBTwDU3volXOlDlxbd0twB2uV66SXg0cdHzVbt4AGU |
39 | 스프레드시트 | 3.1.3.1. SUM | 3.1.3.1. SUM | https://docs.google.com/spreadsheets/d/1tUNI07sey4fTBTmzo385zKT19s6yFxCirQX01aTJr1Q |
40 | 스프레드시트 | 3.1.3.2. IF | 3.1.3.2. IF | https://docs.google.com/spreadsheets/d/1jcqISGs_5NVegBpVYJH5eRtz-RGkiZzTcvaxlpxnXA0 |
41 | 스프레드시트 | 3.1.3.3. COUNTIF/COUNTIFS | 3.1.3.3. COUNTIF/COUNTIFS | https://docs.google.com/spreadsheets/d/1V0G-Mcu70xjJMnCOk02AkPANNm2E2siLraZGtGrS-H4 |
42 | 스프레드시트 | 3.1.3.3. COUNTIF/COUNTIFS_완성 | 3.1.3.3. COUNTIF/COUNTIFS_완성 | https://docs.google.com/spreadsheets/d/1YNHoFlf-15-XdXItKPYnZPOwMJgWDvCSWS72Q6P4UPM |
43 | 스프레드시트 | 3.1.4. AVERAGE | 3.1.4. AVERAGE | https://docs.google.com/spreadsheets/d/1VUx2b-cNr1pBFYTjmW6jTKSp5vAo7xY1HngERHRCvKA |
44 | 스프레드시트 | 3.1.4. AVERAGE_완성 | 3.1.4. AVERAGE_완성 | https://docs.google.com/spreadsheets/d/1OEwpDVo9F99Y_5rt7zRG0536Ni3qyvwsV6g5qXlGAIE |
45 | 스프레드시트 | 3.1.4. COUNTA | 3.1.4. COUNTA | https://docs.google.com/spreadsheets/d/1QzxHEb7y2OM3BUzrbIINgBDJeSwERRSueI5QsgbKb68 |
46 | 스프레드시트 | 3.1.4. COUNTA_완성 | 3.1.4. COUNTA_완성 | https://docs.google.com/spreadsheets/d/1Y2OTMmY_TXTDjWWEVpq3RrPSiPyS4iivA4ScApah4_0 |
47 | 스프레드시트 | 3.1.4. RANK | 3.1.4. RANK | https://docs.google.com/spreadsheets/d/1gebdrk9bjCBBkdjYuptdRwCFfD80vc1u7ZCQ46-km9I |
48 | 스프레드시트 | 3.1.4. RANK_완성 | 3.1.4. RANK_완성 | https://docs.google.com/spreadsheets/d/1oIecTlpAcowu6h2BrKhb4uaG6DjnqO346gff9AzNq7k |
49 | 스프레드시트 | 3.1.5. VLOOKUP | 3.1.5. VLOOKUP | https://docs.google.com/spreadsheets/d/1PmlwdOFziOby3KvS_4KaPwx0wB9pfYdybbkYRe0ddyU |
50 | 스프레드시트 | 3.1.5. VLOOKUP_완성 | 3.1.5. VLOOKUP_완성 | https://docs.google.com/spreadsheets/d/1luVsR_jJtoTWjgFPAPTvowCqCnQpqsM6KLUAeFS1H7M |
51 | 스프레드시트 | 3.2.1. MAX, MIN | 3.2.1. MAX, MIN | https://docs.google.com/spreadsheets/d/1x7FmaKnzSzjdpOSQVWsRftgZhNJSYFQQP2TpIIgGEXE |
52 | 스프레드시트 | 3.2.2. ROUND,ROUNDDOWN,ROUNDUP | 3.2.2. ROUND,ROUNDDOWN,ROUNDUP | https://docs.google.com/spreadsheets/d/1UPRHtgRFlKq_4oWU3oSfgXU6kx-NXdOZN_yU9lVuVDI |
53 | 스프레드시트 | 3.3.1. LEFT,RIGHT,MID | 3.3.1. LEFT,RIGHT,MID | https://docs.google.com/spreadsheets/d/1y41JrVo7s1gkOffudqdnILQ7VHYrWkVsdMLHid7SX8w |
54 | 스프레드시트 | 3.3.2. FIND,SEARCH | 3.3.2. FIND,SEARCH | https://docs.google.com/spreadsheets/d/1JvX5xCVfE673UjdmFUfwtEEQXtfMbQaRj3xwaXAPaKU |
55 | 스프레드시트 | 3.3.3. REPLACE | 3.3.3. REPLACE | https://docs.google.com/spreadsheets/d/1lCZM9Z83mJEOkRGwIbocSceXoDTJS2jW_G4KGJO3V6k |
56 | 스프레드시트 | 3.3.4. SUBSTITUTE | 3.3.4. SUBSTITUTE | https://docs.google.com/spreadsheets/d/1LztDAjF6-rbNdvLbn9XhpX4xofdHeeL-w-IgbDBBr6I |
57 | 스프레드시트 | 3.3.4. SUBSTITUTE_완성 | 3.3.4. SUBSTITUTE_완성 | https://docs.google.com/spreadsheets/d/1-CXVa-2lXR3cA6wTFn2CVNkICeRwUbVHRKhKoL5lGfY |
58 | 스프레드시트 | 3.3.5. TRIM | 3.3.5. TRIM | https://docs.google.com/spreadsheets/d/14_GJ-F0veBBvzIM4pRG_61w19SOLm458V5ZBfHM-uGo |
59 | 스프레드시트 | 3.3.6. DATE | 3.3.6. DATE | https://docs.google.com/spreadsheets/d/1zR2dChpok3S2GsUGi_glEhj1WG9ucsGuRYjic_L2wDQ |
60 | 스프레드시트 | 3.3.7. TEXTJOIN | 3.3.7. TEXTJOIN | https://docs.google.com/spreadsheets/d/19dujjeEslqTG6yClG03moP-1X-lYL5Z73RrvP2Gzuz0 |
61 | 스프레드시트 | 3.4.1. AND,OR | 3.4.1. AND,OR | https://docs.google.com/spreadsheets/d/13WBrYf-Udrlf90Ya__X6kLG8HZQp6kzYIkpIMe93OeE |
62 | 스프레드시트 | 3.4.1. AND,OR_완성 | 3.4.1. AND,OR_완성 | https://docs.google.com/spreadsheets/d/1u5cGnCQ4AGg5lqHzqoHlO4HlLZ7xYRUiKksUaPUjnhM |
63 | 스프레드시트 | 3.4.2. IF,IFS | 3.4.2. IF,IFS | https://docs.google.com/spreadsheets/d/1HMOcUk_Z7Ccl7QZEsYWd_SLb8Qlfu5ptl22Kyq_N7Mc |
64 | 스프레드시트 | 3.4.3. SUMIF | 3.4.3. SUMIF | https://docs.google.com/spreadsheets/d/1CrBiwSKdDhOO2_HCZiUT1iyC71ciMRg_ov5rs2347Hc |
65 | 스프레드시트 | 3.4.3. SUMIFS | 3.4.3. SUMIFS | https://docs.google.com/spreadsheets/d/1EywxUrgSgeOIvCR347ndm-1qO7K33j8QlPAa9_YiwZQ |
66 | 스프레드시트 | 3.4.4. MAXIFS | 3.4.4. MAXIFS | https://docs.google.com/spreadsheets/d/1uakZK7L2nIOk_IIfTHU-B3V1SFEE-kAt0hbP3L6FcXk |
67 | 스프레드시트 | 3.4.5. MATCH | 3.4.5. MATCH | https://docs.google.com/spreadsheets/d/1yc5YnTwUXITQFE39OPIWaiK2Ejr-GK0yC1Z3wDMq3qU |
68 | 스프레드시트 | 3.4.6. INDEX | 3.4.6. INDEX | https://docs.google.com/spreadsheets/d/1Cj0TmGXlG8W-Dua_7-ip7AeQ6hJPoh6ixSH59oUx0tw |
69 | 스프레드시트 | 3.4.7. VLOOKUP 세율 구간 | 3.4.7. VLOOKUP 세율 구간 | https://docs.google.com/spreadsheets/d/1rwW75vi8sYtsV1M6H-kaZqK7ZbJheFT1rLOP_7XMnTw |
70 | 스프레드시트 | 3.4.8. IFERROR | 3.4.8. IFERROR | https://docs.google.com/spreadsheets/d/1eUlzS0BF4wrd-zpnBAX7U9HTfSEh0FlAAv7k_1KoTgA |
71 | 스프레드시트 | 3.5.1. TODAY | 3.5.1. TODAY | https://docs.google.com/spreadsheets/d/1dPTOETrBKwQe6jOGDI5F0g1HoZmwB9RqAIjbHPUe09g |
72 | 스프레드시트 | 3.5.2. NOW | 3.5.2. NOW | https://docs.google.com/spreadsheets/d/1rRmxdNupI-MpH--QXbVHUUS1w52CaqFUCJFfVmwxINU |
73 | 스프레드시트 | 3.5.3. YEAR,MONTH,DAY | 3.5.3. YEAR,MONTH,DAY | https://docs.google.com/spreadsheets/d/1aZ6nF0GwX2YAhSAyZXawTmkBeB9aUyey1cG4YJy92_g |
74 | 스프레드시트 | 3.5.4. DATEDIF | 3.5.4. DATEDIF | https://docs.google.com/spreadsheets/d/10bZRWNOxM_eATlwnIhkwTYnGCjw_5N1O0XGbkR3hG4k |
75 | 스프레드시트 | 3.5.5. EOMONTH | 3.5.5. EOMONTH | https://docs.google.com/spreadsheets/d/1HOwgEv0C7kx1iranw33Vn3qsyvpcq1ObGi0DwsySi4I |
76 | 스프레드시트 | 3.5.6. WORKDAY,NETWORKDAYS | 3.5.6. WORKDAY,NETWORKDAYS | https://docs.google.com/spreadsheets/d/139jmrRT8oC9hXxdCICAk1rcqhQ0ynCCQoFVcDMl5yJE |
77 | 스프레드시트 | 4.1.1. 열기준정렬하기_화면예제 | 4.1.1. 열기준정렬하기_화면예제 | https://docs.google.com/spreadsheets/d/1yOqVLZ_7nzSb8XfsKZmOC4Ydddu1n-NrLk8LHXMneFo |
78 | 스프레드시트 | 4.1.2. 정렬하기 | 4.1.2. 정렬하기 | https://docs.google.com/spreadsheets/d/1DBypI6usQuKtkLBlen_8wNqCLh1M93-HOQZTLofApmA |
79 | 스프레드시트 | 4.2.1. FILTER | 4.2.1. FILTER | https://docs.google.com/spreadsheets/d/1BpnXpgWeFVF5RvNK-CSd8d4bg7wuACWdLwZIymwQY4o |
80 | 스프레드시트 | 4.2.1. 맞춤수식 | 4.2.1. 맞춤수식 | https://docs.google.com/spreadsheets/d/1QTbl-tJGhf4xyC1JAntZ4DgrOg-jC-_08vFhGFp0meM |
81 | 스프레드시트 | 4.2.2. FILTER 보기 | 4.2.2. FILTER 보기 | https://docs.google.com/spreadsheets/d/1EI01EatXEGosJTsMmpFhj594aJKJKoR6g3WhsaDrNks |
82 | 스프레드시트 | 4.2.2. FILTER 보기_완성 | 4.2.2. FILTER 보기_완성 | https://docs.google.com/spreadsheets/d/1ltDi7zEvfEIrrhPIafhaB9kJJtT7ptHiZeL0PwuH83A |
83 | 스프레드시트 | 4.2.3. FILTER함수 | 4.2.3. FILTER함수 | https://docs.google.com/spreadsheets/d/1tJ-HRRM2Eea2AcDq--aTL0HCfj94e4l_yvS1Tmwv7I0 |
84 | 스프레드시트 | 4.2.3. FILTER함수_VLOOKUP | 4.2.3. FILTER함수_VLOOKUP | https://docs.google.com/spreadsheets/d/1JaKHxZlFDXDkJrrUOXhWMiZLYcLBiehHDk5M_uSAE5Y |
85 | 스프레드시트 | 4.3.1. 피벗테이블 | 4.3.1. 피벗테이블 | https://docs.google.com/spreadsheets/d/1Eh3qyZVpbx8WOqNAgOnCrGDbOE12E5zPu63e8eTGHq4 |
86 | 스프레드시트 | 4.3.2. 피벗테이블_필드추가 | 4.3.2. 피벗테이블_필드추가 | https://docs.google.com/spreadsheets/d/1ap02UMUP-Qvph-_vhY0_2fYUxShzpUKpOy3aop3fgKY |
87 | 스프레드시트 | 4.3.3. 피벗테이블_슬라이서 | 4.3.3. 피벗테이블_슬라이서 | https://docs.google.com/spreadsheets/d/13OjyWodexmgIiIpMEUE0erJaRy92I32SHqWCrksDhl8 |
88 | 스프레드시트 | 4.3.3. 피벗테이블_필터 | 4.3.3. 피벗테이블_필터 | https://docs.google.com/spreadsheets/d/1bJBnVTI2VRtAMMTuu5nWAQwHq5Ti7amc2OlpG13_Vlo |
89 | 스프레드시트 | 4.3.4. 피벗테이블_요약기준 | 4.3.4. 피벗테이블_요약기준 | https://docs.google.com/spreadsheets/d/1hzXxJT8rui47xUg0sY-MdywetsLi800fOdLW08j11Fs |
90 | 스프레드시트 | 4.3.5. 피벗테이블_그룹화 | 4.3.5. 피벗테이블_그룹화 | https://docs.google.com/spreadsheets/d/1YyDU39R_rqK3YO3okuBDsCm-sozoi2ioiMaLT_-_cus |
91 | 스프레드시트 | 4.4.1. 교차색상 | 4.4.1. 교차색상 | https://docs.google.com/spreadsheets/d/1Y2AJLYRuNotZCPrXsI69XNwma98RAptrZ1hOZEQROZU |
92 | 스프레드시트 | 4.4.2. 조건부서식 | 4.4.2. 조건부서식 | https://docs.google.com/spreadsheets/d/1MCfnXbPCsYQ2B1JZax9MQwfqcsQ6QkiuqeTxFPOV2Is |
93 | 스프레드시트 | 4.4.2. 조건부서식_맞춤수식 | 4.4.2. 조건부서식_맞춤수식 | https://docs.google.com/spreadsheets/d/1kOP8WwRjT7nIcabZLN4hS2umhB3UTJeIDnQFvVvgaVg |
94 | 스프레드시트 | 4.4.2. 조건부서식_색상스케일 | 4.4.2. 조건부서식_색상스케일 | https://docs.google.com/spreadsheets/d/1sU659XBBoSJWR7yvv6fe1Gto86PsnDlk_GRCBc3JDd4 |
95 | 스프레드시트 | 4.5.1. 중복항목삭제/공백제거 | 4.5.1. 중복항목삭제/공백제거 | https://docs.google.com/spreadsheets/d/1fue_m2e_Drf9mwwdCdtnuz_MAIu6xc2d4FrHgV3oOf8 |
96 | 스프레드시트 | 4.5.3. 텍스트를 열로 분할 | 4.5.3. 텍스트를 열로 분할 | https://docs.google.com/spreadsheets/d/1ZOx096tZMSyjefThJbFfrWmGyFzeI1jxCNplN_O65Pk |
97 | 스프레드시트 | 4.5.4. 데이터 확인 | 4.5.4. 데이터 확인 | https://docs.google.com/spreadsheets/d/1REAnAa9ZTpvHpxa6xYvyYXz3DB1pPoF238oCoSd1KxM |
98 | 스프레드시트 | 5.1.1. 텍스트를 열로 분할(SPLIT함수) | 5.1.1. 텍스트를 열로 분할=HYPERLINK(SPLIT함수) | https://docs.google.com/spreadsheets/d/1dg_W3c8slQyz51q8PTUZJSo0AKodp_P3w08dRLhZLIY |
99 | 스프레드시트 | 5.1.2. UNIQUE | 5.1.2. UNIQUE | https://docs.google.com/spreadsheets/d/16sIKb4ymkX9iFfvBwZEfkWVpTXlpUkXHJBmiJdAy7Wc |
100 | 스프레드시트 | 5.1.3. SORT | 5.1.3. SORT | https://docs.google.com/spreadsheets/d/1IPTBE-rT7ENORaavwTkczS06teaeWeOSYYMQJPA368o |