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)
Edge Digital certificate can no longer be selected when logging in to a site (Edge) Have you ever seen the following error message when using login with a digital certificate? The certificate you have selected is not available for this service. Please close all browser windows and try again. Internet ban... 2024.08.02 Edge
Excel Macro (VBA) How to use the variable type "Workbook" Excel(Excel) Macro(VBA) For other variable types, please refer to Excel (Excel) Macro (VBA) about variable types. First, we will explain the basic usage of the variable type "Workbook". 2024.06.14 Excel Macro (VBA)
Excel Functions How to Extract Text After a Specific Character in Excel Using RIGHT and FIND Struggling to extract text after a specific character in Excel when data lengths vary? This article explains how to combine the RIGHT and FIND functions to solve the problem—taught by an experienced Excel formula expert. 2025.06.18 Excel Functions
Excel Functions How to paste Excel (Excel) images There are functions to do various things with images, such as sticking an image on Excel or fitting an image into a cell. In this article, we will introduce two ways to import images into Excel. Place the image on top of a cellOnce you save the image to a folder somewhere on your terminal, you can use this method... 2024.05.16 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 Functions Top 4 Ways to Write Vertically in Excel: Features, Pros, and Best Use Cases Excel is normally designed to be written horizontally, but it can also be written vertically. There are several ways to do this, but in this article, we will introduce four methods, two using "cell formatting" and two using "text boxes. Using "Vertical Writing" Cell Formatting1.... 2025.05.30 Excel Functions
Excel Functions Linking two pull-downs (drop-downs) without macros (for linking only one set) Excel (Excel) この記事ではExcelで2つのプルダウンを連動させる方法を解説します。部署選択後に該当社員のみ表示したいけど作り方が分からず悩んでいませんか?実はINDEX関数とMATCH関数で簡単に連動可能。Excel専門家が伝授します。 2025.06.09 Excel Functions
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 Macro (VBA) Automatically create invoices from sales invoices3 Excel (Excel) Continuing from the previous article, "Creating Invoices Automatically from Sales Statements 2: Excel," we will now move on to creating invoices. If you haven't read it yet, please also read "Creating Invoices Automatically from Sales Statements 1: Excel". Putting details on an invoice (using a macro)... 2024.05.16 Excel Macro (VBA)Let's make an invoice from a sales invoice.