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 Functions VLOOKUP function gives #N/A or #REF! The VLOOKUP function is a very useful function for handling data, but many of you may have experienced that once you get stuck in the error swamp of #N/A or #REF! In this article, we will discuss how to use the VLOOKUP function to get rid of the #N/A and #REF! 2024.07.05 Excel Functions
Excel Macro (VBA) How to Clear Sheet Data with Excel VBA: Simple Macro Tutorial for Beginners Tired of manually deleting large amounts of Excel data? This article explains how to delete sheet data using VBA macros with ClearContents, Clear, and Delete—completing the task in seconds. 2025.06.18 Excel Macro (VBA)
Excel Macro (VBA) "How to Create Your First Excel Macro (Beginner’s VBA Guide) To write a VBA, you start with the "Development" tab, which is not present by default. Click on the File tab, then click on the option... 2024.05.28 Excel Macro (VBA)
Excel Macro (VBA) [For Beginners] Step-by-Step Guide to Installing SeleniumBasic This article offers a beginner-friendly, detailed guide to installing SeleniumBasic. Stuck on the installation and thinking about giving up on automation? The truth is, anyone can install it by taking it one step at a time. A professional with 20 years of experience teaching Excel will walk you through the process. 2025.06.16 Excel Macro (VBA)
Excel Functions 3 Easy Ways to Hide or Show Zero Values in Excel: Simple Formatting Tips As shown in the figure below, when "A1" cell contains 150 and "A2" cell also contains the same number, 150, the calculation result of "=A1-A2" is "0" zero. There are three ways to avoid displaying numbers when the result of the calculation is "0" zero. The result of the calculation is "0" zero... 2024.10.29 Excel Functions
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 How to use Excel (Excel) INDEX and MATCH functions in combination We will show you how to display the desired data by combining the INDEX function, which refers to data from a table on another sheet, and the MATCH function. How to Write the INDEX Function There are two ways to write the INDEX function. INDEX(array, row number,) INDEX(reference, row number, , ) 2024.07.27 Excel Functions
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... 2024.07.05 Excel Functions
Excel Macro (VBA) About Variable Types Excel(Excel) Macro(VBA) This section explains the types used when declaring variables in "Dim Variables". Here are some typical types of variables that you only need to remember. I almost always use only these. Variable typeThe range of data that can be storedstring stringlong integer (-2,14...) 2024.06.14 Excel Macro (VBA)