会員登録(無料)
ログイン
Improve your skills, click here now!
HOME
Search
WordPress
Category
Twitter
Youtube

GoogleSpreadSheet

GoogleSpreadSheet

[FILTER function] How to perform a “fuzzy search” in combination with the FIND function (Google Spreadsheet)

This is a method for fuzzy search (extraction) with the FILTER function. What is the FILTER function? You can use the FI...
2022.10.27
GoogleSpreadSheet
GoogleSpreadSheet

Google Spreadsheet Compound Interest Calculation｜How to perform compound interest calculations (simple version)

In this article, we will introduce compound interest and compound interest calculations. What is compound interest? Comp...
2022.10.21
GoogleSpreadSheet
GoogleSpreadSheet

Google Spreadsheet What is the maximum number of rows? Verification of the maximum number of rows

Maximum number of rows in a Google Spreadsheet workbook How far can the maximum number of rows in a Google Spreadsheet w...
2022.10.20
GoogleSpreadSheet
GoogleSpreadSheet

Google Spreadsheet How to display sheet names by cell reference [Can also be used in Excel] INDIRECT function

You may often refer to data from other sheets in Google Spreadsheet or Excel. In such cases, here is how to reference th...
2022.10.19
GoogleSpreadSheet
GoogleSpreadSheet

 [Google Spreadsheet] Create parade charts and ABC analysis graphs from tables | Priority analysis

What is ABC Analysis? "ABC analysis" is the idea that "the top 20% of sales account for 80% of the total", and is used w...
2022.10.18
GoogleSpreadSheet
GoogleSpreadSheet

[Google Spreadsheet] QUERY function | Query list/Summary

List of APIs that can be used with the QUERY function So far, we have practiced how to use and apply the QUERY function....
2022.10.15
GoogleSpreadSheet
GoogleSpreadSheet

[Google Spreadsheet] QUERY function | Query list Part 2 (WHERE clause)

You can extract data from a range with the QUERY function The QUERY function "uses the query language of the Google Visu...
2022.10.14
GoogleSpreadSheet
GoogleSpreadSheet

[Google Spreadsheet] QUERY function | Query list Part 1 (SELECT clause)

You can extract data from a range with the QUERY function The QUERY function "uses the query language of the Google Visu...
2022.10.13
GoogleSpreadSheet
GoogleSpreadSheet

CONCAT function”, “CONCATENATE function”, “TEXTJOIN function” functions to combine strings [Spreadsheet].

When you want to join cell data of columns and rows in Google Spreadsheet, you can use "& (Ambasand)" to join them, but ...
2022.10.10
GoogleSpreadSheet
GoogleSpreadSheet

 [Spreadsheet] How to dynamically get the last row of a column with data entered

This is a method that can be used when you want to know the last row where data is entered. A simple way is the COUNTA f...
2022.10.04
GoogleSpreadSheet
次のページ