ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
원본위치Original
2
* 실습은 사본만들기 열(C열)의 링크를 클릭하여 사본을 생성한 뒤 진행해 주십시오.
3
* 원본에는 뷰어 권한만 부여됩니다. 뷰어 권한만 필요한 경우 D열의 링크를 클릭하세요.
4
5
파일과 폴더 목록
6
종류이름사본만들기원본(뷰어 권한)
7
폴더1장https://drive.google.com/drive/folders/1BuXFf-j6gLOda0tl9SuWSEWL-eN4Uei_
8
폴더2장https://drive.google.com/drive/folders/1XL08fbFv1EW_sGDqGghZ3zEphvLiJmqR
9
폴더3장https://drive.google.com/drive/folders/12V-xLKGUNjgcBwd8yHqaKLYz3JshZoMU
10
폴더4장https://drive.google.com/drive/folders/1X1TovxhYD_z1b-P1DcW7gfc9V7mkEQY9
11
폴더5장https://drive.google.com/drive/folders/1hGNIXvcTrsx11PiJw-ykxppjV-o9fSRm
12
폴더6장https://drive.google.com/drive/folders/1BwLIo2ccjR7Lf80_zkbVBMrzpqgiv_LF
13
폴더7장https://drive.google.com/drive/folders/1NzIALz9SOSwp_58Q1AfUDELjKTclqvQw
14
폴더8장https://drive.google.com/drive/folders/1wDpyBf8jBdaZEgkj7C8wa6TevHQKB7WC
15
스프레드시트1.2.2. Hello World1.2.2. Hello Worldhttps://docs.google.com/spreadsheets/d/1bSeH0qe1mjhcbFpBAT6JAfgY1svPEjyirG1aGwsfYsE/edit?usp=drivesdk
16
XLSX1.3.2. Financial Sample.xlsx1.3.2. Financial Sample.xlsxhttps://docs.google.com/spreadsheets/d/1MB_9BsnH8Fa1tPuqysB__JXNs6vT0Jml/edit?usp=drivesdk&ouid=114389200516560431464&rtpof=true&sd=true
17
스프레드시트1.3.2. Financial Sample_완성1.3.2. Financial Sample_완성https://docs.google.com/spreadsheets/d/1imnT-AvXN5OLq2QyraLLrjkRJWCjrCcCOHvNTGtLLEQ/edit?usp=drivesdk
18
스프레드시트2.1.1.1 셀이동2.1.1.1 셀이동https://docs.google.com/spreadsheets/d/1_2ags0PrhPysNUSKR-X_o1wRSlMFeKqOCezcZoELtE0/edit?usp=drivesdk
19
스프레드시트2.1.1.2. 열과 행 추가2.1.1.2. 열과 행 추가https://docs.google.com/spreadsheets/d/1VvK4K3r6u16olrLreCog3nDDcP7JfDS6lWRy0tkqgn4/edit?usp=drivesdk
20
스프레드시트2.1.1.3. 문자와 숫자2.1.1.3. 문자와 숫자https://docs.google.com/spreadsheets/d/1VzWARcw41ypd5hGZOLum_5kiNnE3jJQjjaWviqfot_U/edit?usp=drivesdk
21
스프레드시트2.1.2.1. 자동완성2.1.2.1. 자동완성https://docs.google.com/spreadsheets/d/1nNQzY7iYxFsq12oWDo0aPWTrlRtM-E9MOwHfGjmM23E/edit?usp=drivesdk
22
스프레드시트2.1.2.2. 채워넣기2.1.2.2. 채워넣기https://docs.google.com/spreadsheets/d/1BCKxzP2ViQJjootBCtXNsguwggK-kl2y_gqFgaDcg5g/edit?usp=drivesdk
23
스프레드시트2.1.2.3. 일괄 입력하기_완성2.1.2.3. 일괄 입력하기_완성https://docs.google.com/spreadsheets/d/13gc3ncEPQQJQSSGH_H0TqeEVUszmJZkuMhLVMA7EKIY/edit?usp=drivesdk
24
스프레드시트2.1.2.4. 선택하여 붙여넣기2.1.2.4. 선택하여 붙여넣기https://docs.google.com/spreadsheets/d/1QYcgE_2Bs_-12gnCuQrnAeic8y1SBh1L7e0ViWKozVw/edit?usp=drivesdk
25
스프레드시트2.1.3. 셀 찾기/바꾸기2.1.3. 셀 찾기/바꾸기https://docs.google.com/spreadsheets/d/1l7DaouT3MViUlyLbMC7fkFIL-VHIBM1Tn_2OQDQqDkY/edit?usp=drivesdk
26
스프레드시트2.2.1. 간단한 수식2.2.1. 간단한 수식https://docs.google.com/spreadsheets/d/1o-KeGtZ-2arrNomi18Tk9wzhe8VU6GNIh796nCeVgtE/edit?usp=drivesdk
27
스프레드시트2.2.2. 상대참조/절대참조2.2.2. 상대참조/절대참조https://docs.google.com/spreadsheets/d/17KftGiPCYFatiUbQmYfFNM3iP7sHWRCrFynIjWKgYVY/edit?usp=drivesdk
28
스프레드시트2.2.2. 열린 참조2.2.2. 열린 참조https://docs.google.com/spreadsheets/d/1lMzNfxppbhrHnPqZRnhgrh7I9Nu1vmmQbuxgn03uj_E/edit?usp=drivesdk
29
스프레드시트2.3.1. 시트 추가 삭제_완성2.3.1. 시트 추가 삭제_완성https://docs.google.com/spreadsheets/d/1pSNTE-xFfi2_DQ7hkjLDFHcCFhqDCUd000VT2-YVjQU/edit?usp=drivesdk
30
스프레드시트2.3.2. 시트 참조2.3.2. 시트 참조https://docs.google.com/spreadsheets/d/1JxmOsDkhnyeAwPKmnag7RMrqSkIiXQlCS0IVpNm-B8c/edit?usp=drivesdk
31
스프레드시트2.4.1. 글꼴과 서식2.4.1. 글꼴과 서식https://docs.google.com/spreadsheets/d/1QtIpoD7mi8wsjp9QjYnEzp9mxwwTrRjlniDzQ93uPWY/edit?usp=drivesdk
32
스프레드시트2.4.4.1. 숫자서식2.4.4.1. 숫자서식https://docs.google.com/spreadsheets/d/1iKFIR9CutneAx5zkiY9uHzus0zvzEIdN1rnNcsgfX5k/edit?usp=drivesdk
33
스프레드시트2.4.4.2. 서식 복사하기2.4.4.2. 서식 복사하기https://docs.google.com/spreadsheets/d/1cttAQMwWsMqKvV4tSp3tNxF8Bvk-YgYs7NLZn4PhBFI/edit?usp=drivesdk
34
스프레드시트2.4.4.3. 맞춤 숫자 형식2.4.4.3. 맞춤 숫자 형식https://docs.google.com/spreadsheets/d/1tBb8mYLkmyQeRwnYrtqcjxCOhlZiZThDxToS45q1Gi0/edit?usp=drivesdk
35
스프레드시트2.4.5. 셀 테두리와 색상2.4.5. 셀 테두리와 색상https://docs.google.com/spreadsheets/d/1qSyqV0mxyY5eEx3v3OKJ2mCCbGLjcHiPXOI2ZQIRjek/edit?usp=drivesdk
36
스프레드시트2.4.6. 고정2.4.6. 고정https://docs.google.com/spreadsheets/d/1YjOwWL67SxL7BKqboIkU0Jt1UVGOzaJ__4FR9rWWJyY/edit?usp=drivesdk
37
스프레드시트2.4.7. 댓글 채팅2.4.7. 댓글 채팅https://docs.google.com/spreadsheets/d/1LHGMQ23zBBhpiGK_6fH-HIRWRaMvJxw5vCYwkJ353mQ/edit?usp=drivesdk
38
스프레드시트3.1.2. 연산자3.1.2. 연산자https://docs.google.com/spreadsheets/d/1z4CL0a4kJSpdIuQTiSPM3VQ-nu_6BC0KzESv0ByIM3I/edit?usp=drivesdk
39
스프레드시트3.1.3.1. SUM3.1.3.1. SUMhttps://docs.google.com/spreadsheets/d/1r6fHiOHzhnwEVz6EwkOI9y1ieTtf7_k6WJBIo1lmVLE/edit?usp=drivesdk
40
스프레드시트3.1.3.2. IF3.1.3.2. IFhttps://docs.google.com/spreadsheets/d/179oNacaEsWRNcN6YFJZ3AHkQVEA2sVFn5WS_Kus4bFw/edit?usp=drivesdk
41
스프레드시트3.1.3.3. COUNTIF/COUNTIFS3.1.3.3. COUNTIF/COUNTIFShttps://docs.google.com/spreadsheets/d/17m7JKZUH4kQJ50NzM07cnDF-fe2tTh-4AH4rrN_odPs/edit?usp=drivesdk
42
스프레드시트3.1.3.3. COUNTIF/COUNTIFS_완성3.1.3.3. COUNTIF/COUNTIFS_완성https://docs.google.com/spreadsheets/d/1_7olx3g5wTTPK2RinugWIIzKsRBkqRkixGjM88fpAGc/edit?usp=drivesdk
43
스프레드시트3.1.4. AVERAGE3.1.4. AVERAGEhttps://docs.google.com/spreadsheets/d/1K5KcFdls1roxXfHnC-YAq_z7AnRlCh_gn7VwEVGW0cA/edit?usp=drivesdk
44
스프레드시트3.1.4. AVERAGE_완성3.1.4. AVERAGE_완성https://docs.google.com/spreadsheets/d/1H1Cv_fQpAL_5DaKskSIIy-Vu3zxMoYygtrAZsP5kjQ4/edit?usp=drivesdk
45
스프레드시트3.1.4. COUNTA3.1.4. COUNTAhttps://docs.google.com/spreadsheets/d/1CyioApXxqr8eShYsforS5fG0cjwSKbmQSXe_oRnrC1E/edit?usp=drivesdk
46
스프레드시트3.1.4. COUNTA_완성3.1.4. COUNTA_완성https://docs.google.com/spreadsheets/d/1K0dgK2HKFakxuFdqNskOFojheCHcVXbJ2C9Zx6FxA18/edit?usp=drivesdk
47
스프레드시트3.1.4. RANK3.1.4. RANKhttps://docs.google.com/spreadsheets/d/1vxOmrfCXG1i0n84UjxVVj5su0jVTnZMHt9bG9-XLzM4/edit?usp=drivesdk
48
스프레드시트3.1.4. RANK_완성3.1.4. RANK_완성https://docs.google.com/spreadsheets/d/1qgHA26ZczL5iEVysQK1WtGSjkXWIjGipwuUfWgCJaeA/edit?usp=drivesdk
49
스프레드시트3.1.5. VLOOKUP3.1.5. VLOOKUPhttps://docs.google.com/spreadsheets/d/1VzPTB5gKUh5zqUYvIOjtTES9uLldMn5jMBAeELQW-bE/edit?usp=drivesdk
50
스프레드시트3.1.5. VLOOKUP_완성3.1.5. VLOOKUP_완성https://docs.google.com/spreadsheets/d/1PaBNfxEZ-8PlSP_l_ITeRDqXRG--oBG6XxEs3_0S9rU/edit?usp=drivesdk
51
스프레드시트3.2.1. MAX, MIN3.2.1. MAX, MINhttps://docs.google.com/spreadsheets/d/1mO9fVOZleD8VJTIPJJo4C5O30RgVnJHHkkbP7IcnvGk/edit?usp=drivesdk
52
스프레드시트3.2.2. ROUND,ROUNDDOWN,ROUNDUP3.2.2. ROUND,ROUNDDOWN,ROUNDUPhttps://docs.google.com/spreadsheets/d/1b2a3JmeQlSu_IEevOcJs-cgB_CYSMvgbXewF55auIhQ/edit?usp=drivesdk
53
스프레드시트3.3.1. LEFT,RIGHT,MID3.3.1. LEFT,RIGHT,MIDhttps://docs.google.com/spreadsheets/d/1z8Zf1fjYHWsUB8WIbGu19typJhe9YlBHiF-RPLsRSH0/edit?usp=drivesdk
54
스프레드시트3.3.2. FIND,SEARCH3.3.2. FIND,SEARCHhttps://docs.google.com/spreadsheets/d/1TGe3JXgqrv1bmQsW03QgEhFiC82BmuzWeyZgeaG0OsE/edit?usp=drivesdk
55
스프레드시트3.3.3. REPLACE3.3.3. REPLACEhttps://docs.google.com/spreadsheets/d/1-ry_Zx4f8nlm1S4tf7Tkn-cbVWbUReAzHKv_Dgk2RAY/edit?usp=drivesdk
56
스프레드시트3.3.4. SUBSTITUTE3.3.4. SUBSTITUTEhttps://docs.google.com/spreadsheets/d/16KwduC0K26V_tU7SErHHETFfcAH4tF1JmJwDIj2NFGQ/edit?usp=drivesdk
57
스프레드시트3.3.4. SUBSTITUTE_완성3.3.4. SUBSTITUTE_완성https://docs.google.com/spreadsheets/d/1_2JpV_73LMTbl8u1i1PO2mUFgYKJBwiSNmtMEiEfVug/edit?usp=drivesdk
58
스프레드시트3.3.5. TRIM3.3.5. TRIMhttps://docs.google.com/spreadsheets/d/1fjOrHQPrxal2c2N4mjP8lk_yHGF2_DnJ2r0tMQZ7L4Q/edit?usp=drivesdk
59
스프레드시트3.3.6. DATE3.3.6. DATEhttps://docs.google.com/spreadsheets/d/16qbOU_f0W5jqXx_8jjl0t7hI0yghkmK04eJQiwkI7Zc/edit?usp=drivesdk
60
스프레드시트3.3.7. TEXTJOIN3.3.7. TEXTJOINhttps://docs.google.com/spreadsheets/d/15-M1uvjTpNC2UOI-A6OfZjFerWY1_CUj7YMKbIWHlQY/edit?usp=drivesdk
61
스프레드시트3.4.1. AND,OR3.4.1. AND,ORhttps://docs.google.com/spreadsheets/d/1g_VU8FUjKlaLOsKf2cxSO8bSOew3EAcdzlwkgxFCTtY/edit?usp=drivesdk
62
스프레드시트3.4.1. AND,OR_완성3.4.1. AND,OR_완성https://docs.google.com/spreadsheets/d/12XVDLAgO4DiRscvvbczQC2NALYONTHjvr1wFTGWyyOE/edit?usp=drivesdk
63
스프레드시트3.4.2. IF,IFS3.4.2. IF,IFShttps://docs.google.com/spreadsheets/d/1gX3Z-99bCx2D1j06iVOP0AbfYTszKa--4DRPHSFkmXE/edit?usp=drivesdk
64
스프레드시트3.4.3. SUMIF3.4.3. SUMIFhttps://docs.google.com/spreadsheets/d/1QcXWl5p0hbnSUMuUNVeZbLwtzCHuLA_h9DXNzJ7LcvQ/edit?usp=drivesdk
65
스프레드시트3.4.3. SUMIFS3.4.3. SUMIFShttps://docs.google.com/spreadsheets/d/19ByzfAxLlZs8Y505z-WKaYw34CNyVCC2dwqf6fM4eaE/edit?usp=drivesdk
66
스프레드시트3.4.4. MAXIFS3.4.4. MAXIFShttps://docs.google.com/spreadsheets/d/1fFf8nyv70FsVo9fDTU2cK2hf7q5-SCBC68mtZKNvzTE/edit?usp=drivesdk
67
스프레드시트3.4.5. MATCH3.4.5. MATCHhttps://docs.google.com/spreadsheets/d/1o-CLnGilwhOTc2LwTWuPVi-aGyVqeZ9YibQbk_U2s7s/edit?usp=drivesdk
68
스프레드시트3.4.6. INDEX3.4.6. INDEXhttps://docs.google.com/spreadsheets/d/12rkmuPC7xo37SDXWh--qU5gMFyZtzc2LSG788ma8uRs/edit?usp=drivesdk
69
스프레드시트3.4.7. VLOOKUP 세율 구간3.4.7. VLOOKUP 세율 구간https://docs.google.com/spreadsheets/d/1WKrKW04KVJZyhAGTBVEOfJFlQWvlfEfCzYm_ujilZC4/edit?usp=drivesdk
70
스프레드시트3.4.8. IFERROR3.4.8. IFERRORhttps://docs.google.com/spreadsheets/d/1FQlULlbCYp5y7iSiMk45rcLjDsqjrFki8JPQWT3MDm8/edit?usp=drivesdk
71
스프레드시트3.5.1. TODAY3.5.1. TODAYhttps://docs.google.com/spreadsheets/d/1be69Pa87byfaG7iOMyEHFUw7zcebkw4Ap3y7Bs8NGbI/edit?usp=drivesdk
72
스프레드시트3.5.2. NOW3.5.2. NOWhttps://docs.google.com/spreadsheets/d/1ja9J_PEWtHu-PipTy6JfhPogqY-TCs4ZstRbs-2pAG8/edit?usp=drivesdk
73
스프레드시트3.5.3. YEAR,MONTH,DAY3.5.3. YEAR,MONTH,DAYhttps://docs.google.com/spreadsheets/d/1mxlYduTntgysDfMFhGU1ZsUdSfe29Ky1TnI2vuzmtOM/edit?usp=drivesdk
74
스프레드시트3.5.4. DATEDIF3.5.4. DATEDIFhttps://docs.google.com/spreadsheets/d/1y5xmRmgwAwCZQjetrc9T3I3tdSf8oFBsHiUd8qsX5jQ/edit?usp=drivesdk
75
스프레드시트3.5.5. EOMONTH3.5.5. EOMONTHhttps://docs.google.com/spreadsheets/d/1jyN0vqny6HweILz3Pb5AV6hHVgA6sLPJ-gkSC808_9w/edit?usp=drivesdk
76
스프레드시트3.5.6. WORKDAY,NETWORKDAYS3.5.6. WORKDAY,NETWORKDAYShttps://docs.google.com/spreadsheets/d/1xxKhjcXoKJHn3a4g0rPKyz1OXmLG2WaCszpIT9zyTRQ/edit?usp=drivesdk
77
스프레드시트4.1.1. 열기준정렬하기_화면예제4.1.1. 열기준정렬하기_화면예제https://docs.google.com/spreadsheets/d/1JWWEXxO5-iSyxgJqfSyEzC4BzFti5SlOPSj3bNQJDn4/edit?usp=drivesdk
78
스프레드시트4.1.1. 정렬하기4.1.1. 정렬하기https://docs.google.com/spreadsheets/d/1yfXU7ND13tWuF-bpOtidQfeh6dCHOsX1Ai37lJbTiP8/edit?usp=drivesdk
79
스프레드시트4.2.1. FILTER4.2.1. FILTERhttps://docs.google.com/spreadsheets/d/1H5krA9PHILazZCY7K1_xJga9K4n-_-vMdBHfFrD9GmU/edit?usp=drivesdk
80
스프레드시트4.2.1. 맞춤수식4.2.1. 맞춤수식https://docs.google.com/spreadsheets/d/1BnggIGY3vYrkQhFCMMaNHBiQBixfbcLysL4MxZ9PDrM/edit?usp=drivesdk
81
스프레드시트4.2.2. FILTER 보기4.2.2. FILTER 보기https://docs.google.com/spreadsheets/d/15nBc8DSJRkNrqHFpJU1RtfWJYkzbIbO3EZaQBxnnvkE/edit?usp=drivesdk
82
스프레드시트4.2.2. FILTER 보기_완성4.2.2. FILTER 보기_완성https://docs.google.com/spreadsheets/d/1J7nccfGEIwSekNrwi1RgWfBi7GR7jXfsUNUVz8YtKic/edit?usp=drivesdk
83
스프레드시트4.2.3. FILTER함수4.2.3. FILTER함수https://docs.google.com/spreadsheets/d/1fFTe1NiQtlJzQ7X7IHDE_HZPsfO6Q0GjZ1mGKiYx9kA/edit?usp=drivesdk
84
스프레드시트4.2.3. FILTER함수_VLOOKUP4.2.3. FILTER함수_VLOOKUPhttps://docs.google.com/spreadsheets/d/1UaSnABhFI-bi4GlvKU2ZGRx0myWYEhWrSTvp3QqREVE/edit?usp=drivesdk
85
스프레드시트4.3.1. 피벗테이블4.3.1. 피벗테이블https://docs.google.com/spreadsheets/d/1f66XEojSqL0oDhi3QhY8Qh8f0OgduTgLXQkTW6qT-fE/edit?usp=drivesdk
86
스프레드시트4.3.2. 피벗테이블_필드추가4.3.2. 피벗테이블_필드추가https://docs.google.com/spreadsheets/d/1hHlHbjcnoirwyZSZ_z7vA3zCw3_2dqwtG062ghWYFVk/edit?usp=drivesdk
87
스프레드시트4.3.3. 피벗테이블_필터4.3.3. 피벗테이블_필터https://docs.google.com/spreadsheets/d/1WdBO0pbXBkGTYmrIGuG3MBiwFtCo0hV6vYHGjbf33Pw/edit?usp=drivesdk
88
스프레드시트4.3.3. 피벗테이블_슬라이서4.3.3. 피벗테이블_슬라이서https://docs.google.com/spreadsheets/d/1nr_4pj77Qw-WD7OQQLybgFzqLFBpkoS1_S6g5yEjlxE/edit?usp=drivesdk
89
스프레드시트4.3.4. 피벗테이블_요약기준4.3.4. 피벗테이블_요약기준https://docs.google.com/spreadsheets/d/1IOFGDPgUp0Eqik5vD5U32Eq6gVFyUdtEqk4P5CCFRII/edit?usp=drivesdk
90
스프레드시트4.3.5. 피벗테이블_그룹화4.3.5. 피벗테이블_그룹화https://docs.google.com/spreadsheets/d/12v1iP99yYsMtuT4_0fj0Bs4SnEhI9DF8OvZF0_OUZBc/edit?usp=drivesdk
91
스프레드시트4.4.1. 교차색상4.4.1. 교차색상https://docs.google.com/spreadsheets/d/1NZ-4G20-ba9jdAB3jTisadSS7GcHrLkhpGDYQ9dYRdU/edit?usp=drivesdk
92
스프레드시트4.4.2. 조건부서식4.4.2. 조건부서식https://docs.google.com/spreadsheets/d/1VjhTs0DVhpT7ljEcS3-q-1Ma3d0xe2G50mx8e2CECJ8/edit?usp=drivesdk
93
스프레드시트4.4.2. 조건부서식_맞춤수식4.4.2. 조건부서식_맞춤수식https://docs.google.com/spreadsheets/d/1en0eV75x4FZVKEoiXfCcXU4r5V2PzTuRDHaDyTvaxJo/edit?usp=drivesdk
94
스프레드시트4.4.2. 조건부서식_색상스케일4.4.2. 조건부서식_색상스케일https://docs.google.com/spreadsheets/d/13Xc81wenEToiOf1FhWIXJHGG2RH5Fnw7l6HqjAKzkqg/edit?usp=drivesdk
95
스프레드시트4.5.1. 중복항목삭제/공백제거4.5.1. 중복항목삭제/공백제거https://docs.google.com/spreadsheets/d/1nJfLUFEEQash3tSPatUmeidIUtclwY_9Nxi8Fdl_Dyc/edit?usp=drivesdk
96
스프레드시트4.5.3. 텍스트를 열로 분할4.5.3. 텍스트를 열로 분할https://docs.google.com/spreadsheets/d/1xv2PqW9I037lLL3QDm6JxjnUuACU99tlBgiZREeEnRE/edit?usp=drivesdk
97
스프레드시트4.5.4. 데이터 확인4.5.4. 데이터 확인https://docs.google.com/spreadsheets/d/1fVkao4Cq6WF94r9nRcJOs9DA7dbYW7y_YCsjEKwj7h8/edit?usp=drivesdk
98
스프레드시트4.5.5. 스마트칩4.5.5. 스마트칩https://docs.google.com/spreadsheets/d/1HoYmrGfuwZpYrl0l2o6vmfjJmhYaXMxhYnwCy1lVUhY/edit?usp=drivesdk
99
문서삼성전자 분석_2026-10-06삼성전자 분석_2026-10-06https://docs.google.com/document/d/1enGRNgCE8hSn482r1CxVFOS9LhtjTiN6pg9CCI9Fo7M/edit?usp=drivesdk
100
스프레드시트5.1.2. 텍스트를 열로 분할(SPLIT함수)5.1.2. 텍스트를 열로 분할(SPLIT함수)https://docs.google.com/spreadsheets/d/1ZReGcrG477UzMtvZMGbiY669uidagkNQoat6R8A-4qM/edit?usp=drivesdk