How to create barcodes in Excel that WORK!

Рет қаралды 670,427

Күн бұрын

Get access to the full course here 👉 www.xelplus.com/course/excel-...
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 👉 pages.xelplus.com/barcode-gen...
✨ 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: • Excel VBA & Macros Tut...
Source of the image used in the workbook is from this video - In One Lesson - "How barcodes Work": • How BARCODES Work
Thank you Pete for sharing this awesome barcode tool with us!
LINK to VBA arrays video: • Create Excel Workbooks...
Pete's other video contribution to converts numbers to words: • Convert NUMBERS to WOR...
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: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / 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

Пікірлер: 509

@LeilaGharani 5 ай бұрын

Grab the Excel barcode generator from here 👉 pages.xelplus.com/barcode-generator-file

@karhukivi 4 жыл бұрын

I never cease to be amazed at what Excel can do and how well you explain these features - thank you, Leila!

@kennethlee3177 3 жыл бұрын

You're the best teacher when it comes to Excel, Leila. Thanks for sharing all these wonderful Excel tips! :)

@justanotherexmo48 4 жыл бұрын

I accomplished this by creating my own barcode font that I drew myself in a font creator. I drew a set of characters for the category, manufacturer, product and check digit. I used VBA to do the calculations and for the font output I used offset ascii characters in the map so that each region had its own 10 digit section. I also drew generic bars for inside and outside braces. Fortunately the VBA structure works well as I drew these about 15 years ago and it has performed in all versions of Excel. I am a price book manager for a company with 80 stores and this is used for generating order guides, shelf tags and waste logs.

@excelisfun 4 жыл бұрын

Wow! VBA Barcodes - Thanks, Leila!!!

@LeilaGharani 4 жыл бұрын

Something experimental - actually all the credit goes to Pete :)

@PhenomenalChezline 2 жыл бұрын

Leila, when I came here, I wasn't expecting this level of detail but you really wowed me. I couldn't stop watching and learning. Awesome channel. Keep creating great content!

@Bens598 4 жыл бұрын

It came on my recommendation, I went all ears!!

@Hey_Delight 4 жыл бұрын

Another precious learnimg tool. Thanks so much Ms. Leila and Sir Pete. ❤❤❤

@ismailismaili0071 4 жыл бұрын

thank you so much Ms. Leila and Mr. Pete it was really useful and great video to watch I really appreciate.

@ExcelForFreelancers 4 жыл бұрын

Great video Leila, I learned a lot. :)

@AngeloHafner 4 жыл бұрын

Your videos are fabulous. You transmit knowledge of high complexity in a simple way. Thank you!

@LeilaGharani 4 жыл бұрын

Glad you like the videos Angelo!

@username42 4 жыл бұрын

so pete shared the workbook to her freely, then she shared with us freely and then she uploaded to youtube and youtube shared us freely and she got all the monetization money from youtube so everyone wins :D such a nice win win situation in data age :) you guys z generrations are so damn lucky to be born recently.

@harshverdhansaxena6025 4 жыл бұрын

We never asked our parents to bring us in this world... However, I'm thankful to everything as it feels amazing to see soo many solutions to just a particular question!

@BillHester2011 4 жыл бұрын

Ha ha ha "High fructose corn syrup, that's the first ingredient. Doesn't sound so healthy but I already finished it." Leila I am so glad I subscribed to your channel... So intuitive, so easy to listen to and absorb; those hilarious comments are just icing on the cake.

@dharmeshrana7548 4 жыл бұрын

Excellent work, you and Pete!

@hasarangaanuradha7862 4 жыл бұрын

This is super stuff, Leila. I learned a lot from your youtube lessons - Thank you.

@BillingSoftwareGuru 3 жыл бұрын

yes

@dennisd5776 4 жыл бұрын

Thank you for sharing Pete's code and making it understandable. I learn so such from your videos.

@LeilaGharani 4 жыл бұрын

Glad it's useful for you Dennis.

@arounaalaho6357 4 жыл бұрын

Leila you are among the bests ever. Thank you for sharing important stuff here!

@LeilaGharani 4 жыл бұрын

Thank you for the kind words.

@johnboyd6943 Жыл бұрын

Hi Leila, over 10 years ago I made a barcode generator in Excel 2010 without using VBA. I used it for years in the company I worked for - it worked perfectly. Love your videos, there is always something to learn even though I'm in my 70s.

@Talaran12 5 ай бұрын

Hello Friend! I know this is an old comment, but if you still have the formula you used for this I would love take a look and learn from it! It would go a long way on a project I am working on.

@johnboyd6943 5 ай бұрын

@@Talaran12 Sure, happy to help. I just don't know how I'm able to get the file to you without the whole world knowing either of our contact details. If you have any ideas, let me know.

@aspalding4044 5 ай бұрын

Leila, you are such a charmer. I have always wondered about how barcodes worked and how to create them. Your simple, clear and detailed explanation did not miss it's mark! You must be an amazing person, thank you so much))

@ladellp5135 3 жыл бұрын

The entire time I'm listening to your voice, I could not stop thinking about how beautiful it would be waking up to a "good morning, how did you sleep last night?" from you on a daily basis. OMG... You're AWESOME.

@vincysigma 4 жыл бұрын

Waw.. I newer knew that Excel can do this... and it was explained so detailly... Thank you so much.

@kakairecharles3474 4 жыл бұрын

This so amazing! Thanks veryvery much for this wonderful video!

@andypuempel2570 4 жыл бұрын

Nicely done. Always enjoy seeing creative uses of the powerful capabilities of Excel. Your videos are always to the point and well produced.

@LeilaGharani 4 жыл бұрын

Thank you for the kind words Andy.

@JeremyMcMahan 4 жыл бұрын

As an exercise I just did this in formulas without VBA using a left and right lookup table and VLOOKUP. Works like a champ! Thanks again Leila for the fun video!

@LeilaGharani 4 жыл бұрын

Glad we inspired you to try it your way. This is how real learning happens. Thanks for sharing!

@lazalazarevic6192 4 жыл бұрын

Interesting. Will save the video for possible future use. Thanks Leila!

@vinodina5504 4 жыл бұрын

OMG! This is unreal.. Awesome👌

@haashini10031985 4 жыл бұрын

Wowwwweww. As always, an other awesome learning video... ! Supercool.

@TalhaKhan22 4 жыл бұрын

The way you explained is very simple and easy. Thank you

@abobobo943 4 жыл бұрын

Very good and clear explanation as usual. Thank you very much.

@alicogurcu4735 4 жыл бұрын

Thank you very much for this great video. I wonder can we use this function to write delivery note info that each reference and quantity then we read each barcode with barcode reader and so we transfer this delivery note to our computer. Is this possible?

@tha2irtalib343 4 жыл бұрын

Great & helpful , thanks Leila & Pete .

@victortomno8321 4 жыл бұрын

Dear Leila, you have done a wonderful job in showing us that it is possible to generate a barcode by use of Excel. I have also tried to prepare one like that, I only stopped at the point where you needed to link with VBA array.

@aparetix 4 жыл бұрын

Thank you Pete and Leila

@mcd22630 4 жыл бұрын

Think I speak for many when I say, what we really want is a video of you cooking using the Chipotle Honey Barbecue Sauce recipe. A hearth felt thank you to Pete and yourself on your explanation of bar codes.

@LeilaGharani 4 жыл бұрын

Fortunately for everyone the bottle is already empty :)

@h.1899 4 жыл бұрын

Awesome you and awesome Pete!!! 😊 loving vba more and more everyday

@LeilaGharani 4 жыл бұрын

Pete is the best!

@akshaygarg4151 4 жыл бұрын

Nice to see that this is possible in excel, as we all know there are multiple ways tof doing same thing excel, this can be done by using V lookup function also as in that way we dont need to run any of the macro

@sofiafredriksson7041 4 жыл бұрын

Wow, you're really something Leila! I never thought this was possible. I will try it immediately!

@hamadkhan7608 4 жыл бұрын

Let me know if you successful..

@alfarhangroup505 4 жыл бұрын

Most great one I do like ur way in explaining the formula. Best wishes

@bijaysharma6068 4 жыл бұрын

Awesome as always!

@tomspallone1868 3 жыл бұрын

PERFECT presentation! Wow!!!!

@vida1719 4 жыл бұрын

That's cool. Thanks for sharing

@KallunWillock 4 жыл бұрын

Thank you, Pete! This is excellent! Thank you Leila for the helpful explanation!

@LeilaGharani 4 жыл бұрын

Pete is great! Glad you like it.

@petemenhennet9792 4 жыл бұрын

Very welcome.

@reanexcel8618 4 жыл бұрын

great work, i love it

@pakeezainstitute 4 жыл бұрын

Excellent Work Dear ,, i'm Really impressed your work

@odel_leal 4 жыл бұрын

This is great idea. Congratulations

@mspetak1290 4 жыл бұрын

Thanks for sharing. Never would have thought that you can do this in excel. Amazing!x Subscribed.

@LeilaGharani 4 жыл бұрын

Glad to have you here!

@raja.mubbasshir9072 4 жыл бұрын

Really a cool gadget! Thank you Leila and Pete!

@LeilaGharani 4 жыл бұрын

Our pleasure :)

@exceltech1076 2 жыл бұрын

Very Good Tutorial . I like it.

@kapitanknuthansen488 3 жыл бұрын

AWESOME INFOs AND VIDEO

@coffeecuppepsi 4 жыл бұрын

This is amazing i had no idea Excel could do this

@MrDanielduranc 4 жыл бұрын

Wonderful, I Love the way that you explain everything. Your are the best!!!

@LeilaGharani 4 жыл бұрын

Thank you for the kind feedback Daniel.

@MrDanielduranc 4 жыл бұрын

@@LeilaGharani 😍😍😍😍😍😍😍

@costaylor6305 4 жыл бұрын

That's was great Thanks

@6tmj79 4 жыл бұрын

Thanks! Great work!

@goharkhan2101 4 жыл бұрын

Amazing thanks Leila

@spfspf2166 4 жыл бұрын

Tanks Leila and Pete!

@steverolfe63 3 жыл бұрын

I'm wondering how I could use this on some existing data please? For example, I have two columns of information - Name and Part Number. How could I pipe these into this spreadsheet to end up with a third column that had the barcodes for column a & b that I can then print out on a barcode printer?

@franknicaragua 4 жыл бұрын

Simplest barcode ever: Download Code39 true type font. Install it. Now you have a new font in your programs. Go for example to Excel. Write something in a cell. Create a formula that concatenate an asterisk&what you write&an asterisk (eg.. *hello*) Change the default font in this cell to Code39. Voila! (note: the asterisks tell the scanner where the real text starts and ends). This font is available in any program (excel, powerpoint, word, etc)

@matchstickdesignco 4 жыл бұрын

Been doing it that way for 15 years.

@petemenhennet9792 4 жыл бұрын

But the point was to learn how to use VBA ......

@eunseoklee3471 4 жыл бұрын

I really like your channel. Keep up the GREAT WORK always!

@LeilaGharani 4 жыл бұрын

I'll do my best Henry :)

@vivekphadke16 4 жыл бұрын

Thanks a lot, very useful

@valueStocks 4 жыл бұрын

Very interesting. Thanks.

@Tuhin360 4 жыл бұрын

That is good video.. helpful

@stevenkaiellie5821 4 жыл бұрын

Well understood, thanks.

@darrylcampbell4426 4 жыл бұрын

I follow your videos because I love Excel, but this is the first time you've taught me something I didn't already know. Amazing!

@LeilaGharani 4 жыл бұрын

Finally! I was almost running out of ideas :)

@darrylcampbell4426 4 жыл бұрын

@@LeilaGharani Haha! Apologies if I sounded patronising, I didn't mean to. I just really love Excel and so spend quite some time playing with it! Perhaps some videos on game programming for those downtime moments? Or maybe that defeats the theme of productivity this channel emanates! :D

@LeilaGharani 4 жыл бұрын

Haha, no worries! It's great to have you here. What is a downtime moment :)

@darrylcampbell4426 4 жыл бұрын

@@LeilaGharani Guffaw. You run a tight ship I see

@HamidurRahman 4 жыл бұрын

Great , that's also helpful :)

@TYoung023 3 жыл бұрын

Wow. Looks exactly like something I would do. Recreating the wheel in Excel just because I can! I’ll probably be recreating this as well with a few updated functions (LET for example).

@pushpajchougule8316 4 жыл бұрын

Glad to know how barcodes are actually generated. Had to admit some part of the video has gone above my head 😂 but i am gonna take another look and also review the worksheet. Thanks Leila and Pete. You guys rock!

@LeilaGharani 4 жыл бұрын

It took a while for it to sink in for me too :)

@adminleader6330 4 жыл бұрын

THANKS FOR THE INFORMATION 👍😊

@wbarker1305 11 ай бұрын

Always enjoy your videos and tips. This one was particularly interesting (and yes, fun!)

@LeilaGharani 11 ай бұрын

Glad you enjoyed it!

@9102010 4 жыл бұрын

Thank you :) excellent

@Holt196 4 жыл бұрын

THIS IS SO COOL

@junaidali1252 2 жыл бұрын

U r the best Teacher Leila, ur style of teaching is marvelous ur accent of talking is very nice as u r nice too. Thanks my Teacher.

@kangsungho1752 4 жыл бұрын

Genuinely Creative!

@SampathKumargv 4 жыл бұрын

Thank you very useful

@yurd563 4 жыл бұрын

Thanks for video!

@amilcarc.dasilva5665 4 жыл бұрын

Thanks a lot Leila. It's really great to follow your video tutorial. It is superb

@LeilaGharani 4 жыл бұрын

Thank you for following Amilcar!

@barcodeBoy666-Barcoded 4 жыл бұрын

Nice Video, thanks !!

@BillingSoftwareGuru 3 жыл бұрын

very nice information

@skulz66 4 жыл бұрын

very cool! thanks

@kcinplatinumgaming2598 4 жыл бұрын

Good demo, I actually designed 3of9 barcode generator around 10 years ago for my self and a retail store in Manchester it was quite a powerful program had many features print labels, design a templates even read barcodes and processed stock barcodes too for stock control ect, designed in VB6 its nice to see people still developing source within VBA as most of the coding now is within Python, C# ect -- good job Peter..Nice demo Leila

@LeilaGharani 4 жыл бұрын

Wow, that sounds like a great application.

@HypeHyphen 4 жыл бұрын

Awesome!

@newkiddgames6322 4 жыл бұрын

I use barcodes in Excel all the time. The difference is mine is a "barcode" font that I down loaded and you have to put an "*" before and after the word/number. So my formula is very very simple. ="*"&A1&"*" A1 can be any cell.

@appliancetraining 4 жыл бұрын

Genius. Just what I needed. Thanks

@appliancetraining 4 жыл бұрын

Something is weird, I got it to work great, but.. if I click in the cell with your formula, sometimes the formula becomes the barcode , rather than what’s in A1. Any thoughts? Thanks. For your help

@donovanlucibello379 3 жыл бұрын

Simple but elegant!

@Hardiknandha 4 жыл бұрын

Quite Interesting Stuff!!! 📈

@harpreetmoney 2 жыл бұрын

Thank you for sharing such an informative video

@LeilaGharani 2 жыл бұрын

My pleasure.

@DougHExcel 4 жыл бұрын

Smokingly great video! Excel can do (almost) anything.

@stewartshriver1008 2 жыл бұрын

Thanks Pete.

@duncanx99 4 жыл бұрын

Excellent!!!

@sivakrishna478 4 жыл бұрын

Amazing madam. Very very helpful video. You are redefining the way of doing work and business. Thanks for sharing the same

@mmci1525 4 жыл бұрын

Cool system for American 12 digit codes, great way to see people learning how the check digit is calculated, and not just a random number.

@saberchou2525 4 жыл бұрын

Thank you, Fabulous Leila.

@mr.gardengreen7124 3 жыл бұрын

Awesome Ms. Leila.. very informative

@LeilaGharani 3 жыл бұрын

Thank you! 🙂

@ChandanSomani 4 жыл бұрын

Really thank to Pete

@neilvanrooyen7196 4 жыл бұрын

Thanks for the Guide... Used what was provided as a reference and did it all with only formulas and no VBA.

@AbhishekTripathidce 4 жыл бұрын

Thank you LG and also Pete for sharing this nice secrete of bar code.

@LeilaGharani 4 жыл бұрын

Our pleasure :)

@ronvds4713 4 жыл бұрын

Thanks for sharing

@xenon2106 4 жыл бұрын

Nice. 👌🏻 Love it. Thank you for sharing. Thumbs Up Pete. 👍🏻

@AZMDKN 4 жыл бұрын

Very useful

@harishnebhwani4255 3 жыл бұрын

Ameging, good work , god blessed you

@bakthapuri 4 жыл бұрын

You are awesome always Leila....

@denislyons98 3 жыл бұрын

GREAT JOB!!!!!

@LeilaGharani 3 жыл бұрын

Thanks!