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 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 Macro (VBA) The Complete Guide to IF AND in VBA｜Thorough explanation from basic syntax to practical techniques
I want to combine IF and AND statements in VBA, but I don't know how to write it..." I have experienced such a problem. Actually, the way to write it is a little different from the IF function in Excel. In my 20 years of Excel work, I have used IF AND in VBA to automate many tasks...
Excel Functions How to Insert Rows in Excel Without Breaking Formulas
Having trouble with broken formulas after inserting rows in Excel? This article explains step-by-step how to fix them easily using formula copying—shared by an experienced Excel expert.
Edge How to Change Digital Certificate Display Names in Microsoft Edge for Easy Identification
How to Change Digital Certificate Names in Edge | Stop Certificate Confusion. Set friendly names for easy identification. Step-by-step guide to distinguish multiple certificates in Microsoft Edge browser.
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 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 Functions Insert rows without breaking formulas (using spil) Excel (Excel)
With Microsoft365 and Excel 2021 or later versions, you can insert, delete, and rearrange rows without breaking the formula by using a feature called Spill. In this article, we will show you a specific example...
Excel Functions Linking two pull-downs (drop-downs) without macros (for linking only one set) Excel (Excel)
This article explains how to link two dropdown lists in Excel. Are you struggling with how to display only employees relevant to the selected department after choosing it? Actually, you can easily link them using the INDEX and MATCH functions. An Excel expert will teach you how.
Excel Macro (VBA) How to delete a sheet by specifying the sheet name VBA(Macro)Excel(Excel)
As the number of unneeded sheets grows, browsing becomes worse, and Excel itself becomes slower. In such cases, you can use VBA to automatically delete unnecessary sheets. In this article, we will show you how to use VBA to delete sheets at high speed...
English 
日本語