Chapter 01 Why You Should Use Google Spreadsheets

[Basic Usage]
Section 01 Structuring Sharing to Increase Productivity
01 Create a Google Spreadsheet account
[Key] 02 Managing Folders with Google Drive
03 Creating a Google Spreadsheet
04 Moving and Copying Google Spreadsheets
[Key] 05 Granting user-specific permissions to access files
06 Sharing a spreadsheet link with unspecified users
07 Compatible with Excel
08 Receive email notification when data is modified
Tracking data modification history entered in cell 09
10 Revert data to a specific point in time
Work in real-time with 11 concurrent users
12. Communicate with collaborators through comments
[Key] 13 Assigning Tasks to Specific Users
14 Reassigning assigned tasks to other users
15 Post your report on the web for everyone to see.
16 Create a Google Form and receive the results in a spreadsheet.
17. Communicate smartly with user chips

Chapter 02 Data Entry/Editing to Speed ​​Up Work

[Input / Edit]
Section 02 Handling the Sheet Freely
01 Examining the sheet composition
02 Adding and deleting new rows and columns
[Key] 03 Moving and Copying Rows and Columns
04 Adjust column width to fit input data
05 Hide the contents of some rows/columns
06 Grouping rows or columns of the same category
07 Fix the table header to the screen
08 Adding and Deleting New Sheets
09 Changing sheet names and colors
Copy 10 sheets to another Google Spreadsheet
11 Hide sheets you don't use often
[Key] Specifying editable cell ranges for each user
13 Setting up sheet protection with formulas

Section 03 Preparing for Error-Free Data Entry
01 Learn about input data types
[Key] 02 Fill in the numbers that increase by 3
[Key] 03 Filling in the day of the week that varies depending on the language setting
04 Moving and copying data
05 Copy and use only the format
06 Get only input values ​​without unnecessary formatting
07 Swap the contents of rows and columns in table
[Key] 08 Fill in only the formula without breaking the format
09 Displaying the thousands separator
Display custom currency symbol before 10 amounts
11 Automatically display the day of the week on the entered date
[Key] Enter 12 consecutive numbers and display them in the form of a mobile phone number.
13 Creating a Drop-Down List
14 Restricting the entry to a certain amount
[Core] 15 Limiting the character length that can be entered
16 Specifying cell values ​​based on whether a checkbox is checked

Section 04 Editing Data Freely
01 Applying formats to fonts
02 Positioning data in the center of the cell
03 Entering more than two lines in one cell
04 Displaying letters vertically
05 Creating a table with border lines
06 Apply cross-color to a table with one click
07 Applying a theme for a unified format
08 Merge multiple cells into one cell
09 Find and eliminate invisible ghosts
10 Show another sheet when clicking on a specific cell
11. Move to another spreadsheet file with one click
12 Splitting data entered in one cell into multiple cells
13 Randomly shuffle the data

Section 05 Applying conditional formatting that changes formatting based on values
01 Applying a background color to cells containing specific words
02 Applying a background color to cells containing dates from a specific period
03 Applying a gradual color scale based on the size of the number
[Key] 04 Applying sex colors based on custom conditions

Chapter 03: Improve Your Skills! Extracting and Processing Data

[Data Creation]
Section 06: Sorting out the data you need from the data deluge!
01 Remove duplicate data and extract only unique lists
[Key] 02 Deleting duplicate data, leaving only specific data.
03 Replace data in cells containing specific characters
[Core] 04 Finding and Replacing Unspecified Data with Patterns
05 Listing data according to rules
06 Extracting only data with specific conditions
[Key] 07 Filtering data without interfering with the work of co-users
[Key] 08 Let users create and use filter conditions themselves.
09 Users with viewer permissions can use filters
10 Check statistics at once through the navigation pane in the status bar
11 Check various statistics for that column by simply clicking on the header.

Section 07: Smart Data Analysis with Pivot Tables
[Key] 01 Summarizing Large Amounts of Data with Pivot Tables
02.
Applying filters to pivot table aggregate values
03 Listing pivot table aggregate values ​​by specific item
04 Checking detailed data for specific values ​​in a pivot table
[Key] 05 Viewing data by changing values ​​to various formats
06 Group by specific value
07 Copying and Using a Pivot Table
[Key] 08 Controlling Two or More Pivot Tables at Once

Chapter 04: Mastering the Principles of Functions: Easily Performing Complex Calculations

[Function]
Section 08 Things to know before using formulas
[Key] 01 Understanding the format of referencing cells
02 Use names instead of complex cell addresses
[Core] 03 Creating a Powerful Array of Functions
[Key] 04 Learn about the ARRAYFORMULA function, which doesn't require auto-filling.
05 Fill in formulas or values ​​in a non-contiguous range at once

Section 09 Mastering Essential Practical Functions
01 Finding the sum and average
[Core] 02 Returning a Specific Value with a Logical Expression
03 Returning different results based on scores using conditional expressions
04 Judging multiple conditions with logical values
[Key] 05 Finding the sum of specific conditions
06 Calculating the average of cells that meet the conditions
07 Finding the highest/lowest value that meets the conditions
08 Finding the number of cells that meet the condition
[Key] 09 Calculating the number of cells using the COUNT function
Find the 10th largest or smallest value
11 Generate random lottery numbers
12 Finding rounding, up, and down values
13 Exclude hidden rows from calculations
[Core] 14 Extracting the Required String
Extract irregular strings by finding the position of 15 characters
16 Displaying strings from multiple cells in one cell
17 Convert a specified string to uppercase/lowercase
[Key] 18 Removing Unnecessary Whitespace
19.
Delete unprintable characters
20 Maintain order even if a row is deleted in the middle
21. Judging odd/even numbers
[Key] Retrieving values ​​by referencing table 22
23 Calculating commissions by seller
Get the value of the cell at the intersection of row 24 and column 24
Return the position of the value found in the range 25
[Key] 26 Finding the Mean of the Dynamic Range
27 Always keep the entry date and time of your documents up to date
28.
Extract year, month, day, and day of the week from the entered date
Find dates before and after 29 N months
Find the completion date excluding weekends and holidays from the 30th day of receipt
31 Do not display error messages
[Key] Real-time retrieval of lists that meet 32 ​​conditions
33 Retrieve only the required list in descending order of amount
[Core] 34 Extracting only unique lists, excluding duplicate data

Section 10: Get things done quickly with powerful Google Spreadsheet functions.
01 Splitting a string entered into a single cell
[Core] 02 Finding Input Patterns and Extracting Some Text
03 Change various irregularly formatted strings at once
04 Determine the character pattern and return it as a logical value
05 Inserting an online image into a cell
06 Creating a small chart inside a cell
[Key] 07 Importing Data from Another Spreadsheet
[Key] 08 Scraping Top Stocks from Domestic Stock Market Searches
09 Scraping book titles and information from online publishing sites
[Key] Scraping Book Images from 10 Websites
11 Scraping newspaper articles in your area of ​​interest
[Key] Commands used with the 12 QUERY function
[Key] 13.
Extracting information on employees who have not been assigned a specific area of ​​responsibility
14 Extract data that satisfies two conditions in descending order
15 Calculate the collection rate for each team and extract data from the second highest collection rate.
[Key] 16. Joining Two Tables to Extract Employee Data with No Accounts Receivable
[Key] 17. Retrieving Data on Specific Stocks in the Domestic Stock Market from Google Finance
18 Collecting daily KOSPI fluctuation trends from Google Finance
19 Translate the entered string into another language
20 Check the language used for the entered string

Chapter 05.
Data visualization that enhances communication power

[Table & Chart Visualization]
Section 11: Transforming Data into Information
[Key] 01 Expressing Rankings in a Column Chart
02 Enter the chart title and subtitle
03 Changing the chart horizontal/vertical axis format
04 Changing the style and series format of a column chart
05 Displaying data labels
06 Adding a Legend to a Chart
07 Changing the data range displayed in the chart
08.
Change the spacing of vertical axis values ​​and add auxiliary grid lines
09 Download the chart as a PDF
[Key] Expressing 10 Stock Prices in a Timeline Chart
11 Move the chart to the gadget sheet

[Video lecture provided]
[Special Appendix] 10 Google Spreadsheet Practical Projects
01 Change the display data to a custom number format
02 Automatically display colors on public holidays
03 Finding input patterns with capture groups
Applying a slicer to a table and using it as a filter
05 Find the menu with the highest and lowest unit prices
06 Months that change depending on the first/second half selection
07 Aggregate only data that meets the selected conditions
08 Using the PIVOT clause in the QUERY function
09 Retrieving cell values ​​from a pivot table using function
10 Creating New Fields Directly in a Pivot Table

Search
Shortcut key collection

｜100% realistic, containing only the 'necessary' for work!｜
Reduce work hours and increase efficiency!

[Practical Master 1]

Work faster! Reduce work hours.
→ Google Spreadsheets is free to use anytime, anywhere with internet access! It distills the essentials for information sharing and collaboration, making it easier and faster to work than Excel.


[Practical Master 2]

From Excel compatibility to data analysis, it boosts your work productivity.

→ It contains all the functions necessary for practical use, from Excel compatibility and differentiated features to information scraping and functions, pivot tables, and chart utilization.
With just this one book, you can completely complete data entry, editing, processing, analysis, and visualization.


[Practical Master 3]

Maintain your competitive edge! We've included hands-on, on-site projects.

→ Learn systematically the work processes that can be performed using Google Spreadsheets by directly following examples of field projects handled in real work.
You will also learn how to resolve various errors and variables that may occur in the workplace.

[Practical Master 4]

Expert know-how revealed! Master Google Spreadsheets.
→ The author, a data analysis expert and YouTube creator, provides a free Google Spreadsheet video lecture filled with practical experience and know-how on YouTube.
Discover the author's complete tips for mastering Google Spreadsheets on various social media channels.