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.

강의소개.상단개요.수강생

난이도 초급

수강기한 무제한

Google Sheets
Google Sheets
Google Sheets
Google Sheets

강의상세_배울수있는것_타이틀

  • 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

Effective with appropriate visualization
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.

  1. Using Functions with Google Spreadsheets
    We conduct a practice analysis of customer churn risk using aggregated customer sales data.
  2. Google Spreadsheet Data Visualization
    Gain visualization capabilities by creating visualization objects and utilizing sparklines.
  3. Analysis with Pivot Tables
    You can summarize and analyze data and apply slicers, just like a pivot table in Excel.
  4. 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 ✒️

강의소개.콘텐츠.추천문구

학습 대상은 누구일까요?

  • 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

강의소개.지공자소개

9,661

수강생

1,361

수강평

121

답변

4.7

강의 평점

101

강의_other

"I will grow more than yesterday. And, I will help those who strive to grow more than yesterday."

With Actionable Content that embodies the sincerity and aspirations of Maso Campus,

100 million cumulative hours of lectures shared online and offline since 2013!

This precious experience and time are always the source of growth for both Maso Campus and our students.

The Miso Campus team strictly adheres to two principles for the growth of us all. 1. Actionable Content that can be put into practice immediately after learning. 2. Respecting the time and effort of participants.

The Miso Campus team strictly adheres to two principles for the growth of us all.

1. Actionable Content that you can actually use after learning 2. Time-Saving Curriculum that respects the participant's time and effort Grow with Miso Campus's Actionable and Time-Saving Curriculum

1. Actionable Content that you can surely use once you learn it

2. Time-Saving Curriculum that respects the time and effort of participants

We hope you will walk the path of growth together with Masocampus's Actionable and Time-Saving Curriculum.

We hope you will walk the path of growth together with Maso Campus's Actionable and Time-Saving Curriculum.

더보기

커리큘럼

전체

16개 ∙ (강의상세_런타임_시간 강의상세_런타임_분)

해당 강의에서 제공: [object Object]
강의 게시일: 
마지막 업데이트일: 

수강평

아직 충분한 평가를 받지 못한 강의입니다.
모두에게 도움이 되는 수강평의 주인공이 되어주세요!

Masocampus님의 다른 강의

지식공유자님의 다른 강의를 만나보세요!

비슷한 강의

같은 분야의 다른 강의를 만나보세요!

강의상세.할인문구

$1,176,507.00

28%

$61.60