Chapter 1 | Creating Smart Work with Google Spreadsheets

Section 1 | Improving Work Efficiency through Smart Work
Step 1 | The Need for Work Tools for Smart Work
Step 2 | The Requirements for an Efficient Work Tool
Section 2 | Using Google Spreadsheets
__Step 1 | Scope of Google Sheets
Step 2 | How Google Sheets Changed Work Productivity
__Step 3 | How far can I go in developing a business system?

Chapter 2 | Google Spreadsheets for Business Collaboration

Section 1 | Screen layout of Google Sheets and Google Drive
Step 1 | Configuring the Google Sheets Screen
Step 2 | Configuring the Google Drive Screen
Section 2 | Sharing Features
__Step 1 | Granting Sharing Permissions
__Step 2 | Share on the Web
Section 3 | Communication Functions
Step 1 | Communicating with Collaborators ▶ Chat, Video Conferencing
Step 2 | Communication for Work Progress Management ▶ Memos, Comments, and Task Assignments
Section 4 | History Tracking Management Function
Step 1 | Checking File Information and Change History
__Step 2 | Checking Data Change History ▶ Version History, Revision History, and Notification Rules
Section 5 | File Management
Step 1 | Organizing Files
__Step 2 | Searching for Files
__Step 3 | Working Offline
Section 6 | Using the Side Panel
Step 1 | Using the Side Panel

Chapter 3 | Advantages of Google Sheets as a Spreadsheet (Feat.
Excel)

Section 1 | Convenient Data Management
__Step 1 | Always reflect the latest data
__Step 2 | Data Connectivity Based on Unique URLs
__Step 3 | Distinguishing between 'blank' and '0'
__Step 4 | Row/Column Management Functions ▶ Add Row/Column, Delete Row/Column, Insert Cell, Move Row/Column
Section 2 | Function Usability and Extensibility
Step 1 | Automatically expand calculation range - Open row/column range
__Step 2 | Creating an Array Using Curly Braces
__Step 3 | Convenience of entering specific data
Step 4 | Google Sheets Features - Dedicated Functions/Extensions/AI
__Step 5 | Excel Compatibility ▶ Excel Conversion

Chapter 4 | Data Analysis Possible with Basic Functions

Section 1 | Creating a Custom Filter
__Step 1 | Google Sheets Filter Menu ▶ Create Filter, View Filter, Slicer
Step 2 | Calculating Subtotals Based on Filter Conditions ▷ SUBTOTAL
Section 2 | Pivot Tables and Slicers
__Step 1 | Pivot Table
Step 2 | Combining Pivot Tables and Slicers
Section 3 | Using Artificial Intelligence to Analyze Thermal Statistics and Simulation
Step 1 | Reviewing Column Statistics
Step 2 | Simulation with Navigation Functions

Chapter 5 | Handling Data in earnest (Feat.
letters and numbers)

Section 1 | Things to Check Before Working with Data
__Step 1 | Differences in formats that seem similar but different, different but similar ▶ Letters, numbers, time, currency
Step 2 | Understanding Decimal Places
__Step 3 | Custom Format
Step 4 | Remove Duplicate Data ▶ Cleanup Suggestions, Delete Duplicate Items ▷ UNIQUE
__Step 5 | Remove Whitespace Characters ▷ TRIM
__Step 6 | Data Sorting ▷ SORT
Step 7 | Differences by Region/Time Zone
Section 2 | Handling Characters
__Step 1 | Handling Text Using Menu Tools ▶ Extracting Text, Finding Text, Replacing Text
Step 2 | Smart Input through AI Pattern Recognition
__Step 3 | Separate/Extract Desired Characters ▷ SPLIT, INDEX
__Step 4 | Find the desired character ▷ FIND, SEARCH
__Step 5 | Replace specific characters with desired characters ▷ SUBSTITUTE, REPLACE
__Step 6 | REGEX Series Using Regular Expressions
▷ REGEXEXTRACT, REGEXMATFCH, REGEXREPLACE
Step 7 | Using Emojis
Section 3 | Dealing with Dates
__Step 1 | Extracting Dates ▷ TODAY, YEAR, MONTH, DAY, WEEKNUM, EOMONTH
Step 2 | Creating a table of dates and days of the week by month ▷ MONTH
Section 4 | Dealing with Time
Step 1 | Calculate and round elapsed time
▷ QUOTIENT, MOD, ROUND, ROUNDUP, ROUNDDOWN, MROUND
__Step 2 | Automatically record time with timestamps ▷ NOW
Section 5 | Data Format Conversion
__Step 1 | Converting a string to date/time format ▷ DATE, TIME
__Step 2 | Converting a string to a number format ▷ VALUE
__Step 3 | Convert numbers to text format ▷ TEXT
Section 6 | Creating Strings
__Step 1 | Combining Characters and Functions ▷ CONCATENATE, TEXTJOIN
Section 7 | Handling Images
Step 1 | Importing Images from Your PC
Step 2 | Importing Images from the Internet ▷ IMAGE
Section 8 | Handling QR Codes
Step 1 | Generate and Convert a QR Code ▷ ENCODEURL
Step 2 | Scan and Edit the QR Code

Chapter 6 | Essential Functions for Conditional Searches

Section 1 | Basic Functions for Calculation and Comparison
__Step 1 | Basic Calculation Functions
▶ Sum, count, average, maximum, minimum ▷ SUM, COUNT, AVERAGE, MAX, MIN
__Step 2 | Modification of calculation function with IF condition
▷ SUMIF(S), COUNTIF(S), AVERAGEIF(S), MAXIFS, MINIFS
__Step 3 | Variations of Other Calculation Functions
▷ COUNTA, COUNTBLANK, AVERAGE.WEIGHTED
__Step 4 | Basic Logical Functions
▷ IF(S), AND, OR NOT, IFERROR
Section 2 | Automatic Function Repetition, ARRAYFORMULA Function
__Step 1 | Cell Reference Method
__Step 2 | Automatic Function Repeat with the ARRAYFORMULA Function
▷ ARRAYFORMULA
__Step 3 | Automatically Repeating Functions Through AppSheet
Section 3 | The Basics of Conditional Searches: The VLOOKUP Function
__Step 1 | Comparing Conditional Search Functions
__Step 2 | Returning data that meets conditions using the VLOOKUP function ▷ VLOOKUP, HLOOKUP
__Step 3 | Widening the Search Scope with Array Formulas
__Step 4 | Combination with other functions ▷ MATCH, OFFSET, ARRAYFORMULA
Section 4 | FILTER function that returns an array of values ​​that satisfy a condition
__Step 1 | Returning a range using the FILTER function ▷ FILTER
Step 2 | Reconfigure the arguments to expand the filtering range ▶ Satisfy only some, reconfigure the range, and merge sheets
__Step 3 | Combination with other functions ▷ AVERAGE.WEIGHTED, TEXTJOIN

Chapter 7 | Expanding the Search Scope and Importing External Data

Section 1 | IMPORT Function Extending Reference Scope Outside the File
__Step 1 | IMPORT Series Functions
Section 2 | IMPORTRANGE function when referencing another sheet
__Step 1 | Connecting an External Sheet with the IMPORTRANGE Function ▷ IMPORTRANGE
Step 2 | Expanding the Range of Uses by Combining Array Formulas and Reference Cells
Step 3 | Creating a Data Aggregation System
Section 3 | Retrieving Data from the Internet with Web Crawling
__Step 1 | Importing Data from a Web Page ▷ IMPORTHTML, IMPORTXML

Chapter 8 | Becoming a Search Expert Using QUERY

Section 1 | The Ultimate Conditional Search: The QUERY Function
__Step 1 | QUERY function composition and required query statement ▷ QUERY
Section 2 | Utilizing Query Options Fully
__Step 1 | How to Combine Multiple Sheets
__Step 2 | Creating multiple search conditions using comparison/logical operators
__Step 3 | Search by Date/Time
__Step 4 | Syntax that enriches queries
▷ ORDER BY, LIMIT, OFFSET, GROUP BY, PIVOT, scalar function, FORMAT, LABEL, header
Step 5 | Creating a Search System

Chapter 9 | Data Control for Collaboration

Section 1 | Marking Special Notes with Conditional Formatting
__Step 1 | Conditional Formatting
__Step 2 | Apply Conditional Formatting in Bulk Using Custom Formulas
▶ Apply weekend colors, display duplicate values, and cross colors
Section 2 | Restricting Input with Data Validation
__Step 1 | Data Verification
__Step 2 | Reactive Input Restrictions with Conditions that Change Based on Variables ▶ Input Restriction Warning
Step 3 | Configuring a Dependent Drop-Down List ▷ TRANSPOSE
Section 3 | Cell-level input control through sheet protection
__Step 1 | Sheet Protection - Sheet/Range
__Step 2 | Using Duplicate Sheet Protection
Section 4 | Other Input Controls
__Step 1 | Row/Column Control ▶ Freeze Row/Column, Hide Row/Column, Group Row/Column
__Step 2 | Other useful input methods ▷ GOOGLETRANSLATE
Section 5 | Changing Range Arguments Freely
__Step 1 | How to change the range argument ▷ INDIRECT

Chapter 10 | Data Visualization: Get the Information You Need at a Glance

Section 1 | The Purpose of Data Visualization
__Step 1 | How should I visualize it?
Section 2 | Data Visualization Fundamentals, Charts
__Step 1 | Charts Created with Functions ▷ REPT, SPARKLINE
__Step 2 | Basic Use of Charts
__Step 3 | Other Useful Functional Charts
Section 3 | Completing Data Visualization: Real-Time Dashboards
Step 1 | Creating a Real-Time Dashboard with Google Sheets
Section 4 | Creating Interactive Dashboards with Data Studio
Step 1: Connecting Google Sheets Data
Step 2 | Configuring the Report

Chapter 11 | Expanding to Mobile with AppSheet

Section 1 | Extending Google Sheets
Step 1 | Apps Script and AppSheet
Section 2 | Implementing a Mobile Work Environment with AppSheet
Step 1 | Creating an App with AppSheet
__Step 2 | Various Features of AppSheet

Connectivity and Scalability of Google Spreadsheets
_Required shortcut keys
_INDEX

120 examples that explain Google Spreadsheets the best!

Google Spreadsheets is a spreadsheet program optimized for collaboration.
This book consists of 120 examples and explanations that will help you best understand the 'Collaboration' and 'Spreadsheet' features of Google Spreadsheets.
We encourage you to follow along with the examples and learn the core features of Google Spreadsheets.
This one book will teach you how to increase your work efficiency with Google Spreadsheets.

[1] How to Use Google Spreadsheets for Business Collaboration

The biggest reason to use Google Sheets instead of Excel is the 'collaboration' feature.
We cover features that help you collaborate on work, including sharing, communication, history tracking, file management, and utilizing the side panel.

[2] How to use Google Spreadsheets for 'spreadsheet work'

This article covers how to manage and analyze data using Google Spreadsheets.
Learn through examples how to perform simple data analysis using basic filter functions and how to manage data using functions.

[3] The work know-how of 'Mid-op', a successful influencer with 2 million blog visitors

Learn how to use Google Spreadsheets to create collaborative systems, including data collation and search systems.
It also includes work know-how to prepare for errors and difficulties that may arise while working with Google Spreadsheets.
Leave time-wasting repetitive tasks like copy-pasting and error correction to Google Spreadsheets and use this book to your advantage to become a better worker!

[4] How to expand your work environment to mobile

This book recommends the AppSheet mobile app as a way to connect the office and the field.
The AppSheet app allows you to relay field situations to the office in real time.
Learn the basics of using AppSheet from the author, an AppSheet Korea partner.

Who are the potential readers of this book?

@ People who have only used Google Spreadsheets for calculation purposes
@ An employee who needs to learn Google Spreadsheets because it was introduced at the company
@ An office worker who is not good at work and cannot leave work on time due to unnecessary repetitive tasks
@ Team leader who feels the need for a work collaboration tool among team members
@ Planners who want to check the progress of company projects in real time