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/
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
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 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.
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.
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.
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.
This tip saved me a lot of headaches. Thank you! Is there a way to print the barcode without the text underneath it? Do you have a video showing how to create a form in excel that can be printed as a label?
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?
Hi @Kev Awsum presentation and in appreciation. For inventory management, of (for example) your data set, how would I go about it to link the bar code to a mobile device which will track the items counted, brought into stock or taken out of stock (sold)? Thank you in advance and I do enjoy your teachings. Blessings
Hi! Thank you for all the video's, they help a lot! I downloaded your workbook and did the exact steps you did, but in the colum of the barcode I get the message 'blocked'.. do you know why I''m getting this error code? I can't figure it out..
Hello Kevin, I want to start a barcode inventory control system for my small part time business. Could you tell me the best way to achieve this possibly with a 365 subscription?
Hi Kevin, just what I was after .... but I would liek to improve a little: the readable text under the barcode is the barcode type and the value but concatenated eg "code39value". Don't really need to see the barcode type, or at least have space between between tthem. Can you tlel me how to do that please? Thanks :) .
Hey guys, and thanks for the video buddy. Since i haven't got the newest excel version and can't use api's at my office pc, i did it another way. wit a vba scribt and the font code128. pretty neat actually. so you're not dependent on the api. you can also do this as a excel formula. if any of you are interested, you can tell me
Thank you Kevin, another great learning video 😅 as you mention it could be great, if you could make a video that can show how your Kevin Cookies company make a store with an inventory of your cookies and scan each products Barcode and count down the selling items from your store inventory . Thank you :-) :-)
First off. Wow saved tons of time. But came back to the spreadsheet to add more UPC numbers. Now the image generating is in a different format than original UPC-a in the formula/api line. Everything remains the same in the formula cell except the cell address. Any ideas?
I guess I didn't understand. Now that I have made those barcodes, I want to stick them on my moving boxes, and type into my excel table what I place in each box. I can't figure out how I then scan the barcode (I want to do that with my phone)
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.
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.
Hello Kevin, thank you for your great tip and trick but please speak a little bit slower. You are too fast for people don't use to speak English everyday like you 🙂
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/
This is really helpful
Thanks!
I thoroughly enjoy your content. It’s incredibly informative and easy to understand and comprehend.
Finally Kevin came back in his original form
Nice
yes
OMG I'm doing your course at Udemy due to my work trained and can't believe you're at TH-cam! You are such a great instructor!
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
What a good and educational video, but do I need an Office key to better optimize my Excel?
It's the best you can do but better performance
and where can I find it where it is safe and effective
You can check several places but I got it from BNH Software if you want something specific
I know there are several but I wanted to know about one in particular to start with. Thanks.
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!
Kevin, you saved my day with this tutorial! Thank you and more power to you :)
Thanks for updated us ❤
Great video! Kevin congrats 🎉
Awesome video Kevin, thank you!
Great tool, I learned something new today. Thanks :)
This is fantastic information, and you did an outstanding job teaching it!
A lot of good tips here, many thanks!
Glad you enjoyed it!
Thanks. You saved my life.
OMG -> Its amazing and very easy, best video. thanks for sharing :)
I needed to learn this. THANK YOU!!
Glad it was helpful!
Excellent and easy to learn
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.
Outstanding video, Kevin!
Top Top. Love it. Thanks for helping me.
Cool feature, thanks Kevin for the video.
Any time!
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.
I am actually mind blown ! Wow
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?
Wow! Great tip Kevin! Thank you!
Thanks
THANK YOU SO MUCH THIS VIDEO IS SO MUCH HELPFUL FOR ME TO SOLVE OUR SOLUTION AND PROBLEMS
Interesting, not easy but a great function to be used in many situations 👌
Love it! Thanks!
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.
Great stuff, Kevin
Nice one. What of barcoding in Microsoft word and PowerPoint?
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.
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!
This tip saved me a lot of headaches. Thank you!
Is there a way to print the barcode without the text underneath it?
Do you have a video showing how to create a form in excel that can be printed as a label?
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?
Hi @Kev
Awsum presentation and in appreciation.
For inventory management, of (for example) your data set, how would I go about it to link the bar code to a mobile device which will track the items counted, brought into stock or taken out of stock (sold)?
Thank you in advance and I do enjoy your teachings.
Blessings
Your The best ever
Non comparable
Thanks Kevin for this tutorial, very helpful. Quick question, how can I get a UPC code?
Great thanks
No worries!
Thank you
Hey Kevin, what version of Excel did you use in this video and in all your videos?
Hello Kevin. Thank you for your tricks but I do not have IMAGE on the Dialogue box, how to bring it, please advice
Hi! Thank you for all the video's, they help a lot!
I downloaded your workbook and did the exact steps you did, but in the colum of the barcode I get the message 'blocked'.. do you know why I''m getting this error code? I can't figure it out..
I am receiving the same message.
Hello Kevin, I want to start a barcode inventory control system for my small part time business. Could you tell me the best way to achieve this possibly with a 365 subscription?
Instead of the barcode, Excel posts the word "Blocked" in the cells. What's going on?
same :/
Hi Kevin, thank you 🙏🏿 so much for this tutorial. May I ask, can this technique be adapted for use with Google sheets? Thanks in advance.
Hi Kevin, just what I was after .... but I would liek to improve a little: the readable text under the barcode is the barcode type and the value but concatenated eg "code39value". Don't really need to see the barcode type, or at least have space between between tthem. Can you tlel me how to do that please? Thanks :) .
thanks mister
Miss your videos, I look at them even if am not interested in what you are teaching 😂.
Awesome kevin
I need a QR for a series of numbers row. How to do?
will this work with shopify?
Legend thanks for this :D
Hey guys, and thanks for the video buddy. Since i haven't got the newest excel version and can't use api's at my office pc, i did it another way. wit a vba scribt and the font code128. pretty neat actually. so you're not dependent on the api. you can also do this as a excel formula. if any of you are interested, you can tell me
Is there an app which will be able to decipher barcodes?
Thank you Kevin, another great learning video 😅 as you mention it could be great, if you could make a video that can show how your Kevin Cookies company make a store with an inventory of your cookies and scan each products Barcode and count down the selling items from your store inventory . Thank you :-) :-)
WOW! Amazing ..
Does this work for google sheets?
Nice.....👍👍👍
Awesome Kevin!
I will do it.
First off. Wow saved tons of time. But came back to the spreadsheet to add more UPC numbers. Now the image generating is in a different format than original UPC-a in the formula/api line. Everything remains the same in the formula cell except the cell address. Any ideas?
How to scan these QR codes for taking an event attendance on a google sheet?
you can direct them to a form to submit their name or less reliable method will be to check no of visits to the qr code url.
@@smarthelpguides B
Came for the Cuisinart break maker review, stayed for the Excel barcode generation guide
Nice boss
How do you write upc can you answer me please?
I love QR code
Splendid...!
That's so great!
Kevinがカッコよくなってる
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.
Hi Kevin. When I write January 2023 in a cell like in your and when I hover down. Months are changed but in my case years are changed
how can i print these barcode?
hello no image
I guess I didn't understand. Now that I have made those barcodes, I want to stick them on my moving boxes, and type into my excel table what I place in each box. I can't figure out how I then scan the barcode (I want to do that with my phone)
Where do you get the URL from if I'm putting in a ISBN number?
cant see image option
Hi, is it possible to set the size also?
Yes! Simply adjust the cell size and that’ll in turn affect the barcode size.
Love it!
Hai Kevin ...I need demo on geocode
I can’t scan the barcode.
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.
I dont have Image suffix
If this video goes viral, my comment is gonna go viral
But this video has 122k views and your comment only has 24😂
Create Barcode in Free like Subscribes 👍 thank you
Awesome
give me a video of how to use Google vids🙏
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!
Would it generate the barcode for 4131 active inventory number?? Happy barcoding 😁
Give it a shot 😉
Yeah… but how to download it to you computer?
Hi
I have yet to find a barcode font that doesn't require purchasing. Google is crap. Just an advertising platform. Nothing else.
And I can say that this was zero help as well. Everything is being guarded by gate keepers and requires purchases.
Create a video on click item picture add value or price to total
Like click on pizza picture 🍕 add value or price
Please help me
Nifty
For god's sake, just install a free barcode font and use it.
Just be thankful
This is much easier
Ahmed
Hello Kevin, thank you for your great tip and trick but please speak a little bit slower. You are too fast for people don't use to speak English everyday like you 🙂