ReBizRU

VLOOKUP function gives #N/A or #REF!

The VLOOKUP function is a very useful function for handling data, but many of you may have experienced that once you get stuck in the error swamp of #N/A or #REF! In this article, we will discuss how to use the VLOOKUP function to get rid of the #N/A and #REF!

2024.07.05

Excel Functions

Linking two pull-downs (drop-downs) without macros (when reflected in multiple rows) Excel (Excel)

Excel複数行連動プルダウンを作りたい人は必見！この記事ではマクロなしで複数行のドロップダウンを連動させる方法を詳しく解説します。実はINDIRECT関数と名前定義で簡単に実現できるんです。この記事を読めば効率的な一覧表が作れます。

2025.06.09

Excel Functions

Specific ways to present Excel skills that are useful in job interviews.

You use Excel in your daily work. But are those skills that allow you to say, "I'm good at Excel," really applicable in the job market? Many of us learn the basics of Excel in new employee training and use it in our daily work. Sure, we enter formulas, create graphs...

2024.09.29

change of occupation

How to Use Wavy Lines to Crop or Skip Part of an Image in Excel

Master the wavy line technique to compress images in Excel! Step-by-step tutorial showing how to create professional image breaks and save space in your spreadsheets and presentations.

2025.08.07

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 Create a Petty Cash Log in Excel (Invoice-Compliant Template Guide)

Many companies and sole proprietorships use petty cash to keep track of personal and company finances. However, it is very time-consuming and error-prone to keep balances and to post the information in the cash book to the accounting system...

2024.05.30

Let's Make SeriesLet's make a petty cash book.

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

2024.09.22

Excel Functions

Find Out Which Version of Excel You’re Using – Quick Steps

The functions and functions that can be used may change depending on the version of Excel. You should be able to check if your version is supported when errors or problems occur, so we will show you how to check your Excel version in this issue. Acau...

2024.06.05

Excel Functions

Get the path (save location) of the opened Excel file "Path" Excel Macro (VBA)

In many cases, it is useful to be able to get the location of the Excel file you are currently working on when you want to retrieve values from another Excel file or save a file as a name using a macro. In this article, we will show you how to use the "Path" command, which is useful in such cases. The currently open Excel file...

2024.05.30

Excel Macro (VBA)

How to extract characters before a specific character "LEFT and FIND functions in Excel"

As shown in the figure below, if there is extra data after the string and you want to extract only the string to the left of the extra data, you cannot simply use the LEFT function alone because the number of characters is not constant. Function to extract the left side of the "¥" mark in cell "A2" = LEFT(A2,FIND(...))

2025.02.19

Excel Functions