Excel VBA for Business: Barcodes
3.4 (22 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
3,571 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel VBA for Business: Barcodes to your Wishlist.

Add to Wishlist

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!
3.4 (22 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
3,571 students enrolled
Created by Daniel Strong
Last updated 7/2014
English
Current price: $10 Original price: $80 Discount: 88% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I 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
View Curriculum
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 is the target audience?
  • Programmers
  • IT Workers
  • Excel Users
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 21 Lectures Collapse All 21 Lectures 02:03:38
+
Getting Started - An Introduction to Barcoding
5 Lectures 17:34

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.

Introduction
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 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 20:58

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

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

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
4 Lectures 12:05

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
About the Instructor
Daniel Strong
4.3 Average rating
2,962 Reviews
55,303 Students
3 Courses
Excel Instructor/Programmer

Hi! My name is Daniel and i'm 29. I've lived most my life in Scott City, Missouri, United States. I've been using Excel since my early teens, and very early on realized that I absolutely love it. After working on various projects in my spare time for years, improving the lives of those that used my programs, I knew this was more than just a hobby for me; it's my passion. A few years back, I got my first opportunity to program in Excel, but when I landed the job I was asked to re-write my predecessor's coded programs with fancy databases and automated Crystal reports! I found my Excel skills somewhat lacking. I HAD TO LEARN VBA! I studied and studied what I could online and in books, but I wasn't able to learn much that way. I had to dive into my first project for months and months - basically just teaching myself and "figuring it out". I realized that if only someone was out there teaching Excel VBA like Mike Gervin (ExcelIsFun) taught Excel, making everything simple and visual - then Anyone could learn VBA! I started a YouTube channel, mostly for myself as a reference tool, but people started to bite. People flooded my inbox with questions and comments that I was literally changing their lives for the better. My passion is and always has been teaching, and I've turned thousands of people into Excel programmers. Now, with Udemy, I'm going to teach the good stuff - the stuff I kept secret; the Advanced and "not-so-Advanced-but-Awesome" Excel VBA. The things that make people hire you - that make you irresistable and irreplacable. Building REAL Programs, Advanced Reporting and Data Analysis. Dashboards and live data. Automation. My main focus is to create an online community of professional Excel VBA developers and beginners who create Real Programs, solve Real Problems and change Real Lives.