How to Create Barcode in Excel - FREE & No Install
Вставка
- Опубліковано 27 чер 2024
- In this step-by-step tutorial, learn how to make barcodes in Microsoft Excel, and the best part is, it's completely free and you don't even need to install anything. Follow along whether you're using the Excel desktop version or Excel for free on the web. Whether you're managing inventory or just want to learn something new, this guide will make barcoding a breeze.
Host: Kevin Stratvert
📚 RESOURCES
- Workbook Download Link: 1drv.ms/x/s!AmxrofZZlZ-whdxlh...
- URL for Free Barcode API: barcodeapi.org/api/auto/
- Excel on the Web: excel.new
⌚ TIMESTAMPS
0:00 Introduction
0:37 Format cells
1:45 Insert barcode with image function
5:24 Generate different barcode formats
8:04 Generate QR code
9:00 Wrap up
📺 RELATED VIDEOS
- Playlist with all my videos on Excel: • ❎ How to use Excel
📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter/
🔽 CONNECT WITH ME
- Official website: www.kevinstratvert.com
- LinkedIn: / kevinstratvert
- Discord: bit.ly/KevinStratvertDiscord
- Twitter: / kevstrat
- Facebook: / kevin-stratvert-101912...
- TikTok: / kevinstratvert
- Instagram: / kevinstratvert
🎁 TOOLS AND DISCOUNTS
✅ 🎙️ Voicemod AI Voice Changer | 5% off | link.xsolla.com/KZBi89AY
✅ 🌐 Squarespace Websites | squarespace.syuh.net/XYaqYM
✅ 🔍 Grammarly | grammarly.go2cloud.org/SH3nL
✅ 📹 CapCut | bit.ly/installcapcut
✅ 🛍️ Shopify | shopify.pxf.io/XY9rPa
✅ 📋 Notion | affiliate.notion.so/rffva4tr71ax
✅ 🖼️ Figma | psxid.figma.com/lqjg97licpry
✅ 🤖 ElevenLabs Text-to-Speech | try.elevenlabs.io/taqepq60mptr
🎒 MY COURSES
- Go from Excel novice to data analysis ninja in just 2 hours: kevinstratvert.thinkific.com/
🙏 REQUEST VIDEOS
forms.gle/BDrTNUoxheEoMLGt5
🔔 SUBSCRIBE ON UA-cam
ua-cam.com/users/kevlers?...
🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: amzn.to/3kCP2yz
⚖ DISCLOSURE
Some links are affiliate links. Purchasing through these links gives me a small commission to support videos on this channel. The price to you is the same.
#stratvert #excel #barcodes - Наука та технологія
Go from Excel novice to data analysis ninja in just 2 hours: kevinstratvert.thinkific.com/
Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter/
Finally Kevin came back in his original form
Nice
yes
Thanks Kevin! Always great learning from you and your clear and perceptive delivery! I am trying to create DYNAMIC QR codes without having to be extorted by the QR code companies. Do you have a tutorial on how to do that? I really appreciate it!
I needed to learn this. THANK YOU!!
Glad it was helpful!
Outstanding video, Kevin!
Thanks for updated us ❤
Great video! Kevin congrats 🎉
Awesome video Kevin, thank you!
Hey man, I've really been enjoying your tutorials! They're clear, concise, and very helpful. I was wondering if you might consider creating a video on how to extract data from complex PDFs.
I know you already have some videos on PDF data extraction, but if you're comfortable tackling a more intricate example, I think it would be fantastic to see your process in action.
Great stuff, Kevin
Great tool, I learned something new today. Thanks :)
I would love a follow up video showing how to use the barcodes after they’ve been generated.
Specifically, a fun idea I had was to generate a QR code for a yard sale sign with a date and time… silly, I know lol. But the end user needs a way to retrieve the information.
You can type in a physical address that can be opened up in your favorite maps app, but it won’t include additional information like the nature of the event.
Does this have to connect to a paid service or URL with the info? Or could you have your own mini home server or database that you could use for keeping track of what you’ve stored in boxes etc? There are a lot of cool possibilities.
Love it! Thanks!
Wow! Great tip Kevin! Thank you!
Once again Kevin, you've done it, this will be helpful soon for our small business. Thanks again, Kevin. Keep up the wonderful work.
Glad it was helpful!
If you ever plan to expand your business or plan to sell your products in other stores, you might want to read on how Upc barcode numbers are asigned so you don't run into issues in the future
Awesome kevin
Please sir, answer this question: Is it still worth it to learn web development (HTML, CSS, and JavaScript) in this age of AI, or what would be your advice to someone who wants to make a career in the tech industry?
I would not use AI until you learn the language yourself. You won't learn anything and most likely the AI code will not work as expected. I've been a software engineer for 20 years. AI is a nice tool if you already know the language to get a baseline. I had an C# application when ChatGPT came out and one method had really intensive calculations. So I had ChatGPT spit out the code of that method. It worked. Put both on a benchmark and my manually written code was faster and used less memory than the AI generated. If you don't know coding and depend on AI you will get bit in the ass.
Hi Kevin I love to learn from you,thank you.
Can you make a tutorial on creating a payroll with some skills and shortcuts,and how to pay staff?
A lot of good tips here, many thanks!
Glad you enjoyed it!
Thanks
Cool feature, thanks Kevin for the video.
Any time!
Awesome Kevin!
Interesting, not easy but a great function to be used in many situations 👌
Thank you
Great and easy solution in Excel. I tried on MS Access reports but didn't find a way to make it work yet. Hopefully it works there too!
Came for the Cuisinart break maker review, stayed for the Excel barcode generation guide
Nice boss
That's so great!
thanks
Miss your videos, I look at them even if am not interested in what you are teaching 😂.
Great thanks
No worries!
Splendid...!
Nice one. What of barcoding in Microsoft word and PowerPoint?
I love QR code
Would you be able to append a quantity to the code as well? For instance, you have an order for 5 cookies and type that in a quantity column, so when you create a barcode for the cookies, it would automatically scan that you need to charge for 5 cookies?
Kevin when using the api, does the UPC have to be a valid code for it to work or will it generate any code you give it? In addition, will it also provide any names of the associated products if they need to be pre-existing UPC codes?
There are certain rules for barcode types (eg upc needs to be 12 digits long and include a check digit at the end). If you specify upc but provide more digits, you’ll get an error. There’s no lookup function for existing products.
Kevin, while I do understand that you and others are visual only people, there are many people who do need something like alternative text (alt text) so it would be great if you hadn’t just glazed over that field as being optional without even calling it out. You have a platform here that could help those learning how to do these tasks to be more mindful of others needs. I’m not saying you have to do a lesson on alt text, but it would’ve been great if you had at least acknowledged its existence.
Fair point! Thanks for calling that out!
Kevinがカッコよくなってる
How to scan these QR codes for taking an event attendance on a google sheet?
Where do you get the URL from if I'm putting in a ISBN number?
I would not use „free“ online tool … you never know what they are doing with that data.
What data does the barcode site actually obtain? It seems like they would certainly get the code (numbers) and they would know your IP address. However, unless they gain access to the spreadsheet itself, it does not seem like a security or privacy risk.
Hai Kevin ...I need demo on geocode
give me a video of how to use Google vids🙏
Hi, is it possible to set the size also?
Yes! Simply adjust the cell size and that’ll in turn affect the barcode size.
Create Barcode in Free like Subscribes 👍 thank you
Create a video on click item picture add value or price to total
Like click on pizza picture 🍕 add value or price
If this video goes viral, my comment is gonna go viral
For god's sake, just install a free barcode font and use it.
Kelvin here again
A little information on barcodes upc
0 Number system number
1
2
3 Company/Manufacture #
4
5
6
7
8 Item number
9
0
5 Check digit
The company number(6-9 long) and item number can overlap (1-5 long). Also, the number system number is also considered the company number
I kinda infuriates me the all you upc have different company numbers when this example is one company, but I know it's an example
Would it generate the barcode for 4131 active inventory number?? Happy barcoding 😁
Give it a shot 😉
I clicked the URL in the description and I got an error page.
In order for the URL API to function, it needs to have the barcode number appended to it in the manner Kevin demonstrates in the video.