강의

N
챌린지

멘토링

N
클립

커뮤니티

BEST
Productivity

/

Office

アメリカングラスで聴くGoogleシートの基礎

Googleスプレッドシートのすべてを含むものではなく、 私は現業でデータを前処理するときに書くものだけを集めました。

（4.8）受講レビュー 79件

受講生 640名

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

学習した受講者のレビュー

こんなことが学べます

  • Googleスプレッドシートの基礎使用法

  • Googleシートを使用したデータの前処理

現業者が知らせるGoogleスプレッドシートでデータを処理する👨‍💻


プラットフォーム会社のデータアナリストとして働いている間に解放できない仕事の1つは、データ抽出です。つまり、データが必要な人にデータベースに蓄積された情報を加工してあげることです。このとき使用するプログラミング言語にはSQL、PYTHON(Python)などがありますが、Googleスプレッドシート(Google Sheets)を利用すればより効率的にデータを加工することができます。しかし、スプレッドシートで提供される機能はあまりにも多く、どんなことを勉強しなければならないのか感がよく取れないのも事実です。したがって、このレッスンでは、私がビジネスでデータを処理する際に使用する主な機能と機能を紹介しました。

講義の特徴📑

✅理論ではなく、ありそうな例を中心として、その状況に必要な考えをするようにしました。

✅実習ファイルを提供して講義を聞いて見るだけではなく、したがって実習できるようにしました。

✅社内で行われたスプレッドシート教育を基に作ったので検証を受けた講義です。

Q&A 🙋‍♀️

Q. 既存の講義との違いは何ですか？
 A. 私が現業で書く文法と機能だけを選んで制作をしました。そのため、スプレッドシートに関するすべての内容を入れるのではなく、必ず必要なものだけを入れるよう努めました。

Q. この講義で提供しない部分は何ですか？
A. このレッスンでは、ローデータの前処理を中心としたため、チャートやダッシュボードの作成に関する内容は含まれていません。

Q. スプレッドシートに関する追加講義の計画はありますか？
A. 本講義で提供していないチャート/ダッシュボードや自動化に関する部分を考えています。

こんな方に
おすすめです

学習対象は
誰でしょう？

  • Googleシート（Excel）を初めてお使いの方

  • データアナリストからデータを受け取りましたが、前処理が難しい人

  • カム活資格はありますが、Googleシート（Excel）を扱えない方

こんにちは
です。

9,786

受講生

437

受講レビュー

15

回答

4.8

講座評価

8

講座

- 현) KREAM 데이터 분석가

- 전) ABLY 데이터 분석가

- 전) wadiz 데이터 분석가

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

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

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

カリキュラム

全体

18件 ∙ (52分)

講座資料（こうぎしりょう）:

授業資料
講座掲載日: 
最終更新日: 

受講レビュー

全体

79件

4.8

79件の受講レビュー

  • sound21671332님의 프로필 이미지
    sound21671332

    受講レビュー 3

    ∙

    平均評価 5.0

    5

    100% 受講後に作成

    It was a basic course, but I needed it so I took it. It was fun because it was explained in an easy-to-understand way.

    • pbj0812
      知識共有者

      Thank you for listening!!!

  • trantper님의 프로필 이미지
    trantper

    受講レビュー 13

    ∙

    平均評価 5.0

    5

    100% 受講後に作成

    I didn't know much about Excel, but it was easy, light, and useful.

    • pbj0812
      知識共有者

      Thank you for your help!!

  • gigase21242님의 프로필 이미지
    gigase21242

    受講レビュー 1

    ∙

    平均評価 5.0

    5

    100% 受講後に作成

    This just saved me a lot of time! Thank you!

    • pbj0812
      知識共有者

      Thank you for listening!!!! I was wondering what the reaction would be like when I made the lecture, but I'm glad you saved money ㅠㅠ

  • analist869255님의 프로필 이미지
    analist869255

    受講レビュー 1

    ∙

    平均評価 5.0

    5

    100% 受講後に作成

    Master Google Spreadsheets in just 1 hour. Really simple, just what you need, no frills! Is there a next version? lol

    • pbj0812
      知識共有者

      Thank you for your words!!! Currently... I'm planning to write a book with the contents and other things... After that, I'm thinking of making the update part into a lecture... I'm lazy so it's delayed... I'll try to get my mind back with this course review!!!

  • znznekfl1397님의 프로필 이미지
    znznekfl1397

    受講レビュー 1

    ∙

    平均評価 5.0

    5

    100% 受講後に作成

    I'm embarrassed to say this, but this is the first time I've used a spreadsheet since I started working, so I was a little confused, but this lecture really helped me understand the basic concepts!

    • pbj0812
      知識共有者

      Thank you!!! You don't have to be embarrassed for not knowing!!!

￥698

pbj0812の他の講座

知識共有者の他の講座を見てみましょう！

Python with Jupyter NotebookHình thu nhỏ khóa học

Python with Jupyter Notebook

pbj0812

I wanted to briefly cover the basics of Python through Jupyter Notebook, which allows you to immediately check the results of your coding.

Cơ bản

Cơ bản

Python

Python with Jupyter NotebookHình thu nhỏ khóa học

Python with Jupyter Notebook

pbj0812

SELECT ALL FROM SQL2Hình thu nhỏ khóa học

SELECT ALL FROM SQL2

pbj0812

This is a [Data Analysis, Programming Language] lecture prepared for SQL data analysis beginners. This is a SQL SELECT basic grammar lecture that starts without installing SQL.

Cơ bản

Cơ bản

SQL, MySQL

SELECT ALL FROM SQL2Hình thu nhỏ khóa học

SELECT ALL FROM SQL2

pbj0812

PYTHON written like SQLHình thu nhỏ khóa học

PYTHON written like SQL

pbj0812

You can learn how to handle data frames (tables) using Python, similar to the SELECT statement in SQL.

Cơ bản

Cơ bản

Python, SQL, Pandas

PYTHON written like SQLHình thu nhỏ khóa học

PYTHON written like SQL

pbj0812

Data analysis starting with SQL and Google SheetsHình thu nhỏ khóa học

Data analysis starting with SQL and Google Sheets

pbj0812

I have summarized the essential SQL SELECT statements and basic usage of Google Sheets that I learned while working as an analyst at a service company.

Nhập môn

Nhập môn

SQL, Google Sheets, DBMS/RDBMS

Data analysis starting with SQL and Google SheetsHình thu nhỏ khóa học

Data analysis starting with SQL and Google Sheets

pbj0812

SELECT ALL FROM SQLHình thu nhỏ khóa học

SELECT ALL FROM SQL

pbj0812

This is a basic SQL SELECT grammar lecture that starts without installing SQL.

Nhập môn

Nhập môn

SQL

SELECT ALL FROM SQLHình thu nhỏ khóa học

SELECT ALL FROM SQL

pbj0812

PYTHON like MATLABHình thu nhỏ khóa học

PYTHON like MATLAB

pbj0812

You can quickly convert MATLAB code to PYTHON by extracting only the PYTHON grammar that matches the MATLAB grammar.

Cơ bản

Cơ bản

Python, MATLAB, Data Engineering

PYTHON like MATLABHình thu nhỏ khóa học

PYTHON like MATLAB

pbj0812

Programming Starting with MATLABHình thu nhỏ khóa học

Programming Starting with MATLAB

pbj0812

This course covers the most important and basic grammar in MATLAB through simple examples, so that even non-computer experts can learn it quickly.

Nhập môn

Nhập môn

MATLAB

Programming Starting with MATLABHình thu nhỏ khóa học

Programming Starting with MATLAB

pbj0812

似ている講座

同じ分野の他の講座を見てみましょう！

Learn Google Spreadsheet Basics by FollowingHình thu nhỏ khóa học

Learn Google Spreadsheet Basics by Following

zikdinglab

This is a basic course for those who are new to Google Spreadsheets. Learn vivid data analysis using real estate public data! :)

Nhập môn

Nhập môn

Google Sheets

Learn Google Spreadsheet Basics by FollowingHình thu nhỏ khóa học

Learn Google Spreadsheet Basics by Following

zikdinglab

How to Use Google Spreadsheets for WorkersHình thu nhỏ khóa học

How to Use Google Spreadsheets for Workers

groschool

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

Cơ bản

Cơ bản

Google Sheets, Google Apps Script

How to Use Google Spreadsheets for WorkersHình thu nhỏ khóa học

How to Use Google Spreadsheets for Workers

groschool

[Basics] Even those with no coding experience can do it! Automating Google Sheets tasks in 90 minutesHình thu nhỏ khóa học

[Basics] Even those with no coding experience can do it! Automating Google Sheets tasks in 90 minutes

workwithdugi

Even those with no coding experience can automate Google Sheets and Apps Script tasks! I will teach you the easiest way by creating examples that can be used in actual work.

Nhập môn

Nhập môn

Business Productivity, Google Apps Script, Google Sheets

[Basics] Even those with no coding experience can do it! Automating Google Sheets tasks in 90 minutesHình thu nhỏ khóa học

[Basics] Even those with no coding experience can do it! Automating Google Sheets tasks in 90 minutes

workwithdugi