통계 분석 마스터 클래스
Masocampus
이제 경험보다는 데이터를 기반으로 대답할 때! 통계 지식으로 신뢰성을 수치화하여 근거로 제시한다면 여러분의 설득력은 무한대로 UP!
Basic
통계
Google Spreadsheets Practical Techniques
Google's Excel, Google Spreadsheet! Learn how to use and reference functions in Google Spreadsheet. After taking the course, you will be able to skillfully conduct data analysis with Google Spreadsheet.
What you will learn!
Data analysis using functions and references
Various visualization techniques for each purpose
Ability to import, preprocess, and manage external data
The ability to easily analyze data with pivot tables
From data analysis to collaboration and pivot tables.
Learn how to use spreadsheets 🗂️
💎 Please check before taking the class!
- This lecture has poor audio quality, so please preview the lecture first.
- Since this is a hands-on course, we recommend bringing a dual monitor or a spare device that allows you to separate the lecture and practice screens. Furthermore, since the practical training will be conducted on a Windows OS, we recommend taking the course on a Windows environment.
- Lecture notes and practice files are available in the <0. Textbook Download Center> section.
Google Spreadsheets
Practical Techniques 📊
Google Drive serves similar purposes to Excel, but has the advantage of being free. It offers access to all essential Excel features, including the VLOOKUP function, charting, and pivot tables, all of which are readily available to any office worker.
We'll begin by learning how to manipulate data freely using functions, references, and conditional calculations. Then, through hands-on examples, you'll learn data visualization techniques as powerful as those found in Excel. We'll also cover how to securely work with Google Spreadsheets' collaborative features, using various sharing settings and permissions.
I recommend this to these people 💁♀️
With Google Spreadsheets
Those who want to do full-scale data analysis
Anyone who wants to create an insight sharing environment
With free business tools
People who want to increase productivity
Starting a business, joining a company, changing jobs, etc.
Dreamers
💡 You can acquire these capabilities.
- Using Functions with Google Spreadsheets
We conduct a practice analysis of customer churn risk using aggregated customer sales data. - Google Spreadsheet Data Visualization
Gain visualization capabilities by creating visualization objects and utilizing sparklines. - Analysis with Pivot Tables
You can summarize and analyze data and apply slicers, just like a pivot table in Excel. - Maintain security with permission management for collaborative work
Collaborate safely with permission settings and communication features for co-editing.
What you'll learn 📚
1. Using functions and references
Performing a sensitivity analysis
2. With LOOKUP data
Create a drop-down menu to view all at once
3. Create a chart
Customize
4. With Pivot Table
Analysis and visualization all in one!
Expected Questions Q&A 💬
Q. Do I need to know how to use Excel pivot tables or references to take this course?
Don't worry if you don't know anything. This course isn't designed for students with Excel knowledge, but rather for those willing to learn Google Spreadsheets.
Q. Can I take the course even if I don't know anything about Google Spreadsheets?
Basically, it is composed of functions similar to Excel, so if you are proficient in Excel, it may not be difficult to take the course. However, if you take Maso Campus' 'Google Spreadsheet Practical Introduction' course, you will be able to take the course with less difficulty, so we recommend taking that course first.
Q. Are there any requirements or prerequisites for taking the course?
Since this is a hands-on course, we recommend bringing a dual monitor or a spare device that allows you to separate the lecture and practice screens. Furthermore, since the practical training will be conducted on a Windows OS, we recommend taking the course in a Windows environment.
Google Spreadsheet Series 💪
Introducing the Knowledge Sharer ✒️
Recommended for
these people
Who is this course right for?
People who dream of starting a business/joining a company/changing jobs/re-skilling/talent transformation
For those who want to perform full-scale data analysis using Google Spreadsheets
For those who want to create an efficient insight sharing environment with appropriate visualization
For those who want to increase productivity with free business tools
7,027
Learners
857
Reviews
96
Answers
4.7
Rating
85
Courses
"어제보다 성장하겠습니다. 그리고, 어제보다 성장하려는 사람을 돕겠습니다."
마소캠퍼스의 진심과 소망을 담은 Actionable Content로,
2013년부터 온오프라인으로 함께해 온 누적 강의 1억시간!
이 소중한 경험과 시간은 언제나 마소캠퍼스와 수강생 모두의 성장의 원천입니다.
마소캠퍼스 팀은 우리의 모두의 성장을 위해 두 가지 원칙을 반드시 지킵니다.
1. 배우면 반드시 쓸 수 있는 Actionable Content
2. 참여자의 시간과 수고를 존중하는 Time-Saving Curriculum
마소캠퍼스의 Actionable and Time-Saving Curriculum으로 성장의 길을 함께 걸어나가길 기원합니다.
Curriculum
All
16 lectures ∙ (7hr 0min)
Course Materials:
Lecture resources
Published:
Last updated:
Reviews
Not enough reviews.
Please write a valuable review that helps everyone!
$61.60
Masocampus's other courses
Check out other courses by the instructor!
Similar courses
Explore other courses in the same field!
![[기초]코딩 무경험자도 가능! 90분에 뽀개는 구글 시트 업무 자동화Course Thumbnail](https://cdn.inflearn.com/public/courses/331717/cover/a395d468-0688-4908-88c2-4d087f24d7b7/thumbnail.jpg?f=avif&w=420)