ReBizRU

For beginners] Explanation of causes of Excel being slow and countermeasures.

Manager, have you ever felt 'kind of heavy' when using Excel? Student Yes, sir! I recently started using Excel to improve my business, but I'm having trouble opening files because it takes so long. ManagerYes, that's right. Many people have the same problem...

2024.10.02

Excel Functions

Excel (Excel) to automatically create a backup file every time you save

Here is how to automatically create a backup file every time you save Excel. Display the General Options screen First, display the "Save As" screen. On the Excel screen, click the "File" tab, then click "Save As," then click "So...

2024.01.10

Excel Functions

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)

Auto-filter cuts out in the middle, how to fix Excel (Excel)

Have you ever had a situation where you applied an auto-filter and found that the auto-filter was only working on the 20th row, even though data was included up to the 100th row? In this article, we will introduce what you should check when you encounter such a situation. Auto filter aperture...

2024.06.14

Excel Functions

[For Beginners] Detailed explanation of how to easily operate Edge/Chrome with VBA (summary)

Mr. Sato, 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...

2024.10.02

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)

How to export a document created in Excel as a PDF

A must-see for those who want to export Excel documents as PDFs! You can export PDFs using only Excel's built-in features, without needing other software.

2026.07.08

WindowsExcel Functions

2 Easy Ways to Hide or Show Zero Values in Google Sheets

Looking to hide zero values in Google Sheets? This must-read guide explains two easy methods—using custom formatting and the IF function. Discover how to instantly clean up your tables and boost the visual quality of your documents. Would you like a slightly shorter or more technical variation as well?

2025.06.18

googlesheet

How to use the method 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" method in a little more detail.Wor...

2024.06.14

Excel Macro (VBA)

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....

2026.07.07

Excel Functions