Excel Macro (VBA) How to Find the Last Row in Excel Using VBA (Macro Guide for Beginners)
We show you how to search through the data from the top down, and how to start from the bottom row of the Excel file and work your way up.
Excel Macro (VBA) 
Excel Macro (VBA) [For Beginners] Detailed explanation of how to easily operate Edge/Chrome with VBA (summary)
Mr. Sato, is there any good way to import Web information into Excel? Ms. Sato, a student in the Excel course, asked the question with an enthusiastic expression. Manager, that's right. Actually, you can easily get information on the Web magically by using VBA... I have 20 years of Excel experience...
Excel Functions How to Extract Text After a Specific Character in Excel Using RIGHT and FIND
Struggling to extract text after a specific character in Excel when data lengths vary? This article explains how to combine the RIGHT and FIND functions to solve the problem—taught by an experienced Excel formula expert.
Excel Functions How to apply mosaic (blur) Excel
When you are preparing a document or manual for external publication, you may need to refer to a web site or a screen where non-public information is visible. In such a case, you would like to put a mosaic like this on the non-public part. We will explain this method in detail in this issue...
Excel Functions What does the error message "#NAME?
Error messages are unavoidable when dealing with Excel, and you may be surprised when they suddenly appear. Here are the meanings and countermeasures for this error message. Meaning of "#NAME?
Excel Macro (VBA) How to use the variable type "Workbook" Excel(Excel) Macro(VBA)
For other variable types, please refer to Excel (Excel) Macro (VBA) about variable types. First, we will explain the basic usage of the variable type "Workbook".
Excel Functions How to find function references with trace arrows Excel (Excel)
If you are confused about reference relationships in Excel functions, you have come to the right place! This article details how to find references using trace arrows. In fact, you can easily visualize the relationship between cells from the formula tab. This article will help you understand complex functions.
Excel Functions Automatically create invoices from sales invoices1 Excel (Excel)
There are many useful software systems that automatically output invoices as you record sales data if you pay for them, but many people are unable to install software because they "don't have enough money to pay for it" or "management won't allow it" and are making each invoice by hand...
Excel Functions How to Fix Missing Sheets in Excel (Step-by-Step Guide)
This article explains how to solve the sheet heading hiding problem in Excel from the options settings. Have you ever had trouble finding a sheet in a file created by someone else? This article is written by the author, who has experience in supporting Excel operations.
Excel Functions Excel: Color Cells When Input Doesn’t Match Dropdown List
In this article, you'll learn how to use conditional formatting in Excel to automatically change cell colors when a value entered doesn't match the dropdown list. If you've been struggling with errors during data aggregation using the VLOOKUP function, you're not alone. Fortunately, combining the MATCH and ISNA functions offers a simple and effective solution.
English 
日本語