
MATLABで始まるプログラミング
pbj0812
このレッスンでは、MATLABで最も重要で基本的な文法を簡単な例で説明します コンピュータの非専攻者でも迅速に学習を可能にしました。
입문
MATLAB
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.
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 .
✅ 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. 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.
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)
9,770
Learners
434
Reviews
15
Answers
4.8
Rating
8
Courses
- 현) KREAM 데이터 분석가
- 전) ABLY 데이터 분석가
- 전) wadiz 데이터 분석가
- 전) XIILab 인공지능개발팀 선임연구원
- 전) 아라종합기술 수치모델링1팀 사원
- 인하대학교 해양과학과 (학/석)
All
18 lectures ∙ (52min)
Course Materials:
3. Cell Basis
03:56
4. Fixed frame
02:49
6. Format
02:35
7. Cell counting
01:54
9. reference
02:50
10. vlookup
04:53
11. iferror
03:12
12. arrayformula
03:30
13. split
01:52
14. Filtering
01:11
17. Pivot Table
03:22
All
78 reviews
4.8
78 reviews
Reviews 3
∙
Average Rating 5.0
Reviews 1
∙
Average Rating 5.0
5
簡単に多くの時間を節約できるようになりました!ありがとうございます!
聞いてくれてありがとう!!!! 講義を作るときに反応がどうかと思ったのですが、節約されたのは幸いですㅠㅠ
Reviews 1
∙
Average Rating 5.0
5
1時間でGoogleスプレッドシートマスターですね。 本当に簡潔に、ちょうど必要なものばかりなく終わり! 次のバージョンはありませんか?
みんなありがとう! 現在...その内容と他のものを追加して本を書く予定です。 以後、アップデット部分を講義にするか考えています。 私は怠けて遅れています... この受講評でまた心をつかむようにします!
Reviews 1
∙
Average Rating 5.0
5
恥ずかしいですが、スプレッドシートは就職後に初めて書くツールなので少しずつ混乱していましたが、この講義を通じて基礎概念が取れて本当に多くのお役に立ちました!
ありがとうございます!知らないと恥ずかしくなる必要はありません!
$4.40
Check out other courses by the instructor!
Explore other courses in the same field!