Uncategorized Here are some basic concepts and features of JavaScript that you should remember
1. VariablesVariables are used to store data values.let name = "Alice";const age = 25;var isStudent = true;2. Data Types...
Uncategorized 
GoogleSpreadSheet Counting the number of days in a month by combining the DAY and EOMONTH functions (spreadsheet)
To count the days of a month using a combination of functionsDAYinGoogle Sheets , follow these steps:EOMONTHtable of con...
SEO [SEO] What is the probability and percentage of clicks in the search ranking? ｜The most important results
"The click rate for the first place in the search ranking is 28.5%"Sistrix, a digital market research company, analyzed ...
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 FILT...
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?Compou...
SEO SEO Strategies from Google’s Mission｜Google’s Mission and 10 Facts
When it comes to SEO, measures in areas such as "title," "description," and "meta tag settings" are among the typical me...
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 workbookHow far can the maximum number of rows in a Google Spreadsheet wo...
Finance What is NPV (Net Present Value)?
What is NPV (Net Present Value)?NPV (Net Present Value) is how much profit you can get from your investment.It is an ind...
PremierePro PremierePro How to Easily Replace Timeline Placed Images and Videos
Replace with clipIf you want to replace an image that has already been placed with another image, you can use the "Repla...
Windows Windows 10 How to Extract a tgz File ｜Lhaplus
What is a tgz file?TAR archive (compressed) files compressed with Gnu Zip (tgz) software.Here is how to unzip this file....
Windows How to put a password on a USB memory stick or external hard drive so that only you can see the files inside.
Recently, external USB memory sticks and external HDDs (SSDs) can be purchased inexpensively, but if they are lost or mi...
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...
WordPress Fatal error: Maximum execution time of 30 seconds exceeded in…
Fatal error: Maximum execution time of 30 seconds exceeded in ...is what to do if you get a...Fatal error. The maximum e...
Job What is the type of business or occupation of a teacher? Type of business or occupation
What type of business or occupation does a teacher…?Teachers Industry: Education, Learning SupportMajor classificationMe...
Excel Two ways to make a cell invisible (hidden) with its value still in it Excel
You want to keep a value in a cell in EXCEL (Excel) but hide it from the screen.This is a technique you can use in such ...
GAS GAS Using Slack’s Outgoing Webhook API to Write Posts in Google Spreadsheets｜Part2
Slack had a convenient API "Outgoing Webhook" that we can use when we want to "write messages posted to a Slack channel ...
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 wh...
GAS [GAS] Write posts to Google Spreadsheet using Slack’s Outgoing Webhook API | Part2
Slack has a convenient API "Outgoing Webhook" that you can use when you want to write messages posted on Slack's channel...
GAS [GAS] Write posts to Google Spreadsheet using Slack’s Outgoing Webhook API | Part 1
Slack has a convenient API "Outgoing Webhook" that you can use when you want to write messages posted on Slack's channel...
GoogleSpreadSheet [Google Spreadsheet] QUERY function | Query list/Summary
List of APIs that can be used with the QUERY functionSo far, we have practiced how to use and apply the QUERY function.Q...
GoogleSpreadSheet [Google Spreadsheet] QUERY function | Query list Part 2 (WHERE clause)
You can extract data from a range with the QUERY functionThe QUERY function "uses the query language of the Google Visua...
GoogleSpreadSheet [Google Spreadsheet] QUERY function | Query list Part 1 (SELECT clause)
You can extract data from a range with the QUERY functionThe QUERY function "uses the query language of the Google Visua...
Domain What is “CSR”? About the SSL certificate (public key certificate) of the rental server
This time, we will introduce "CSR" when acquiring SSL.What is SSL?SSL is an abbreviation of "Secure Sockets Layer", and ...
GAS [GAS] How to delete all labels created in Gmail | [Caution]
For example, it is a method that can be used when you want to delete the label created in Gmail at once.Function to dele...
WordPress [WordPress] Start a Blog Post (Post/Basics) Part 1
After installing WordPress and building the environment, let's start posting! Blog posting is possible with just a smart...
GAS [GAS] How to create a label with Gmail [Basics]
How to create Gmail labels with GAS (GoogleAppsScript).GmailApp.createLabel(label name)You can create a label by using '...
Mac Book [Mac] Shortcut key to select and delete characters and text at once
This is a convenient shortcut key for selecting or deleting characters in bulk on a Mac.remove everything from the textb...
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 ...
WordPress [MTS Simple Booking Plugin] A convenient plugin that allows you to introduce a reservation system to your WordPress site | Part2
Up to the last time, I was able to create a reservation item using the "MTS Simple Booking plug-in". We will continue to...
WordPress [MTS Simple Booking Plugin] A convenient plugin that allows you to introduce a reservation system to your WordPress site | Part 1
One of the convenient plugins that you can use when you want to introduce a reservation system in WordPress is the “MTS ...