inflearn logo

Practical Google Sheets Techniques

Google's version of Excel, Google Sheets! Learn how to use functions and referencing methods in Google Sheets. After taking this course, you will be able to proficiently conduct data analysis using Google Sheets.

26 learners are taking this course

Level Basic

Course period Unlimited

Google Sheets
Google Sheets
Google Sheets
Google Sheets

What you will gain after the course

  • Data analysis using functions and references

  • Various visualization techniques for each purpose

  • The ability to import, preprocess, and manage external data

  • The ability to easily analyze data using pivot tables

Learn how to use spreadsheets for everything from data analysis and collaboration to pivot tables 🗂️

💎 Please check before taking the course!

  • Since the sound quality of this lecture is not good, please check the lecture through the preview first.
  • Since this is a practice-oriented course, it is recommended to prepare a dual monitor or an extra device so you can separate the lecture screen from your practice screen. Additionally, as the practice sessions are based on Windows OS, we recommend taking the course in a Windows environment.
  • Lecture materials and practice files can be found in the <0. Textbook Download Center> section.


Google Sheets

Practical Techniques 📊

Google Drive is used for similar purposes as Excel, but it has the advantage of being a free tool. Any office worker can utilize all of Excel's essential features, such as the VLOOKUP function, creating charts, and pivot tables.

We start with how to freely manipulate data using functions, references, and conditional calculations. Afterwards, through practical examples, you can learn data visualization techniques as powerful as those in Excel. We will also teach you how to work safely with Google Sheets' collaborative features by using various sharing settings and permission grants.


Recommended for these people 💁‍♀️

Those who want to perform
serious data analysis using Google Sheets

적절한 시각화로 효율적인
인사이트 공유 환경
이루고 싶은 분

Those who want to increase productivity
using free work tools

Those dreaming of starting a business, getting a job, or changing careers

💡 You can acquire these competencies.

  1. Utilizing functions with Google Sheets
    Perform customer churn risk analysis practice using aggregated customer sales status data.
  2. Google Sheets Data Visualization
    Acquire skills in creating visualization objects and utilizing sparklines for data visualization.
  3. Analyze with Pivot Tables
    You can summarize and analyze data just like Excel's pivot tables and apply slicers.
  4. Maintain security through collaborative permission management
    Collaborate securely with permission settings and communication features during co-editing.

Learning Content 📚

1. Performing sensitivity analysis
using functions and references

2. Create a one-glance dropdown menu
using LOOKUP data

3. Create and
customize charts

4. Analysis and visualization all at once with pivot tables!


Anticipated Q&A 💬

Q. Do I need to know how to use Excel's pivot tables or references to take this course?

It is perfectly fine if you don't know anything at all. This course was not created for students with prior knowledge of Excel, but for students who have the will to learn Google Sheets.

Q. Can I take the course even if I know nothing about Google Sheets?

Since it basically consists of functions similar to Excel, those proficient in Excel may not find it difficult to follow. However, we recommend taking MS Campus's 'Introduction to Google Sheets for Business' course first, as it will allow you to follow along even more seamlessly.

Q. Are there any requirements or prerequisites for taking the course?

Since this is a practice-oriented course, it is recommended to have a dual monitor or an extra device to separate the lecture screen from the practice screen. Additionally, as the practice sessions are conducted based on Windows OS, we recommend taking the course in a Windows environment.


Google Sheets Series 💪


Instructor Introduction ✒️

Recommended for
these people

Who is this course right for?

  • Those dreaming of starting a business, joining a company, career transition, reskilling, or talent transformation.

  • Those who want to perform full-scale data analysis with Google Sheets

  • Those who want to create an efficient insight-sharing environment through appropriate visualization

  • Those who want to increase productivity with free work tools

Hello
This is Masocampus

11,087

Learners

1,588

Reviews

136

Answers

4.7

Rating

108

Courses

"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.

More

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!

Masocampus's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!

25% off for new members

$41.60

25%

$61.60