강의

멘토링

로드맵

BEST
Productivity

/

Office

Learn the basics of Google Sheets with a cup of Americano

This is not a complete list of Google Spreadsheets, but rather a collection of only the things I use to preprocess data in my field.

(4.8) 78 reviews

638 learners

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

Reviews from Early Learners

What you will learn!

  • How to use Google Spreadsheets Basics

  • Data preprocessing using Google Sheets

Processing Data with Google Spreadsheets : A Guide from a Professional 👨‍💻


As a data analyst at a platform company, one of the most essential tasks is data extraction . This means processing information stored in databases and providing it to those who need it. Programming languages like SQL and Python are commonly used for this, but Google Sheets allows for more efficient data processing. However, spreadsheets offer so many features that it can be overwhelming to know which ones to learn. Therefore, in this lecture, I've introduced the key features and functions I use in my field for data processing .


Lecture Features📑

✅ Rather than focusing on theory, we have created a system that focuses on possible examples to help you think about the relevant situations.

We provide practice files so that you can practice along with the lectures, not just watch them.

This course is verified as it is based on spreadsheet training conducted in-house .


Q&A 🙋‍♀️

Q. How is this different from previous lectures?
A. I created this book by selecting only the grammar and functions I use in my field. Therefore, rather than covering everything about spreadsheets, I focused on only the essentials.

Q. What is not covered in this course?
A. This lecture focuses on preprocessing raw data, so it does not cover creating charts or dashboards.

Q. Do you have any plans for additional lectures on spreadsheets?
A. I am thinking about charts/dashboards and automation, which are not covered in this course.

Recommended for
these people

Who is this course right for?

  • For those who are new to Google Sheets (Excel)

  • Those who received data from data analysts but had difficulty preprocessing

  • People who have computer skills but cannot use Google Sheets (Excel)

Hello
This is

9,770

Learners

434

Reviews

15

Answers

4.8

Rating

8

Courses

- 현) KREAM 데이터 분석가

- 전) ABLY 데이터 분석가

- 전) wadiz 데이터 분석가

- 전) XIILab 인공지능개발팀 선임연구원

- 전) 아라종합기술 수치모델링1팀 사원

- 인하대학교 해양과학과 (학/석)

Curriculum

All

18 lectures ∙ (52min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

78 reviews

4.8

78 reviews

  • sound21671332님의 프로필 이미지
    sound21671332

    Reviews 3

    Average Rating 5.0

    5

    100% enrolled

    基本技講義だけど必要で聞いてみました。簡単に教えてくれて楽しく聞きました。

    • pbj0812
      Instructor

      聞いてくれてありがとう!

  • trantper님의 프로필 이미지
    trantper

    Reviews 13

    Average Rating 5.0

    5

    100% enrolled

    Excelはよく知りませんでしたが、簡単で軽量で便利です。

    • pbj0812
      Instructor

      助けてくれてありがとう!

  • gigase21242님의 프로필 이미지
    gigase21242

    Reviews 1

    Average Rating 5.0

    5

    100% enrolled

    簡単に多くの時間を節約できるようになりました!ありがとうございます!

    • pbj0812
      Instructor

      聞いてくれてありがとう!!!! 講義を作るときに反応がどうかと思ったのですが、節約されたのは幸いですㅠㅠ

  • analist869255님의 프로필 이미지
    analist869255

    Reviews 1

    Average Rating 5.0

    5

    100% enrolled

    1時間でGoogleスプレッドシートマスターですね。 本当に簡潔に、ちょうど必要なものばかりなく終わり! 次のバージョンはありませんか?

    • pbj0812
      Instructor

      みんなありがとう! 現在...その内容と他のものを追加して本を書く予定です。 以後、アップデット部分を講義にするか考えています。 私は怠けて遅れています... この受講評でまた心をつかむようにします!

  • znznekfl1397님의 프로필 이미지
    znznekfl1397

    Reviews 1

    Average Rating 5.0

    5

    100% enrolled

    恥ずかしいですが、スプレッドシートは就職後に初めて書くツールなので少しずつ混乱していましたが、この講義を通じて基礎概念が取れて本当に多くのお役に立ちました!

    • pbj0812
      Instructor

      ありがとうございます!知らないと恥ずかしくなる必要はありません!

$4.40

pbj0812's other courses

Check out other courses by the instructor!