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 Round Time to 15-Minute Intervals in Excel (Easy Formula Guide)
Struggling with time rounding in Excel? This guide shows you how to combine TIME and ROUND functions effectively. Simple techniques that boost productivity. Master time rounding calculations with ease.
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.
Excel Functions SUMIF and SUMIFS Functions Excel
The SUMIF function can be used to change the contents of the total according to conditions, and the SUMIFS function can be used to specify multiple conditions. The reason why and how to use the SUMIF...
googlesheet 2 Easy Ways to Hide or Show Zero Values in Google Sheets
Looking to hide zero values in Google Sheets? This must-read guide explains two easy methods—using custom formatting and the IF function. Discover how to instantly clean up your tables and boost the visual quality of your documents. Would you like a slightly shorter or more technical variation as well?
Excel Macro (VBA) Measure macro processing time Excel(Excel) Macro(VBA)
When trying to speed up a macro, it is first necessary to be able to determine how much time was saved before and after the improvement, and how much time was saved or not. To do this, it is necessary to be able to measure the time. In this article, we will show you how to do this. In this article, we will discuss the process of...
Excel Functions Excel (Excel) Conditional Formatting Methods
Excel has a function to change the format according to cell values and various conditions. Here is an example of a specific setting. Suppose you have a simple table like the one below, and you want to shade in red the cells where no sales have been entered. First, select the range you want to format. Next, select "Home"...
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 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 How to Extract Data Using the VLOOKUP Function in Excel
Being able to use the VLOOKUP function will expand the range of data handling, and will help you be seen as an intermediate Excel user by beginners. In this article, we will show you how to use the VLOOKUP function, and how to use the INDEX and MATCH functions to compensate for the weaknesses of the VLOOKUP function...
English 
日本語