Excel Functions How to Flag Non-Dropdown Values in Excel Using Conditional Formatting
この記事ではExcelのプルダウンリストにない項目を入力した時に条件付き書式でセルの色を変える方法を詳しく解説。VLOOKUP関数で集計時にエラーが出て悩んでいませんか？実はMATCH関数とISNA関数の組み合わせで解決できます。
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.
Excel Functions Easy with Excel and Word! Mastering the art of address printing that anyone can do!
Have you ever had to worry about writing addresses for New Year's cards and summer greeting cards? Writing dozens of cards by hand is a lot of work, but buying specialized software is also a bit expensive.... Everyone has experienced this dilemma at least once. But the truth is, your computer...
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...
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 Macro (VBA) For Beginners] Detailed explanation of how to easily operate Edge/Chrome with VBA (summary)
Mr. Sato, teacher, 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 How to Fix Missing Sheets in Excel (Step-by-Step Guide)
This article explains how to solve the sheet heading hiding problem in Excel from the options settings. Have you ever had trouble finding a sheet in a file created by someone else? This article is written by the author, who has experience in supporting Excel operations.
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...
Excel Macro (VBA) How to pass arguments between procedures ByRef,ByVal Excel(Excel) Macro(VBA)
This section describes how to pass arguments when procedures are separated. In the article below, I mentioned that it is easier to read and process the code by separating the procedures...
Excel Macro (VBA) Excel Macro (VBA) to stop automatic calculations
One of the factors that can make a macro very heavy is a large number of formulas in an Excel sheet. In such cases, it may be possible to speed up the process at once by stopping the automatic calculations. First, we will show you how to do this. Calculations without macros...
English 
日本語