Rookie
4 chapters · 2 hours 37 minutes
English · Japanese · Korean|Audio Korean

Skills You’ll Learn

Spreadsheet basics guide

Let's start with a basic guide and introduce easy shortcuts and features that will improve efficiency

Understanding database types that are not difficult

Understand the database, which is the foundation of great work, and introduce ways to use it

Create a data dashboard through Query

Let me introduce a Query that outputs desired data easily, quickly, and without difficulty

About the class


Are you still having trouble using Google Sheets?

Are you just doing basic SUM and VLOOKUP without a goal?

Hello, I'm Benny, and I've collected only the best technology from my 5th year of experience in a startup.

Everyone uses data in their heads to create wonderful results.

Now not only experts can do it, but I will help you become an expert right away through this course. A spreadsheet is a basic DB (database) format, but I'll tell you the know-how I've gained from practice so that I can directly view only the data I want to see in the DB as interactive indicators.

It's definitely very easy to make, even for beginners who haven't used Google spreadsheets, and I'll teach you in detail from the basics by explaining them in easy to understand words rather than difficult words.

Course effects


  • You'll learn the basics of spreadsheets and learn about various functions and shortcuts.

  • It's not just a passive form of creating a spreadsheet, but you get active thinking that you can think about.

  • You will be able to maximize efficiency and print out the plans in your head in real life.

Recommended target


  • People who don't know much about spreadsheets but want to learn

  • Those who want to maximize the utility of OA through short lectures

  • Those who want to use spreadsheets useful in practice at work

Notes before taking the course


  • Currently undecided

3 reasons why this class is special

❶ Why is it a spreadsheet instead of Excel

Spreadsheets other than Excel are becoming a major core tool for the younger generation to process tasks quickly. According to research, there are still few users compared to Excel, but since the main target of use is the younger generation and startups, it is believed that the number of users of spreadsheets will increase even more over time.

Also, since spreadsheets can be used on the web, real-time collaboration and execution without separate software are possible, so it is a service that can be checked anytime, anywhere around the world. In addition, it can also be used in connection with various development tools, and since data can also be linked with visual design tools, it has more expandability than simply managing a single spreadsheet database.

We'll show you how to learn about spreadsheets with many advantages more easily and quickly.


<Insert 2 or more images or videos>

  • The images should focus on the results after creating the class.

  • If you would like to add a personal portfolio, please fill in the details below.

  • Example) Chapters 1-3. Portfolio creation example image

❷ Easy way to view complex databases (databases)

A normal DB (database) hurts our eyes because it is divided into so many separators.

However, there aren't many data tables that each stakeholder actually sees.

For example, a simple payment employee doesn't need to separate new customers from regular customers and look closely at them.

This class tells us how the DB is designed and how we can quickly identify the output data we want to create.


<Insert 2 or more images or videos>

  • The images should focus on the results after creating the class.

  • If you would like to add a personal portfolio, please fill in the details below.

  • Example) Chapters 1-3. Portfolio creation example image

❸ Easily and quickly create your own conditional data dashboard

I'm going to try to actually create a good idea that was only in my head.

Learn about functions that can output data more easily and quickly than previously known functions,

Let's create a data dashboard that changes according to various conditions. This is a feature that creates a great deal of efficiency even in actual practice and has infinite scalability that can be applied in all industries.

This class teaches you how to turn dreams into reality rather than using spreadsheets which are inefficient anymore.


<Insert 2 or more images or videos>

  • The images should focus on the results after creating the class.

  • If you would like to add a personal portfolio, please fill in the details below.

  • Example) Chapters 1-3. Portfolio creation example image

Curriculum

Creator

Benny

Benny

My name is Benny, who has 5 years of experience as a general secretary, and is in charge of management planning/strategy.

In order to personally learn about the rapid growth of startups, I learned about society by bumping into databases one by one. Personally, I had a strong desire for work, and I learned about spreadsheets because I had a strong desire to learn about useful things. There are parts that were awkward and sloppy, but currently I'm helping stakeholders make decisions with my spreadsheet ability to create data that must be viewed rather than data they want to see. Spreadsheets have a myriad of data separated into rows and columns. What kind of output these rows and columns produce is really limitless.


We hope that they will learn endless abilities together through spreadsheets and improve their own value by challenging themselves from practical work to outsourcing who can sell individual abilities. This class will broaden your perspective on the industry and sharpen your mind.


We wanted to reduce difficult words and theories that were difficult to understand as much as possible, and worked hard to prepare explanations and quick understanding based on practical experience.



View similar classes you might also like

Create an at-a-glance visualization dashboard as a spreadsheetOffice Productivity  |  Benny
SupportOffice hours: M-F 10:00-16:00 (KST)
CLASS 101, LLC.
1201 North Market St. Suite 111, Wilmington, DE, 19801
support@101.inc