▽This episode's contents0:00 Opening3:06 What is Google Spreadsheets?3:46 What is the difference between Google Spreadsheets and Excel?5:10 How to get started with Google Spreadsheets5:37 How to access the Google Spreadsheets website6:13 Getting a Google account and logging in6:51 How to create a file7:25 How to save and load files9:01 Basic operations for spreadsheets9:26 How to enter data into a cell10:24 How to change the color and size of text12:57 How to change the background color of a cell14:07 How to change the thickness and color of cell borders18:04 How to merge cells21:56 How to use data input rules23:07 How to set data input rules/selection formulas/options directly26:48 How to set data input rules/selection formulas/options by cell range30:52 Basic knowledge of functions32:09 Displaying formulas33:49 Cell references/relative references37:47 Absolute cell references39:57 Basics of functions - Basic functions40:33 How to use the SUM function42:32 How to use the MAX function43:10 How to use the ROW function44:56 How to use the COUNT function45:42 How to use the COUNTA function48:55 A slightly more advanced function for aggregation50:02 SUMIFS function1:00:23 COUNTIFS function1:02:49 How to use fixed / How to always display header columns and rows1:04:09 How to use filters1:06:22 Filter display function / Change only your display1:11:03 Practical version (Create a project management sheet from scratch!) 1:31:11 EndingThe latest version of 2022 on how to use Google Spreadsheets will be explained in an easy-to-understand manner even for IT beginners! ・I don't really know how to use Google Spreadsheets・I want to be taught carefully from the beginning!・I don't understand simple things, but I can't ask now ・I want to know how to use advanced functions in Google Spreadsheets ・I want to be easily taught how to use functions For those who have such issues and worries, we will explain the method in a very specific and easy-to-understand manner while actually operating. If you have any questions or concerns, please feel free to ask in the YouTube comments section! ▽Google Spreadsheet is here https://www.google.com/intl/ja_jp/she... ▽A simple explanation of how to use and get started with Zoom. Recommended for those who work remotely! • A simple explanation of how to use and get started with Zoom. Recommended for those who work remotely! ▽[Latest version] How to use ZOOM on iPhone and smartphone! It's very easy to join ZOOM on your smartphone. • [Latest version] How to use ZOOM on iPhone and smartphone! It's very easy to join ZOOM on your smartphone. ▽[Latest] Super easy! How to share presentations and your computer screen with ZOOM • Video ▽How to use Office for free and easily [Word, Excel, and PowerPoint can be used for free] • How to use Office for free and easily [Word, Excel, and PowerPoint can be used for free] ▽Subscribe to the channel here / @remote-work ■Recommended videos for learning spreadsheets▽2021 How to use Google Spreadsheets - Beginner's introductory course [Complete version] • How to use Google Spreadsheets - Beginner's introductory course [Complete version] ▽[Essential for work] Carefully selected by G-God. 6 basics to increase productivity with spreadsheets • [Essential for work] Carefully selected by G-God. 6 basics to increase productivity with spreadsheets [Goo... ▽12 tips to speed up PC work with Google Spreadsheets • 12 tips to speed up PC work with Google Spreadsheets Pivot table... ■About this channel (About the Remote Work Research Institute) This channel is run by Tokorocho Ketomo, who has worked with thousands of people in remote work, and who will share the tools and know-how necessary in the era of remote work in an easy-to-understand manner even for those who are not good at IT. We will continue to provide practical explanations and know-how, so please subscribe to our channel and let's learn together! ▼Operating company (Workstyle Evolution Co., Ltd.) https://workstyle-evolution.co.jp/