How to create barcodes in Excel that WORK!

6 February 2020 Excel Infographic Chart Templates

Get access to the full course here: https://www.xelplus.com/course/excel-vba-excel-macros/

Find out how you can create UPC-A barcodes in Excel. I tested the barcode with a scanner and it works! You can download the Excel file and use it to generate your own barcode or use it to learn Excel (thank you Pete for sharing).

The solution is a good mix of Excel formulas such as the MOD function, Excel Text functions like LEFT, RIGHT & MID functions as well as Conditional formatting and some Excel VBA. The final result, i.e. the Excel barcode is recognized by the barcode scanner.

If you'd like to learn more about VBA, check out my playlist here: https://www.youtube.com/playlist?list=PLmHVyfmcRKyzmbDy6QoBuUDrU5D-jD-Se

Source of the image used in the workbook is from this video - In One Lesson - "How barcodes Work": https://youtu.be/e6aR1k-ympo

Thank you Pete for sharing this awesome barcode tool with us!

⯆ DOWNLOAD the workbook from here (scroll to the bottom): https://www.xelplus.com/generate-barcodes-excel

LINK to VBA arrays video: https://youtu.be/7uIZg9p-IZQ
Pete's other video contribution to converts numbers to words: https://youtu.be/1HVLSuAZEtQ

00:00 Why Barcodes in Excel?
01:03 How It Works
05:16 How to Setup a Barcode Generator in Excel

★ My Online Excel Courses ► https://www.xelplus.com/courses/

✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/

EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/

Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593

GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U

More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#MsExcel #Excel #LeilaGharani