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.

The strongest business assistant Google sheet development Lv.1 (laying the foundation)

The strongest business assistant Google sheet development Lv.1 (laying the foundation)