Excel VBA for Business: Barcodes
4.4 (70 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4,050 students enrolled

Excel VBA for Business: Barcodes

Excel VBA guide to make your own Excel VBA Programs to simplify your life using Barcodes! Step by step inventory system!
4.4 (70 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4,050 students enrolled
Created by Daniel Strong
Last updated 8/2019
English
English [Auto]
Current price: $55.99 Original price: $79.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2 hours on-demand video
  • 2 articles
  • 3 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Learn to Create and Customize your own Barcode Labels
  • Comprehensive understanding of Successful Barcode Scanning and Labeling
  • Build your own custom Inventory System with Step-By-Step video instructions
Requirements
  • Computer
  • Microsoft Excel
  • Eventually get a Barcode scanner
Description

Speed Up Productivity and Lower Data Entry Errors!

It's no secret that data entry errors can cause big problems. Fortunately, this course provides you with a complete set of skills to help you create programs in Excel. This course provides over 2 jam-packed hours of tutorials, including:

  • Data Entry with Barcodes
  • Barcode Scan to Look-Up items from your worksheet/databases
  • How to Auto-Move screens during or after a scan
  • How to process Barcodes with random lengths
  • Lots of Tips for creating and getting a good scan, Everytime!
  • FREE Companion workbook with real life examples
  • FREE Macros and Buttons to Generate Avery 5160, 5162, 5163 and Large label sheets - PLUS Unlimited space for your custom sized projects

****** See what others are saying ******


"Just finished Dan's course. He has a wealth of knowledge with Excel VBA and applies simple yet thought provoking ways to apply barcode scanning and tracking methods. This course was designed to benefit Excel beginners to advanced users. Also Dan's approach to solving problems during his lectures displays his confidence of this subject matter. Take this course if you are interested in extending your knowledge of Excel VBA. ExcelVBA IS Fun!" - Kevin Nee

"Hi Dan, After watching all of the videos I can defiantly see us using this for our company. We currently depend on pencil and paper and the honor system for tracking labor hours for jobs. Each employee is responsible for tracking the hours they spend on a given job. We could print a barcode for each job and apply the label to a board or something like that. Then when an employee starts on that job they would scan that label then select their name. Then the program would stamp the start time, when they are done they scan the bar code again select their name and the program would stamp the stop time. I will defiantly continue studying this course and look into coming up with something of this nature for our company. Thanks for the course." -Scott

"Really awesom course!! Thank you!!!!" -Eunicer R.


You'll receive all these benefits:

Included in the course are 20+ Video Lectures describing the process as well as hands on technical demonstrations for all course materials We provided you with everything you need to get started Today with your Barcode Excel VBA program - Font & How to use them properly, Workbook and how to use it.

Subscription to this course entitles you to LIFETIME Video and Attachments updates, and we will add more material along the way.

Check it out!

Who this course is for:
  • Programmers
  • IT Workers
  • Excel Users
Course content
Expand all 23 lectures 02:06:34
+ Getting Started - An Introduction to Barcoding
6 lectures 19:37

As a programmer, we're all about making life easier for the user. In this lesson, we'll discover why barcodes are significant in several different industries and how we can use them to automate data entry and eliminate errors.

Preview 01:45
Course Materials
00:06

Some barcode fonts are FREE, but very few of the free fonts will actually do you any good without depending on an online source. We want to be able to generate our own barcodes in Excel, so I'm going to let you in on a secret font that works everytime and is legible by almost ALL barcode scanners. This is a free-to-the-public font and it's included in the course downloads. You can also get paid fonts on the web if you have more specific needs.

The website listed in this video is http://grandzebu.net/informatique/codbar-en/code128.htm

Preview 01:43

In this lesson, Dan will shows you how to install the barcode font that's included in the course, so that the programming code will look like a barcode and not jibberish.

Installing the Fonts
02:03

In this lesson, Dan will show you how to use his Excel workbook (included FREE in this course) in order to Generate and Print various Avery label sheets sized labels. You can also customize the sheets and create your own to suit your own needs. We'll show you how the code works and how to generate your own report-label sheets in future lessons.

Preview 06:40

Learn how a scanner works and how easy it is to get a good scan when you know the ins and outs. In this lesson, Dan shows you what it looks like to scan to a computer using a USB wired barcode scanner. We'll begin by scanning to Microsoft Word.

Preview 07:20
+ Getting Set Up. . .
5 lectures 21:47

This lesson is a technical walkthrough of how we use the UDF (user defined function) included in order to generate the code in each cell that we need a barcode.

Using the Special Function and Font in Excel
04:20
BONUS Font and Function - Free 3 of 9 Extended
02:52

In this lesson, we'll show you how to use the Colored buttons that generate each report and how the code works behind it. Simply select your group of cells, click one of the buttons and voila! Your printer is now printing your barcode labels!! Check it out!

Preview 08:13

In this lesson, we review Avery brand, Staples brand labels and talk about sizes and adhesize qualities for your labels. We'll also reveal a special catch-all style of labels that Dan uses as his secret weapon when he can't find a match.

Best Labels to Buy
04:37

A final review of all Label sheet macros included in the course.

Preview 01:45
+ Creating Our First Program
3 lectures 22:35

Now we get to some exciting ground - Creating our first scanning program. Follow along as Dan leads you into creating a barcode-intensive program for scanning items into an inventory system!

Preview 04:24

Still working on our userform, we add a bit of spice to automate data entry using barcode scanner.

Automating Data Entry
11:22

Let's test our first Userform with the scanner! In this lesson, Dan takes some file folders with Barcodes and scans them in using the Barcodes on the filing racks to categorize them into inventory.

Practical Application Exercise
06:49
+ Alternate Methods
4 lectures 50:26

Sometimes you'll have barcodes with the same number of characters - Sometimes NOT! In this lesson, we review an alternate method of recognition for the program. We use a special Character that tells the program when to begin looking up the item in question. Check it out!

Dealing With Non-Uniform Scan Lengths
12:52

Each time we scan, we'll need to look to see if this is a duplicate AND to find out where this item is located or to whom it is assigned.

Looking Up Inventoried Items as You Scan
11:46

We've scanned the items into the database. Now what?! In this lesson, we're leaping forward in time to when it's time to Ship the items off (aka take them out of inventory) and mark them as shipped or "Finished Project", depending on what industry. Check it out!

Marking Items as Shipped or "Finished"
15:42

Tired of guessing how many items we just scanned? How many are left? We're going to add some informative labels and a macro that triggers them to update for each scan. Follow along!

Adding Labels to Userform to Track Inventory Easily
10:06
+ FINAL TIPS
5 lectures 12:08

Nothing's worse than setting up hundreds (or more) of barcodes, just to find that your labels aren't sticky enough due to environmental factors or adhesives, OR that your scanners won't reach that far or your labels aren't big enough. Maybe it's smudgy?! Follow these tips to get a great scan everytime!

Getting A Proper Scan (and Troubleshooting Bad Scans)
04:50

In this lesson, Dan gives tips on what questions to ask a vendor when finding the right scanner for you. What symbols do I need it to read? How far can I get before it won't read anymore, pricing and ruggedization talks as well. Check it out!

Scanner Units - Symbologies, Scan Range, Price and Durability
04:47

Nothing's worse than a bad scan. Check out Dan's final tips on getting that scan PERFECT! A stitch in time. . .

More Tips on Getting a Proper Scan
01:07

A Big Fat Thank you for subscribing to this course and Dan's concluding thoughts. To your continued success!

Dan Strong

More resources to help you learn and grow in your art @

www.ExcelVbaIsFun.com

www.youtube.com/ExcelVbaIsFun

Conclusion
01:21
BONUS LECTURE
00:03