ABCD
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 World1.2.2. Hello Worldhttps://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
XLSX1.3.2. Financial Sample.xlsx1.3.2. Financial Sample.xlsxhttps://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. SUM3.1.3.1. SUMhttps://docs.google.com/spreadsheets/d/1tUNI07sey4fTBTmzo385zKT19s6yFxCirQX01aTJr1Q
40
스프레드시트3.1.3.2. IF3.1.3.2. IFhttps://docs.google.com/spreadsheets/d/1jcqISGs_5NVegBpVYJH5eRtz-RGkiZzTcvaxlpxnXA0
41
스프레드시트3.1.3.3. COUNTIF/COUNTIFS3.1.3.3. COUNTIF/COUNTIFShttps://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. AVERAGE3.1.4. AVERAGEhttps://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. COUNTA3.1.4. COUNTAhttps://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. RANK3.1.4. RANKhttps://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. VLOOKUP3.1.5. VLOOKUPhttps://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, MIN3.2.1. MAX, MINhttps://docs.google.com/spreadsheets/d/1x7FmaKnzSzjdpOSQVWsRftgZhNJSYFQQP2TpIIgGEXE
52
스프레드시트3.2.2. ROUND,ROUNDDOWN,ROUNDUP3.2.2. ROUND,ROUNDDOWN,ROUNDUPhttps://docs.google.com/spreadsheets/d/1UPRHtgRFlKq_4oWU3oSfgXU6kx-NXdOZN_yU9lVuVDI
53
스프레드시트3.3.1. LEFT,RIGHT,MID3.3.1. LEFT,RIGHT,MIDhttps://docs.google.com/spreadsheets/d/1y41JrVo7s1gkOffudqdnILQ7VHYrWkVsdMLHid7SX8w
54
스프레드시트3.3.2. FIND,SEARCH3.3.2. FIND,SEARCHhttps://docs.google.com/spreadsheets/d/1JvX5xCVfE673UjdmFUfwtEEQXtfMbQaRj3xwaXAPaKU
55
스프레드시트3.3.3. REPLACE3.3.3. REPLACEhttps://docs.google.com/spreadsheets/d/1lCZM9Z83mJEOkRGwIbocSceXoDTJS2jW_G4KGJO3V6k
56
스프레드시트3.3.4. SUBSTITUTE3.3.4. SUBSTITUTEhttps://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. TRIM3.3.5. TRIMhttps://docs.google.com/spreadsheets/d/14_GJ-F0veBBvzIM4pRG_61w19SOLm458V5ZBfHM-uGo
59
스프레드시트3.3.6. DATE3.3.6. DATEhttps://docs.google.com/spreadsheets/d/1zR2dChpok3S2GsUGi_glEhj1WG9ucsGuRYjic_L2wDQ
60
스프레드시트3.3.7. TEXTJOIN3.3.7. TEXTJOINhttps://docs.google.com/spreadsheets/d/19dujjeEslqTG6yClG03moP-1X-lYL5Z73RrvP2Gzuz0
61
스프레드시트3.4.1. AND,OR3.4.1. AND,ORhttps://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,IFS3.4.2. IF,IFShttps://docs.google.com/spreadsheets/d/1HMOcUk_Z7Ccl7QZEsYWd_SLb8Qlfu5ptl22Kyq_N7Mc
64
스프레드시트3.4.3. SUMIF3.4.3. SUMIFhttps://docs.google.com/spreadsheets/d/1CrBiwSKdDhOO2_HCZiUT1iyC71ciMRg_ov5rs2347Hc
65
스프레드시트3.4.3. SUMIFS3.4.3. SUMIFShttps://docs.google.com/spreadsheets/d/1EywxUrgSgeOIvCR347ndm-1qO7K33j8QlPAa9_YiwZQ
66
스프레드시트3.4.4. MAXIFS3.4.4. MAXIFShttps://docs.google.com/spreadsheets/d/1uakZK7L2nIOk_IIfTHU-B3V1SFEE-kAt0hbP3L6FcXk
67
스프레드시트3.4.5. MATCH3.4.5. MATCHhttps://docs.google.com/spreadsheets/d/1yc5YnTwUXITQFE39OPIWaiK2Ejr-GK0yC1Z3wDMq3qU
68
스프레드시트3.4.6. INDEX3.4.6. INDEXhttps://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. IFERROR3.4.8. IFERRORhttps://docs.google.com/spreadsheets/d/1eUlzS0BF4wrd-zpnBAX7U9HTfSEh0FlAAv7k_1KoTgA
71
스프레드시트3.5.1. TODAY3.5.1. TODAYhttps://docs.google.com/spreadsheets/d/1dPTOETrBKwQe6jOGDI5F0g1HoZmwB9RqAIjbHPUe09g
72
스프레드시트3.5.2. NOW3.5.2. NOWhttps://docs.google.com/spreadsheets/d/1rRmxdNupI-MpH--QXbVHUUS1w52CaqFUCJFfVmwxINU
73
스프레드시트3.5.3. YEAR,MONTH,DAY3.5.3. YEAR,MONTH,DAYhttps://docs.google.com/spreadsheets/d/1aZ6nF0GwX2YAhSAyZXawTmkBeB9aUyey1cG4YJy92_g
74
스프레드시트3.5.4. DATEDIF3.5.4. DATEDIFhttps://docs.google.com/spreadsheets/d/10bZRWNOxM_eATlwnIhkwTYnGCjw_5N1O0XGbkR3hG4k
75
스프레드시트3.5.5. EOMONTH3.5.5. EOMONTHhttps://docs.google.com/spreadsheets/d/1HOwgEv0C7kx1iranw33Vn3qsyvpcq1ObGi0DwsySi4I
76
스프레드시트3.5.6. WORKDAY,NETWORKDAYS3.5.6. WORKDAY,NETWORKDAYShttps://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. FILTER4.2.1. FILTERhttps://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함수_VLOOKUP4.2.3. FILTER함수_VLOOKUPhttps://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. UNIQUE5.1.2. UNIQUEhttps://docs.google.com/spreadsheets/d/16sIKb4ymkX9iFfvBwZEfkWVpTXlpUkXHJBmiJdAy7Wc
100
스프레드시트5.1.3. SORT5.1.3. SORThttps://docs.google.com/spreadsheets/d/1IPTBE-rT7ENORaavwTkczS06teaeWeOSYYMQJPA368o