Learn Google Spreadsheets from Smart Agents

Learn Google Spreadsheets from Smart Agents 📈
We'll teach you practical functions and useful features for data visualization.

Lecture Topic 📖

Introducing Google Sheets

You can think of it as an online Excel program provided by Google.

Advantages of Google Spreadsheets

• Anyone can use it for free as long as they have a Gmail account.
• You can use it with just a web browser that can access the Internet, without having to install a separate program.
• Since it is a cloud service, there is no need to manage file versions separately.
• Multiple people can collaborate together.
• You can use most of the functions you use in Excel.

Lecture Introduction

Basic terms, formulas

Understanding the basic terms of spreadsheets: values and formats.
We will explain important relative and absolute positional references when writing formulas.

If you understand relative position references and absolute position references,
You can create a multiplication table with just one formula.

share

Sharing is essential for collaborative work.
How to share a spreadsheet with others
We will inform you about detailed settings such as sharing scope and permissions.

We'll also share some useful sharing tips for collaborating with your team.

function

Functions such as SUM to calculate the sum or AVERAGE to calculate the average
I think you've probably used it at least once.

There are many other functions available in spreadsheets.
Among the many functions, we have carefully selected the ones frequently used in work and will teach you how to use them.

Drawing a graph

Graphs are a way to visually present a lot of data.
We will teach you how to choose a graph based on the type of graph and data.

Pivot Table

Pivot tables analyze large amounts of data
This is a really handy feature for creating graphs and visualizing them.
Use this when you want to analyze business data by product, month, or week.
We'll explain in detail what pivot tables are and how to use them in your work.

Create a template sheet

The various functions of the spreadsheet that we learned in the lecture
To show you how to use it
I'll explain in detail by creating some template sheets myself.
Refer to the Applications section to create your own custom template sheet.

📋 Travel Expense Settlement Template Sheet

📋100-Day Challenge Template Sheet

Why should I learn 👀

Numeric data management

Online work in the contactless era

Are you using Google Workspace at your company?

• It is composed mainly of functions that are actually frequently used in work.
• We will tell you not only the basic usage method, but also useful tips and precautions to take when using it.
• I used easy-to-understand example data.
• We provide a practice spreadsheet so you can follow along.