Title | : | How to create barcodes in Excel that WORK! |
Duration | : | 11:22 |
Viewed | : | 670,197 |
Published | : | 06-02-2020 |
Source | : | Youtube |
Get access to the full course here π https://www.xelplus.com/course/excel-vba-excel-macros/ Get ready to dive into a unique Excel project: creating UPC-A barcodes! This video is perfect for those who love to explore unconventional uses of Excel. Discover how to generate these common 12-digit barcodes right in your spreadsheet, complete with a detailed explanation and a touch of VBA magic. β¬οΈ DOWNLOAD the workbook from here π https://pages.xelplus.com/barcode-generator-file β¨ Key Highlights: βͺοΈ Understanding UPC-A Barcodes: Learn what UPC-A barcodes are and their components. βͺοΈ Step-by-Step Guide: Follow a detailed guide to create UPC-A barcodes in Excel. βͺοΈ Using VBA for Barcode Generation: Uncover how VBA (Visual Basic for Applications) is used to automate barcode creation. βͺοΈ Practical Example: Test the barcode creation with a real product to ensure accuracy. βͺοΈ Downloadable Resource: Access a ready-to-use Excel file for creating your own barcodes. 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! 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 β‘οΈ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join πβ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/ π Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/ π₯ RESOURCES I recommend: https://www.xelplus.com/resources/ π©Letβs connect on social: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/company/xelplus 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! #Excel
![]() |
How to Create & Use Excel Macros (Real world ex... 10:09 - 1,689,354 |
![]() |
EASILY Make an Automated Data Entry Form in Excel 14:52 - 351,720 |
![]() |
How to Generate Barcodes in Excel (in 2 simple ... 02:37 - 9,267 |
![]() |
How to make barcodes for your small business | ... 14:17 - 264,773 |
![]() |
How BARCODES Work 04:13 - 1,001,969 |
![]() |
How to Create an Organizational Chart Linked to... 08:53 - 694,730 |
![]() |
How to Create a QR Code in Excel for Every Need... 08:23 - 24,051 |
![]() |
Excel Time-Savers - 5 Hidden Features for Busy ... 14:24 - 361,420 |