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 Reasonsto 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 categorizeit .
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
프로그램밍 언어는 개발자의 것이 아닙니다. 일반 직장인도 실무에 코딩을 적용할 수 있습니다.