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.
This course is prepared for Basic Learners.
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 to pivot tables.
Learn how to use spreadsheets 🗂️
💎 Please check before taking the class!
- As the audio quality of this lecture is not good, please preview the lecture first.
- Since this is a hands-on lecture, it would be a good idea to prepare a dual monitor or extra device that can separate the lecture and practice screens. Also, since the practice is conducted based on Windows OS, we recommend taking the lecture in a Windows environment.
- Lecture notes and practice files are available in the <0. Textbook Download Center> section.
Google Spreadsheet
Practical Techniques 📊
Google Drive is used for similar purposes as Excel, but it has the advantage of being a free tool. Anyone in the office can use all the essential functions of Excel, such as the Vlookup function, chart creation, and pivot tables.
We start with how to freely manipulate data through functions, references, and conditional calculations. After that, you can learn data visualization techniques that are as powerful as existing Excel through practical examples. We will also teach you how to work safely with various sharing settings and permissions for another task in Google Spreadsheets, the collaboration function.
I recommend this to these people 💁♀️
With Google Spreadsheets
Anyone who wants to do full-scale data analysis
Anyone who wants to create an insight sharing environment
With free business tools
For those 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 status data. - Google Spreadsheets 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 by managing permissions for collaboration
Collaborate safely with permission settings and communication features during 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 everything at once
3. Create a chart
Customize
4. With Pivot Table
Analysis and visualization in one!
Expected Questions Q&A 💬
Q. Do I need to know how to use Excel pivot tables or references to take this course?
It's okay if you don't know anything. This course is designed for students who are willing to learn Google Spreadsheets, not students who already have Excel knowledge.
Q. Can I take the course even if I don't know anything about Google Spreadsheets?
Basically, it consists of functions similar to Excel, so if you are proficient in Excel, it may not be difficult to take the course, but if you take the 'Google Spreadsheet Practical Introduction' course at Maso Campus, 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 lecture, it would be a good idea to prepare a dual monitor or extra device that can separate the lecture screen and the hands-on screen. Also, since the hands-on training will be conducted based on Windows OS, we recommend taking the lecture 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
Hello
This is masocampus
5,175
Students
525
Reviews
57
Answers
4.7
Rating
74
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: