First Encounter with Google Workspace - Sheets (Spreadsheet)

This course is a practical-focused program that covers the comprehensive utilization of **Google Sheets, the most widely used spreadsheet program in the world**. Starting with basic functions such as fundamental input, formatting, and cell management that even first-time users can easily follow, the course progressively advances to professional features including advanced function utilization, data analysis and visualization, conditional formatting, and pivot tables through step-by-step learning. Additionally, by focusing intensively on Google Sheets' unique strengths of real-time collaboration tools and cloud-based sharing features, learners can experience an efficient work environment where multiple people can simultaneously create, edit, and review documents. Through this course, learners can go beyond simple spreadsheet usage to simultaneously strengthen their data-driven decision-making abilities and collaboration capabilities, significantly improving work productivity.

(4.9) 10 reviews

3,947 learners

Level Beginner

Course period 12 months

Google Sheets
Google Sheets
Google Sheets
Google Sheets

Reviews from Early Learners

4.9

5.0

good123123

100% enrolled

I was only able to use VLOOKUP before, but it was great to learn various shortcuts and functions that I can apply in practical work.

5.0

๋ณดํ‚ค

31% enrolled

I'm enjoying watching this ๐Ÿ˜Š๐Ÿ˜Š

5.0

bigho98

100% enrolled

The detailed explanations and demonstrations of each function and ribbon menu item made it easy to understand. As a result, it became fun to work with data according to my intentions as I practiced.

What you will gain after the course

  • You can learn the basic usage of Google Sheets and efficiently perform data management and analysis.

  • You can smoothly proceed with team projects by utilizing file sharing and collaboration features.

  • You can process complex data using various functions and formulas, and visually represent data through pivot tables and charts.

์ฒ˜์Œ ๋งŒ๋‚˜๋Š” Google Workspace - Sheets(์Šคํ”„๋ ˆ๋“œ์‹œํŠธ) ๊ธฐ๋ณธ๊ณผ ํ™œ์šฉ


์ด ๊ณผ์ •์€ ์ „ ์„ธ๊ณ„์—์„œ ๊ฐ€์žฅ ๋„๋ฆฌ ์‚ฌ์šฉ๋˜๋Š” ์Šคํ”„๋ ˆ๋“œ์‹œํŠธ ํ”„๋กœ๊ทธ๋žจ์ธ Google Sheets(๊ตฌ๊ธ€ ์‹œํŠธ)์˜ ์ „๋ฐ˜์ ์ธ ํ™œ์šฉ๋ฒ•์„ ๋‹ค๋ฃจ๋Š” ์‹ค๋ฌด ์ค‘์‹ฌ ๊ฐ•์ขŒ์ž…๋‹ˆ๋‹ค.

์ฒ˜์Œ ์‚ฌ์šฉํ•˜๋Š” ํ•™์Šต์ž๋„ ์‰ฝ๊ฒŒ ๋”ฐ๋ผ์˜ฌ ์ˆ˜ ์žˆ๋„๋ก ๊ธฐ๋ณธ ์ž…๋ ฅ๊ณผ ์„œ์‹ ์ง€์ •, ์…€ ๊ด€๋ฆฌ์™€ ๊ฐ™์€ ๊ธฐ์ดˆ ๊ธฐ๋Šฅ๋ถ€ํ„ฐ ์‹œ์ž‘ํ•˜์—ฌ, ์ ์ฐจ ๊ณ ๊ธ‰ ํ•จ์ˆ˜ ํ™œ์šฉ, ๋ฐ์ดํ„ฐ ๋ถ„์„ ๋ฐ ์‹œ๊ฐํ™”, ์กฐ๊ฑด๋ถ€ ์„œ์‹, ํ”ผ๋ฒ— ํ…Œ์ด๋ธ” ๋“ฑ ์ „๋ฌธ์ ์ธ ๊ธฐ๋Šฅ๊นŒ์ง€ ๋‹จ๊ณ„์ ์œผ๋กœ ํ•™์Šตํ•ฉ๋‹ˆ๋‹ค.

๋˜ํ•œ Google Sheets๋งŒ์˜ ๊ฐ•์ ์ธ ์‹ค์‹œ๊ฐ„ ํ˜‘์—… ๋„๊ตฌ์™€ ํด๋ผ์šฐ๋“œ ๊ธฐ๋ฐ˜ ๊ณต์œ  ๊ธฐ๋Šฅ์„ ์ค‘์ ์ ์œผ๋กœ ๋‹ค๋ฃจ์–ด, ์—ฌ๋Ÿฌ ์‚ฌ๋žŒ์ด ๋™์‹œ์— ๋ฌธ์„œ๋ฅผ ์ž‘์„ฑยท์ˆ˜์ •ยท๊ฒ€ํ† ํ•  ์ˆ˜ ์žˆ๋Š” ํšจ์œจ์ ์ธ ์—…๋ฌด ํ™˜๊ฒฝ์„ ๊ฒฝํ—˜ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

๋ณธ ๊ณผ์ •์„ ํ†ตํ•ด ํ•™์Šต์ž๋Š” ๋‹จ์ˆœํ•œ ์Šคํ”„๋ ˆ๋“œ์‹œํŠธ ์‚ฌ์šฉ์„ ๋„˜์–ด, ๋ฐ์ดํ„ฐ ๊ธฐ๋ฐ˜ ์˜์‚ฌ๊ฒฐ์ • ๋Šฅ๋ ฅ๊ณผ ํ˜‘์—… ์—ญ๋Ÿ‰์„ ๋™์‹œ์— ๊ฐ•ํ™”ํ•˜์—ฌ ์—…๋ฌด ์ƒ์‚ฐ์„ฑ์„ ํฌ๊ฒŒ ํ–ฅ์ƒ์‹œํ‚ฌ ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

์ด๋Ÿฐ ๋‚ด์šฉ์„ ๋ฐฐ์›Œ์š”

๐Ÿ”น ์„น์…˜ 1 : Part.1 ๊ธฐ๋ณธ ์กฐ์ž‘, ์—ฐ์‚ฐ์ž, ์‹œํŠธ

์ฒซ ์„น์…˜์€ Google Sheets๋ฅผ ์ฒ˜์Œ ์ ‘ํ•˜๋Š” ํ•™์Šต์ž๋ฅผ ์œ„ํ•ด ๊ธฐ์ดˆ ์กฐ์ž‘๋ฒ•์„ ๋‹ค๋ฃจ๋Š” ๋‹จ๊ณ„์ž…๋‹ˆ๋‹ค.

  • ์‹œํŠธ ํ™”๋ฉด ๊ตฌ์„ฑ๊ณผ ๊ธฐ๋ณธ ์กฐ์ž‘๋ฒ•์„ ํ•™์Šตํ•˜์—ฌ ์…€, ํ–‰ยท์—ด, ์‹œํŠธ ๊ด€๋ฆฌ ๋“ฑ ๊ฐ€์žฅ ๊ธฐ๋ณธ์ ์ธ ์‚ฌ์šฉ๋ฒ•์„ ์ตํž™๋‹ˆ๋‹ค.

  • ๋ฐ์ดํ„ฐ ์ž…๋ ฅ๊ณผ ๊ด€๋ฆฌ ๋ฐฉ๋ฒ•์„ ํ†ตํ•ด ๋‹ค์–‘ํ•œ ํ˜•์‹(์ˆซ์ž, ๋ฌธ์ž, ๋‚ ์งœ ๋“ฑ)์„ ํšจ์œจ์ ์œผ๋กœ ๋‹ค๋ฃจ๋Š” ๋ฒ•์„ ๋ฐฐ์›๋‹ˆ๋‹ค.

  • ์—ฐ์‚ฐ์ž์˜ ์ข…๋ฅ˜์™€ ํ™œ์šฉ๋ฒ•์„ ์ดํ•ดํ•˜์—ฌ ๊ธฐ๋ณธ์ ์ธ ๊ณ„์‚ฐ์‹์„ ์ž‘์„ฑํ•  ์ˆ˜ ์žˆ์œผ๋ฉฐ,

  • ์‹œํŠธ ํ™œ์šฉ ํŒŒํŠธ๋ฅผ ํ†ตํ•ด ๋‹จ์ˆœ ๋ฌธ์„œ ์ž‘์„ฑ์—์„œ ๋ฒ—์–ด๋‚˜ ์‹ค์ œ ์—…๋ฌด์šฉ ์Šคํ”„๋ ˆ๋“œ์‹œํŠธ๋ฅผ ๋งŒ๋“ค๊ณ  ๋‹ค๋ฃฐ ์ˆ˜ ์žˆ๋Š” ์‹ค์Šต์„ ์ง„ํ–‰ํ•ฉ๋‹ˆ๋‹ค.


๐Ÿ”น ์„น์…˜ 2 : Part.2 ํ•จ์ˆ˜ ๋ฐ ๊ณ ๊ธ‰ ํ•จ์ˆ˜

๋‘ ๋ฒˆ์งธ ์„น์…˜์€ Google Sheets์˜ ํ•ต์‹ฌ์ธ ํ•จ์ˆ˜ ํ™œ์šฉ ๋Šฅ๋ ฅ์„ ์ง‘์ค‘์ ์œผ๋กœ ํ›ˆ๋ จํ•ฉ๋‹ˆ๋‹ค.

  • ๊ธฐ๋ณธ ํ•จ์ˆ˜ ์‚ฌ์šฉ๋ฒ•์„ ์—ฌ๋Ÿฌ ์ฐจ์‹œ์— ๊ฑธ์ณ ํ•™์Šตํ•˜์—ฌ SUM, AVERAGE, COUNT ๋“ฑ ๊ธฐ์ดˆ์ ์ธ ํ•จ์ˆ˜๋ถ€ํ„ฐ ์ตํž™๋‹ˆ๋‹ค.

  • ์ ์ฐจ ๋‚œ์ด๋„๋ฅผ ์˜ฌ๋ ค IF, VLOOKUP, HLOOKUP, INDEX, MATCH ๊ฐ™์€ ์—…๋ฌด ํ•„์ˆ˜ ํ•จ์ˆ˜๋ฅผ ๋‹ค๋ฃน๋‹ˆ๋‹ค.

  • ์ด์–ด์„œ QUERY, ARRAYFORMULA, IMPORTRANGE ๋“ฑ ๊ณ ๊ธ‰ ํ•จ์ˆ˜๋ฅผ ํ•™์Šตํ•˜์—ฌ ๋ณต์žกํ•œ ๋ฐ์ดํ„ฐ ๋ถ„์„๊ณผ ๋Œ€๋Ÿ‰์˜ ๋ฐ์ดํ„ฐ ๊ด€๋ฆฌ๋„ ํšจ์œจ์ ์œผ๋กœ ์ฒ˜๋ฆฌํ•  ์ˆ˜ ์žˆ๋Š” ๋ฐฉ๋ฒ•์„ ์Šต๋“ํ•ฉ๋‹ˆ๋‹ค.

๐Ÿ”น ์„น์…˜ 3 : Part.3 ์—…๋ฌด์— ์‚ฌ์šฉํ•˜๋Š” ํ•จ์ˆ˜, ์ˆ˜์‹ ํ™œ์šฉ

์„ธ ๋ฒˆ์งธ ์„น์…˜์€ ์‹ค์ œ ์—…๋ฌด ํ˜„์žฅ์—์„œ ์ž์ฃผ ์“ฐ์ด๋Š” ํ•จ์ˆ˜์™€ ์ˆ˜์‹ ํ™œ์šฉ๋ฒ•์„ ์ค‘์‹ฌ์œผ๋กœ ๊ตฌ์„ฑ๋ฉ๋‹ˆ๋‹ค.

  • ํ…์ŠคํŠธ ์ฒ˜๋ฆฌ ํ•จ์ˆ˜(LEFT, RIGHT, MID, CONCATENATE ๋“ฑ)๋ฅผ ํ™œ์šฉํ•ด ๋ฌธ์ž์—ด ๋ฐ์ดํ„ฐ๋ฅผ ๋‹ค๋ฃจ๋Š” ๋ฐฉ๋ฒ•,

  • ๋‚ ์งœ ๋ฐ ์‹œ๊ฐ„ ๊ด€๋ จ ํ•จ์ˆ˜(TODAY, NOW, DATEDIF ๋“ฑ)๋ฅผ ํ†ตํ•ด ์ผ์ • ๊ด€๋ฆฌ ๋ฐ ๋ณด๊ณ ์„œ ์ž‘์„ฑ์— ์‘์šฉํ•˜๋Š” ๋ฐฉ๋ฒ•,

  • ์กฐ๊ฑด๋ถ€ ์ˆ˜์‹๊ณผ ์ค‘์ฒฉ ํ•จ์ˆ˜ ์ž‘์„ฑ๋ฒ•์„ ์‹ค์Šตํ•˜์—ฌ ๋ณต์žกํ•œ ์—…๋ฌด ์š”๊ตฌ์‚ฌํ•ญ๋„ ํ•ด๊ฒฐํ•  ์ˆ˜ ์žˆ๋„๋ก ํ•ฉ๋‹ˆ๋‹ค.

  • ๋‹จ๊ณ„๋ณ„๋กœ 5์ฐจ์‹œ์— ๊ฑธ์ณ ํ’๋ถ€ํ•œ ์˜ˆ์ œ์™€ ์‹ค์Šต ๋ฌธ์ œ๋ฅผ ํ’€๋ฉฐ, ์ด๋ก ๊ณผ ์‹ค๋ฌด ์ ์šฉ์„ ๋™์‹œ์— ์—ฐ์Šตํ•ฉ๋‹ˆ๋‹ค.

๐Ÿ”น ์„น์…˜ 4 : Part.4 ๋ฐ์ดํ„ฐ ํ™œ์šฉ๊ณผ ๊ด€๋ฆฌ, ๋ฐ์ดํ„ฐ ๋ถ„์„ ๋“ฑ

๋งˆ์ง€๋ง‰ ์„น์…˜์€ Google Sheets์˜ ์‹ค๋ฌด ์‘์šฉ ๋ฐ ํ˜‘์—… ๊ธฐ๋Šฅ์„ ๋‹ค๋ฃจ๋Š” ๊ณผ์ •์ž…๋‹ˆ๋‹ค.

  • ๋ฐ์ดํ„ฐ ํ™œ์šฉ๊ณผ ๊ด€๋ฆฌ ํŒŒํŠธ์—์„œ๋Š” ๋ฐ์ดํ„ฐ ์ •๋ ฌ, ํ•„ํ„ฐ, ์กฐ๊ฑด๋ถ€ ์„œ์‹ ๋“ฑ ๋ฐ์ดํ„ฐ๋ฅผ ๊น”๋”ํ•˜๊ฒŒ ์ •๋ฆฌํ•˜๊ณ  ๋ถ„์„ํ•˜๊ธฐ ์œ„ํ•œ ํ•ต์‹ฌ ๊ธฐ๋Šฅ์„ ํ•™์Šตํ•ฉ๋‹ˆ๋‹ค.

  • ํŒŒ์ผ ๊ณต์œ  ๋ฐ ๊ด€๋ฆฌ์—์„œ๋Š” Google Sheets๋งŒ์˜ ์žฅ์ ์ธ ์‹ค์‹œ๊ฐ„ ํ˜‘์—… ๊ธฐ๋Šฅ๊ณผ ๊ถŒํ•œ ์„ค์ • ๋ฐฉ๋ฒ•์„ ์ตํ˜€, ์—ฌ๋Ÿฌ ๋ช…์ด ๋™์‹œ์— ๋ฌธ์„œ๋ฅผ ์ˆ˜์ •ยท๊ฒ€ํ† ํ•  ์ˆ˜ ์žˆ๋Š” ๋ฐฉ๋ฒ•์„ ์‹ค์Šตํ•ฉ๋‹ˆ๋‹ค.

  • ๋ฐ์ดํ„ฐ ๋ถ„์„ ํŒŒํŠธ์—์„œ๋Š” ํ”ผ๋ฒ— ํ…Œ์ด๋ธ”, ์ฐจํŠธ ์ž‘์„ฑ, ๋ฐ์ดํ„ฐ ์‹œ๊ฐํ™” ๊ธฐ๋ฒ• ๋“ฑ์„ ๋‹ค๋ฃจ์–ด ๋‹จ์ˆœ ๋ฐ์ดํ„ฐ๊ฐ€ ์•„๋‹Œ โ€œ์˜๋ฏธ ์žˆ๋Š” ์ธ์‚ฌ์ดํŠธโ€๋ฅผ ์–ป๋Š” ๋ฐฉ๋ฒ•์„ ํ•™์Šตํ•ฉ๋‹ˆ๋‹ค.

  • ๋งˆ์ง€๋ง‰์œผ๋กœ ํŽธ๋ฆฌํ•œ ํ•จ์ˆ˜ ํ™œ์šฉ ํŒŒํŠธ์—์„œ ์—…๋ฌด ํšจ์œจ์„ ๋†’์—ฌ์ฃผ๋Š” ํŒ๊ณผ ๋‹จ์ถ• ํ™œ์šฉ๋ฒ•์„ ์ •๋ฆฌํ•˜๋ฉฐ ํ•™์Šต์„ ๋งˆ๋ฌด๋ฆฌํ•ฉ๋‹ˆ๋‹ค.


์ˆ˜๊ฐ• ์ „ ์ฐธ๊ณ  ์‚ฌํ•ญ

์ด ๊ฐ•์˜๋Š” ์ง€์‹๊ณต์œ ์ž์˜ ์งˆ๋ฌธ/๋‹ต๋ณ€์„ ์ œ๊ณตํ•˜์ง€ ์•Š์Šต๋‹ˆ๋‹ค

ํ•™์Šต ์ž๋ฃŒ

์ฃผ์ฐจ๋ณ„ ๊ต์•ˆ์ด pdfํŒŒ์ผ๋กœ ์ œ๊ณต๋ฉ๋‹ˆ๋‹ค

Recommended for
these people

Who is this course right for?

  • From beginners who are using spreadsheets for the first time to users who want to learn advanced features

  • Working professionals and students responsible for data analysis and management tasks

  • Everyone who wants to improve work efficiency through Google Sheets

Hello
This is usefulit

8,278,555

Learners

6,507

Reviews

4.6

Rating

308

Courses

I will help you grow through useful IT lectures.

Curriculum

All

26 lectures โˆ™ (12hr 9min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

10 reviews

4.9

10 reviews

  • bigho982715๋‹˜์˜ ํ”„๋กœํ•„ ์ด๋ฏธ์ง€
    bigho982715

    Reviews 24

    โˆ™

    Average Rating 5.0

    5

    100% enrolled

    The detailed explanations and demonstrations of each function and ribbon menu item made it easy to understand. As a result, it became fun to work with data according to my intentions as I practiced.

    • boki๋‹˜์˜ ํ”„๋กœํ•„ ์ด๋ฏธ์ง€
      boki

      Reviews 60

      โˆ™

      Average Rating 5.0

      5

      31% enrolled

      I'm enjoying watching this ๐Ÿ˜Š๐Ÿ˜Š

      • good123123๋‹˜์˜ ํ”„๋กœํ•„ ์ด๋ฏธ์ง€
        good123123

        Reviews 1

        โˆ™

        Average Rating 5.0

        5

        100% enrolled

        I was only able to use VLOOKUP before, but it was great to learn various shortcuts and functions that I can apply in practical work.

        • calculator๋‹˜์˜ ํ”„๋กœํ•„ ์ด๋ฏธ์ง€
          calculator

          Reviews 198

          โˆ™

          Average Rating 4.9

          5

          19% enrolled

          • mhwan20101661๋‹˜์˜ ํ”„๋กœํ•„ ์ด๋ฏธ์ง€
            mhwan20101661

            Reviews 42

            โˆ™

            Average Rating 4.9

            5

            31% enrolled

            usefulit's other courses

            Check out other courses by the instructor!

            Similar courses

            Explore other courses in the same field!