강의

멘토링

로드맵

Inflearn brand logo image
Productivity

/

Office

How to Use Google Spreadsheets for Workers

Those who are already good at using Excel can work more effectively, efficiently, and in less time by using Google Spreadsheets.

(4.6) 7 reviews

70 learners

  • groschool
3시간 만에 완강할 수 있는 강의 ⏰
Google Sheets
Google Apps Script

Reviews from Early Learners

What you will learn!

  • Google Spreadsheets Basics and Core Skills

  • Google Spreadsheet Basic Application

Now, with Google Spreadsheets
Work smart and be more efficient!

Google Spreadsheet
What the heck? 🤔

Think of it as Excel made by Google ! 💁‍♀️
It's free to use and works on web browsers like Chrome, Whale, Safari, etc.
You can use it anytime, anywhere you have internet access.

The biggest difference from Excel is that it is web browser-based, so multiple people can work on it at the same time.
It is possible to import or export data from other files or the web.

In particular, it integrates well with other SaaS tools such as Slack and Zapier.
If you set it up well, you can create an environment where you can work comfortably .


Spreadsheet lecture,
Why was it created? 👨‍🏫

Introducing instructor Choi Ki-young, who created this course 🙂

Instructor Kiyoung Choi, who created this course, was originally an employee of a large corporation, having worked at companies such as S and H.
Large companies don't use external web browsers or cloud-based services due to security vulnerabilities. Back then, they diligently organized and documented documents and data using Excel and PPT.

But! I gave up half my annual salary at a large company and decided to change my fate by joining a startup!

Startups and small businesses often lack resources, right?
Including people, time, and the cost of using such services.

Although resources were limited, Kiyoung wanted to do his work effectively. From then on, he started learning and applying to his organization any tools that could help with productivity, such as Notion, Slack, and Monday.com.
I started working with spreadsheets instead of Excel, and it turned out to be much more accurate and faster than I expected.
We started seeing results that saved time and increased productivity.

So, I created this course to organize and convey the essential functions and steps during the process. 😊


Easier and more convenient than Excel
Google Spreadsheets! 📃

Those who are already proficient in Excel can work more efficiently, effectively, and save time by using Google Spreadsheets. (I've personally experienced this!)

Have you ever experienced this?

When you need to aggregate data by department...

  • One person organizes the forms and sends the files to each department via email, messenger, etc.
  • Enter data according to the form for each department,
  • The person in charge then receives the file filled with data for each department.
  • The person in charge merges these multiple files with different names into one and then sends them separately.

🚫 There is no way to know how many file versions will be created during this process.
🚫 There is also the issue of whether files exist on someone's hard drive or not.
🚫 In many cases, version control is not possible later.
This is what we can call inefficiency in work .

Instead of Excel in this case
What if we use a spreadsheet?

  • Create a form
  • Just pass a single line of URL containing the form.
  • You can work on different departments simultaneously.

✅ No need to compile separately,
✅ No need to save it under a different name,
✅ No need to send it to anyone via email or messenger
Work speed increases and accuracy improves, transforming the organization into one that excels at its work .


Who would benefit from listening? 🔍

Distribution of Excel forms without collation
With multiple people at once
Anyone who wants to collaborate

Bring in external data
Processing in real time
Anyone who wants to know how

Introducing new tools and
No hesitation in learning
Everyone

People like this, please think three more times before listening! 🙄

  • Those who do not know how to use basic Excel functions and basic functions (such as SUM)
  • Those who have never used cloud-based services or cannot use them for security reasons
  • People who find it difficult to use work tools or to introduce new tools

Please check the curriculum. 📚

This course provides video and hands-on materials.

  • Excel vs. Spreadsheet Comparison
  • Spreadsheet Basics: The Minimum Functions You Need to Know for Data Analysis
  • Things you can only do in spreadsheets: arrays, queries, Importrange
  • Data collection/processing process, examples of integration with other tools

Recommended for
these people

Who is this course right for?

  • For those who want to collaborate with multiple people at once without distributing or collating Excel forms.

  • For those who want to know how to bring in external data and process it in real time

  • Someone who is comfortable with adopting and learning new tools.

Need to know before starting?

  • Basic functions and basic functions of Excel

Hello
This is

13,189

Learners

235

Reviews

174

Answers

4.7

Rating

13

Courses

요즘 사람들의 성장 공식 그로스쿨.kr

Curriculum

All

15 lectures ∙ (2hr 49min)

Published: 
Last updated: 

Reviews

All

7 reviews

4.6

7 reviews

  • jihyun3219667님의 프로필 이미지
    jihyun3219667

    Reviews 1

    Average Rating 5.0

    5

    33% enrolled

    • farmerpopo님의 프로필 이미지
      farmerpopo

      Reviews 2

      Average Rating 5.0

      5

      33% enrolled

      • hec817738님의 프로필 이미지
        hec817738

        Reviews 2

        Average Rating 5.0

        5

        87% enrolled

        Basic concepts and data preprocessing practices ~ Work automation examples This is a lecture on how to use Google Spreadsheets differently from Excel!

        • kimjs1673님의 프로필 이미지
          kimjs1673

          Reviews 3

          Average Rating 5.0

          5

          33% enrolled

          • tgkim939603님의 프로필 이미지
            tgkim939603

            Reviews 1

            Average Rating 5.0

            5

            100% enrolled

            It's easy to understand because the key points are explained in detail.

            $34.10

            groschool's other courses

            Check out other courses by the instructor!