Class introduction

• Smart store margin rate tracking system

• Purchase revenue inventory and code classification system

• transcoding system

• diary

• Hospital medical records and management system

• Matching record profile form generation system

• Production planning and work log system

• Text and invoice generation system

• Integrated revenue management and delivery tracking system

• Consignment Seller Supply System

• Member attendance management system

• Free travel agency customer information management system

• Data crawling and chart dashboard system

• Cafehouse Alba Salary Calculator System

• Attorney Appointment Deposit Date Reminder System

• Naver transaction history chart dashboard system

• Product ordering system

• Gift certificate transaction recording system

• Assessment Form and Financial Statement Briefing System

• Music equipment rental management DB system

• Automatic quotation preparation system

• Mobile phone sales customer database management system

• Schedule management system for each operator

If you can do something like this with Google Sheets, why did you come to me now?

_{- System production client day stressed by not being able to quickly identify inventory -}

Sheet B, which received requests to create 50 types of systems in a short period of time and implemented it as a “Google Sheet,” is the major of “design.”

_{- You can do it even if you are not a related major -}

Hello, I'm Sheet B, a Google sheet creator.

This class was given to people who needed a customized system Know-how gained by completing homeworkIt contains

• I work at a place that throws in a data table with 34 columns and 12632 rows, and I quickly process this data and put it away in front of my eyes, Office workers who want to watch at least one more YouTube video minutes

• The pub next door Self-employed person who writes Google spreadsheets and wants to know what that means

• To the computer “Do some work”The person who wants to say

• With data Useless math calculationsPeople who like to do

Take all of my know-how.

The magic of Google Sheets to shorten time after work

• Classifying data mixed with this and that

• Drag to fill in the function

• Find and check with your own eyes to see if the price is wrong

You can leave work, right?

Let's learn techniques to get away from the manager's eyes quickly and legally in this class.

Not a function that must be used multiple times, but an array function that is only used once

Don't use functions over and over

Functions used in practice according to the situation assemblingDo it,

array functionUpgrade to Gum Freet

And you only need to use it once.

Coding with Google Sheets?! Create complex systems just by writing the code you need

Google Sheets isn't all about functions.

Do you want to make something that can only be made with functions from what you've learned in a place that only tells you about functions?

I made it because there is no place that even tells me the script code while telling me Google Sheets.

Necessary when you want Google Sheets to do more complicated work “Apps Script”

To use this, I need to know a weird language called Javascript, but I don't like learning all of it either.

We are on Google Sheets Let's just learn how to write useful code. (Of course, the more you know, the better)

It doesn't just process one-dimensional data with only functions, but even tells you the scripts you need

Let's learn in this class to process and use data at a higher level.

Even Google sheet design tips that are clean and good-looking

Good-looking mochi is also nice to eat.

Making this king should make our precious eyes look good so they don't have a hard time.

Get design tips here, too.

Course effect

Recommended target

• People who work on Nogada functions by creating a new sheet every time because they need to process the data provided every year or every day of the month according to a specific standard, but they can't do it even if they want to instruct the sheet to process the data according to that standard

• Those who want to know how to assemble functions

• Those who are wondering what kind of work can be done with Google Sheets

• Those who know what kind of work they can do, but can't get a sense of it even if they try to make it themselves

• How much better would taking a class like this make me work? Those who think

• People who work with data and want to work hard

Notes before taking the course

A Google account is required.

What is Google Sheets

• It works on MAC

• It works on Windows

• It only works slightly on Android.

3 reasons this class is special

❶ Lectures that are easy to understand with graphics

It's not fun to keep showing the actual screen as it is.

The graphic objects in the class make it easy to understand the basic concept of making Google Sheets work.

❷ Functions that only use one column: array function class

Did you put a function in every column because you needed to get the calculated value for each row or column?

Did you drag every time because you had to use the autocomplete feature?

I'll tell you about an “array function” that writes a function in only one cell and automatically calculates a value in the desired range.

❸ Google Sheet Legends Accessory: Apps Script Class

There are more things you can do by attaching an app script to Google Sheets.

To use this, I need to learn an alien word called JavaScript, but I don't need to know everything

We will compress and tell you only what you need for the Google Sheets custom script.