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... 2024.07.04 Excel 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... 2025.02.12 Excel Macro (VBA)
Excel Functions How to Adjust Column Width and Row Height in Excel (Manual Methods Explained) Visibility is very poor if the column widths are too narrow to display all of the cell contents, or the row height is too narrow to display the contents. In this article, we will explain how to easily and automatically adjust row height and column width to just the right size. With a macro (VBA)... 2025.05.29 Excel Functions
Excel Macro (VBA) How to display the Immediate Window Excel(Excel) Macro(VBA) One of the skills that you will need to learn as you progress in your VBA studies is the skill of using Immediate Windows. To use it, you must first display the Immediate Window. In this article, we will explain how to display the Immediate Window... 2024.01.02 Excel Macro (VBA)
Excel Macro (VBA) How to use the property of variable type "Workbook" Excel (Excel) Macro (VBA) You can read more about how to use the variable type "Workbook" in this blog. How to use the variable type "Workbook" Excel(Excel)Macro(VBA)Here we will explain the "Workbook" property in a little more detail.Wo... 2024.06.14 Excel Macro (VBA)
Excel Functions How to set up a link by inserting a hyperlink Excel (Excel) Here is how to set up a hyperlink using the Insert Hyperlink function. For example, let's say you have created a document with a table of contents as shown below, which jumps to a cell within the page. Let's say you have created a page with a table of contents as shown in the figure below, and when you click on the name of an item in the table of contents, you will jump to that item. First, let's create a page with a hyperlink to a cell in the page... 2024.07.03 Excel Functions
Excel Functions Forgot Password? How to Remove Read-Only (Write Protection) in Excel If you forgot your Excel password, don’t worry! This article explains how to remove write protection easily by simply changing the file extension. Learn how to unlock read-only mode fast. 2025.07.12 Excel Functions
Excel Macro (VBA) What is an Excel (Excel) Macro (VBA) Module and Procedure? When dealing with VBA, you will come across terms such as modules and procedures, which are not used in everyday life. So, here I will explain about modules and procedures. Modules include standard modules, book modules, sheet modules, fo... 2023.12.27 Excel Macro (VBA)
Excel Macro (VBA) How to use the input screen "InputBox" Excel Macro (VBA) If you want to use values or arbitrary characters that do not exist in Excel, the "InputBox" is useful to easily create an input screen during macro execution. In this article, we will briefly explain how to use this "InputBox". 2025.02.21 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. 2025.07.15 Excel Functions