강의

멘토링

로드맵

Productivity

/

Task Automation

Learning Work Automation with Google Spreadsheets (Coding for Office Workers)

Is it possible to automate tasks easily with one line of code? Learn how to automate tasks with Google Spreadsheets

(4.2) 13 reviews

249 learners

  • Master Norangi
Google Sheets
Regex

Reviews from Early Learners

What you will learn!

  • Understanding Arrays, the Core of Google Spreadsheets

  • JavaScript AppScript Basic Functions and How to Apply Google Sheets

  • How to extract data using SQL query functions

  • How to extract data in various ways using regular expressions

Please check before attending the lecture!

  • This course can be taken with just a Google account. Please create a Google account before attending!
  • Unauthorized distribution or public posting of class content and materials is prohibited.

Is this my story..?

Automation. You know you need it, but you're not sure where to start.


Automating Your Work: Two Reasons to Choose Google Sheets

Automation of tasks that make tedious and time-consuming tasks more efficient.
There are many tools available to help automate tasks,
Realistically, the easiest task automation tool for office workers to learn is Google Spreadsheets .


The most familiar tool for office workers!

Everyone has probably used Excel or Google Spreadsheets at least once in their lives. They've probably even handled data directly. It's no surprise that they're among the most popular tools used by office workers.


Easier and more convenient than professional data analysis tools!

While you can automate tasks using Python, Node.js, R, and other tools, the barrier to entry is high. On the other hand, Google Spreadsheets offers the convenience of automation with just a few lines of code.


What you will look like after taking this course

Killing two birds with one stone: automation and coding 😆

  • Import RAW data into Google Sheets to customize and categorize it .
  • You can collect and process various data through functions and coding formulas.
  • You can learn the basics of JavaScript and gain the fundamental muscles needed to code .

What you'll learn in this course 💻

  • Understanding Arrays
    • Learn how to use arrays in Google Sheets to modify and leverage your source data.

      Here is an actual lecture example.

  • Understanding AppScript
    • Learn basic functions using JavaScript coding and how to apply them to Google Sheets.

      Here is an actual lecture example.

  • Understanding query functions (SQL)
    • Learn how to extract data using various conditions and methods using Google Sheets data.

      Here is an actual lecture example.

  • Understanding Regular Expressions
    • Learn how to extract data in a variety of ways using formulas.

      Here is an actual lecture example.

Lecture Features 😊

A lecture for beginners, by beginners, and of beginners!

We provide high-quality lectures and abundant teaching materials so that even beginners can understand coding quickly and easily.

We've gathered only the key features that Excel doesn't offer!

This includes an introduction to functions and examples of their use, allowing you to take full advantage of Google Spreadsheets' unique strengths.

Additional lectures will be continuously updated!

To help students apply the course material in their practical work, we will continue to update the course free of charge.
* Please note that you can receive benefits when taking additional lectures.


Automation and coding are not far away.

I come across an advertisement promising to automate unnecessary tasks through task automation. Feeling that this changing world can't continue like this, I start taking coding classes. However, the coding formulas written on the black screen feel distant. I give up on coding again.

Could this be your past self? Google Spreadsheets is a tool that can instantly solve your fear of coding and your lack of willpower. It requires no installation or configuration, and you can complete all your tasks with just a few lines of code. I hope every ordinary office worker takes my course. I hope they learn through my lectures that coding isn't difficult and isn't far away.

Recommended for
these people

Who is this course right for?

  • Anyone who wants to automate work through Google Spreadsheet coding

  • For working people who want to get started with coding

  • Anyone who has studied professional data analysis tools but given up

  • Anyone who wants to learn how to extract, modify, and classify RAW data

Need to know before starting?

  • It would be helpful if you have some knowledge of Excel features or basic functions within Excel.

  • A basic understanding of Google Spreadsheets is helpful.

Hello
This is

프로그램밍 언어는 개발자의 것이 아닙니다. 일반 직장인도 실무에 코딩을 적용할 수 있습니다.  

Curriculum

All

30 lectures ∙ (7hr 54min)

Published: 
Last updated: 

Reviews

All

13 reviews

4.2

13 reviews

  • ryun47459237님의 프로필 이미지
    ryun47459237

    Reviews 1

    Average Rating 5.0

    5

    100% enrolled

    It really helps a lot~!!

    • jjihyeok1252님의 프로필 이미지
      jjihyeok1252

      Reviews 3

      Average Rating 4.7

      5

      100% enrolled

      Even just the first few lectures, such as arrays and queries, were worth the tuition fee. I enjoyed it!

      • mirrorlaw0346님의 프로필 이미지
        mirrorlaw0346

        Reviews 49

        Average Rating 4.9

        5

        100% enrolled

        I like that I can learn a lot of features

        • leesj8585님의 프로필 이미지
          leesj8585

          Reviews 1

          Average Rating 5.0

          5

          80% enrolled

          thank you

          • jhyoon762791님의 프로필 이미지
            jhyoon762791

            Reviews 1

            Average Rating 5.0

            5

            33% enrolled

            Thank you for the good content.

            Access is restricted to non-public courses.
            Private Course

            Similar courses

            Explore other courses in the same field!