Excel together with a barcode scanner

Have you ever wondered whether it would be possible to start using barcode scanner in Excel?

Well this is possible! Of course you can purchase specific programs for this, which can sometimes be very expensive. But why should you always have to do this when Excel might be able to solve this for you too?

In this video I'm going to show you how you can work with a barcode scanner in Excel in a very simple way.

Download work file HERE

We are going to use the vertical search function here, as well as the error function. Of course this is a basic example and there are several other possibilities that you can apply in Excel. I hope you found this video interesting and it can help you further with this application.

Video index:

00:00 Introduction

02:08 Barcode entered in data list

02:34 Create vertical search function

03:52 Combine if.error with vertical search

06:00 How to make one cell usable.

08:25 Change properties of a +12 digit

09:00 Remove decimal

09:30 password at cell security

09:45 Final decision