• You can preview some of the book's contents.
  Preview

Chapter 1: Getting Started with Google Spreadsheets in One Hour

01-1 Why You Should Use Google Spreadsheets
What is Google Spreadsheets?
4 Features of Google Sheets
Google Spreadsheets: Differences from Excel
01-2 First, get familiar with Google Drive, where spreadsheet files will be stored.
Google Drive
Create a new folder and spreadsheet file in Google Drive
Change the save location of your spreadsheet file
Share a spreadsheet file and assign user permissions
Deleting and Recovering Spreadsheet Files
01-3 Quick Introduction to Google Spreadsheets
Two ways to create a new file
Get familiar with the Google Spreadsheet interface
Adding and deleting rows and columns
Add, move, delete, copy, and rename sheets
Making Excel and Spreadsheet Files Compatible
Upload an Excel file to a spreadsheet and use it.
Converting an Excel file to a spreadsheet file
Import Excel sheets into a spreadsheet
Download the spreadsheet file as an Excel file
01-4 4 Ways to Collaborate with Others on Google Spreadsheets
Communicate with others through comments
Assign tasks to team members (secondary accounts)
Inserting a note into a spreadsheet
Communicate in real time through chat

Chapter 2 Data Entry and Management

02-1 Autofilling Data in Google Spreadsheets
3 Ways to Autofill Data
Automatically fill data with the fill handle
Select the range first and then fill in the data automatically
Easily fill in values ​​with smart input
02-2 Display format in Google Spreadsheets
Data entry rules you need to know first
I want to use numbers and letters together, like 1,000 won!
Separate thousands in amounts with custom number formats
Display the day of the week in a custom number format
Entering date format like Excel
Expressing time in a custom number format
02-3 Learning cell formatting while creating a summary table
Merge cells and align them for better viewing
Add borders to tables to differentiate them
Freely adjust rows and columns
Copy and paste only the formulas, leaving the format as is.
02-4 Tracking Changes
Find who modified a cell
Version history with the ability to revert to previous versions
Recovering data using version history

Chapter 3: Managing the Database for Analysis

03-1 How should I create a database?
What is a database?
Database Creation Rules
03-2 Filter and sort to select only the data you want
How to use value filters
Using value filters
Custom formula filter that allows you to create your own conditions and filter
Using custom formula filters
Organizing your database with filters
Cleaning Up a Bad Database - Column Filters
Create your own filters that don't affect your collaborators
Create your own filter
Sorting to make data easier to view
Sort by two or more criteria
03-3 Organizing data as you wish using regular expressions
What is a regular expression?
Organizing data with regular expressions
Principles of regular expressions
Solving Difficult Regular Expressions with ChatGPT
03-4 Three functions for efficient data work
What if I still need to use the title line?
Fix the title row
Data cleaning to remove duplicates
Remove duplicates by cleaning up your data
Conditional formatting that applies formatting to data that meets conditions
Check payment status with conditional formatting
Find duplicate data with conditional formatting
03-5 Using Data Verification to Prevent Mistakes
Use data validation to restrict input
Dropdown to directly select and enter a given value
Creating a drop-down button
Create a drop-down button that adds in real time
Dropdown to dropdown connection, double dependency
Understanding the INDIRECT function, the key to double dependency
Calling team names by department using double dependency

Chapter 4: Formulas and Functions in Google Spreadsheets

04-1 Mastering the basics of formulas and functions
formula
Various operator symbols used in formulas
function
reference
Using Open References
Understanding Absolute References
Functions related to numbers
04-2 Using Text Functions
Extracting desired data using text functions
Extracting only two characters from the left using the LEFT function
Extract words and create conditions for the extracted values
Using IF, MID, and ISODD functions in combination
Extract words after removing unnecessary spaces
Using TRIM, LEFT, and FIND functions
Find and extract words that satisfy specific conditions
Using the SEARCH and ISERROR functions
Replace text
Using the REPLACE and LEN functions
Split data when line breaks occur in a cell
Using the SUBSTITUTE, CHAR, and SPLIT functions
Delete line breaks
Using the CLEAN function
04-3 Using Date Functions
Calculating dates
3 ways to enter dates
Using the TODAY, YEAR, MONTH, and EDATE functions
Find the number of working days, months, and years
Using the DATEDIF function
Calculate actual working days excluding public holidays
Using the NETWORKDAYS.INTL function
04-4 Using logical functions
How to use logical functions linked to checkboxes
Using the IF function and checkboxes
Creating a formula that satisfies multiple conditions
Creating a checkbox formula that satisfies multiple conditions
04-5 Finding and Using Reference Functions
Use the XLOOKUP function instead of VLOOKUP!
Referencing cells to the left with the XLOOKUP function
XLOOKUP function that can be used for various conditions
Find values ​​that satisfy conditions and find the maximum value
How to use arrays that reference ranges 04-6
Why use arrays?
Using Array Formulas with the ARRAYFORMULA Function in Spreadsheets
Gathering data with the ARRAYFORMULA function
To collate excluding blank rows - Use the FILTER function
Collating data with the FILTER function
Using arrays in non-array functions

Chapter 5: Google Spreadsheet-Only Functions That Cannot Be Used in Excel

05-1 IMPORT function for loading data from the Internet
IMPORTRANGE function to import a range of cells in Google Spreadsheets
Reflect business data in real time on other sheets
How to import multiple data
Import multiple data at once with the IMPORTRANGE function
IMPORTHTML function to import web page information into Google Spreadsheets
Extracting Data from a Web Page - IMPORTHTML Basics
Extract web data and create charts
Creating a chart using data extracted with IMPORTHTML
Extracting data from non-tables or lists
Importing Web Information - IMPORTXML Function
05-2 Functions I create as I please
Creating a named function (custom function)
05-3 The ultimate search engine, the QUERY function
Basic concepts for understanding the QUERY function
Basic usage of QUERY function (WHERE, SELECT clause)
Using the QUERY function with other functions
Basic usage of the QUERY function (GROUP BY, LABEL clause)
Search system using the QUERY function
Creating a search system using the QUERY function

Chapter 6: Creating Visualizations to Understand Data at a Glance

06-1 Data Aggregation - Pivot Table
Summarizing data with pivot tables
06-2 Data Visualization - Charts
Creating a Sparkline Chart with the SPARKLINE Function
Using the various charts provided by Google Spreadsheets
Create a regional chart
Create a pie chart
Creating a line chart with markers
Create a combo chart that shows two values ​​at once
Creating a Combo Chart
06-3 Creating a Dashboard that Automatically Organizes Survey Results
Create a survey with Google Forms
Collaborate with surveys and spreadsheets to create dashboards.
Creating a Dashboard with Survey Results 1
Creating a Dashboard with Survey Results 2

Search

“Google Spreadsheets are so difficult ㅠㅠ” No need to worry!
A professional instructor with 20 years of experience in office programs will teach you
A truly practical introduction to Google Spreadsheets!

This book focuses on learning from the basics step by step to help you resolve your feelings of confusion.
It is organized in a step-by-step manner so that even first-time users can easily follow along, including how to enter data, set formats, and use basic functions, so anyone can get started without any burden.

I recommend this book as a first step to learning Google Spreadsheets, even for those who primarily use Excel.
The author, an expert in office program training, has packed in the know-how he has gained from 20 years of teaching.
It kindly points out areas that beginners might find confusing, and provides detailed information on the differences from Excel, as well as tips and usage methods that can be applied immediately in practice.


Explanation of formulas that you learn one by one from symbols
We'll teach you basic functions and even reference methods in an easy-to-understand way!

Even if you're a beginner who's never used Excel or Google Spreadsheets before and doesn't understand functions, don't worry! This book thoroughly explains everything from the symbols used in functions to how to construct formulas.
If you've ever struggled to figure out which cells to reference because of complex functions, this book will help you thoroughly learn the basics of formulas.


A sneak peek at Google Spreadsheet's unique features that you'll use for life once you learn them!
From collaboration and version history features to IMPORT functions and creating real-time dashboards with Google Forms!

This book also includes amazing features unique to Google Spreadsheets that Excel doesn't have.
From collaborative work that allows multiple people to access a single sheet and work simultaneously, to version history that allows you to roll back files to a specific point in time, to leveraging the IMPORT function to load real-time data from the internet, these are the reasons you should use Google Spreadsheets instead of Excel.
Enhance your practical skills with Google Spreadsheets.

In particular, once you learn the IMPORT function, you can automatically import and update stock prices, exchange rates, and news data, or display desired information in real time to maximize work efficiency.
This book explains the use of the IMPORT function step by step so that even beginners can easily follow along.
Go beyond simply importing data and experience the true potential of Google Sheets by leveraging that data to create real-time dashboards.

Even difficult database organization is a breeze with Google Spreadsheets!
If you learn the QUERY function and regular expressions that you must have heard of at least once, you will become an office worker!

Google Sheets goes beyond simple data entry tools, offering powerful features that make it easy to handle even complex tasks.
Google Spreadsheets can easily handle complex data cleanly using regular expressions or linking to a database to extract and organize the information you want.


This book helps those who are new to the QUERY function or regular expressions learn without feeling burdened by providing practical examples that can be used right away in real-world situations.
We also provide tips on how to combine it with artificial intelligence (AI) tools like ChatGPT to make writing regular expressions and organizing data even easier, so you can now tackle complex data tasks without difficulty!

What if you get stuck mid-practice? Watch the video lectures on YouTube's "Short Lectures" section!
Fun Google Spreadsheets that you can learn with peace of mind!

If you are learning Google Spreadsheets for the first time, you may encounter some difficulties during the practical training.
But don't worry! This book comes with video lectures in "Brief Lectures." Scan the QR code to instantly watch the lectures, visually reviewing the book's content and following along.
Watching this video will help you understand complex function usage and real-time data utilization practices much faster and easier!

[Recommended for these people!]

- New employees who have to learn Google Spreadsheets right away at work
- Managers and managers who want to fully utilize the collaborative capabilities of Google Spreadsheets.
- Job seekers/college students who want to learn Google Spreadsheets for practical use.
- Anyone who wants to become a Google Spreadsheet expert!