Excel Macro (VBA) How to install .NET FrameWork What are the versions of the .NET Framework? NET Framework (DotNet Framework) comes in various versions (types of toolboxes) with slightly different tools inside... 2024.10.01 Excel Macro (VBA)
Excel Functions How to use the sheet protection function. After you have created a great system or tool in Excel, do you ever have this fear when you want others to use it? What if someone accidentally breaks a formula... What if an important function is deleted? I only want to edit the cells I need, but... 2024.10.08 Excel Functions
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? 2024.06.05 Excel Functions
Excel Functions How to Flag Non-Dropdown Values in Excel Using Conditional Formatting この記事ではExcelのプルダウンリストにない項目を入力した時に条件付き書式でセルの色を変える方法を詳しく解説。VLOOKUP関数で集計時にエラーが出て悩んでいませんか?実はMATCH関数とISNA関数の組み合わせで解決できます。 2025.06.11 Excel Functions
Excel Macro (VBA) Excel Macro (VBA): How to use the CountIfs function in VBA! If you are a beginner who wants to use Excel's COUNTIFS function in VBA, this is a must. This article provides a thorough explanation from basic writing to error handling. In fact, with a few tricks, you can reduce processing time from a few minutes to a few seconds. Read this article and you will be able to efficiently tabulate data from tomorrow. 2025.02.12 Excel Macro (VBA)
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
Windows How to display file extensions [Windows 11]. For the beginning computer user, there may be little trouble with file extensions not being displayed. However, once you have started to tinker with computers to some extent, there are situations where you may need to change the file extension or process a file differently depending on its extension, so this... 2024.10.08 Windows
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... 2024.05.28 Excel Macro (VBA)
Excel Functions How to set and remove sheet and book protection Excel (Excel) If you are thinking about preventing Excel mishaps, this is a must! This article details how to set up and remove sheet and book protection. In fact, you can easily set it with a password. This article will help you protect your important data. 2025.06.06 Excel Functions
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. 2025.07.03 Edge