ReBizRU

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

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

How to display the Immediate Window Excel(Excel) Macro(VBA)

One of the skills that you will need to learn as you progress in your VBA studies is the skill of using Immediate Windows. To use it, you must first display the Immediate Window. In this article, we will explain how to display the Immediate Window...

2024.01.02

Excel Macro (VBA)

How to display time in 15-minute increments (CEILING and FLOOR functions) Excel

In the last issue, we introduced how to use the TIME function to display the time in 15-minute increments, 30-minute increments, etc. (TIME function) Excel pointed out that it would be easier to use the CEILING and FLOOR functions...

2024.06.18

Excel Functions

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)

How to Round Time to 15-Minute Intervals in Excel (Easy Formula Guide)

Struggling with time rounding in Excel? This guide shows you how to combine TIME and ROUND functions effectively. Simple techniques that boost productivity. Master time rounding calculations with ease.

2025.07.15

Excel Functions

Absolute and relative references in Excel (Excel)

Absolute and relative references are explained below. Relative reference: If you want to display the same contents in cell "C3" as in the neighboring cell "B3", enter the following in cell "C3": =B3. If you want to display the same content in cell "C3" as in the neighboring cell "B3", enter the following in cell "C3": =B3

2023.12.27

Excel Functions

How to Extract Data Using the VLOOKUP Function in Excel

Being able to use the VLOOKUP function will expand the range of data handling, and will help you be seen as an intermediate Excel user by beginners. In this article, we will show you how to use the VLOOKUP function, and how to use the INDEX and MATCH functions to compensate for the weaknesses of the VLOOKUP function...

2024.07.04

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

[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)