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 Functions Switch between manual and automatic recalculation methods in Excel (Excel)
Excel, which contains a large number of formulas, will recalculate each time you perform some operation, and you will not be able to perform the next operation until the calculation is finished. If you feel that Excel is too slow, you can stop the recalculation to make it run more smoothly. Also, for some reason without realizing it...
Excel Functions The two reasons for garbled csv files and how to fix them [Thorough explanation by an Excel master] Windows version.
"Huh? What is this?" Have you ever opened a CSV file in Excel only to find that the text in the file is a series of unintelligible symbols? Yes, you are now facing a troublesome problem called "garbled characters," which is a common problem that many people suffer from...
Excel Functions How to display time in 15-minute increments (CEILING and FLOOR functions) Excel
In the last issue, we introduced how to use the TIME function to display the time in 15-minute increments, 30-minute increments, etc. (TIME function) Excel pointed out that it would be easier to use the CEILING and FLOOR functions...
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.
Edge Digital certificate can no longer be selected when logging in to a site (Edge)
Have you ever seen the following error message when using login with a digital certificate? The certificate you have selected is not available for this service. Please close all browser windows and try again. Internet ban...
Excel Functions Forgot Password] How to remove sheet protection Excel (Excel)
I have a "sheet-protected" Excel file that I really need to unprotect, but the person in charge of applying the protection has already left the company or lost the memo, and I don't know the password. In such cases, do I have no choice but to give up? No, you can...
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 Auto-filter cuts out in the middle, how to fix Excel (Excel)
Have you ever had a situation where you applied an auto-filter and found that the auto-filter was only working on the 20th row, even though data was included up to the 100th row? In this article, we will introduce what you should check when you encounter such a situation. Auto filter aperture...
Let's make a petty cash book. How to Create a Petty Cash Log in Excel (Invoice-Compliant Template Guide)
Many companies and sole proprietorships use petty cash to keep track of personal and company finances. However, it is very time-consuming and error-prone to keep balances and to post the information in the cash book to the accounting system...
English 
日本語