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/
@KeithMorrisonSr
2 ай бұрын
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!
@TheVirtualArena24
2 ай бұрын
Finally Kevin came back in his original form
@noorSalem-oq3dv
2 ай бұрын
Nice
@ziyadcomputer
2 ай бұрын
yes
@pjohn1435
2 ай бұрын
Once again Kevin, you've done it, this will be helpful soon for our small business. Thanks again, Kevin. Keep up the wonderful work.
@KevinStratvert
2 ай бұрын
Glad it was helpful!
@roaringlegend456
2 ай бұрын
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
@alphajorbarrie2535
2 ай бұрын
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?
@randyriegel8553
2 ай бұрын
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.
@DigitalMindQuest
2 ай бұрын
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.
@noelfrancisco5778
2 ай бұрын
Great tool, I learned something new today. Thanks :)
@JuJackMarketingCompany
2 ай бұрын
I needed to learn this. THANK YOU!!
@KevinStratvert
2 ай бұрын
Glad it was helpful!
@bashirwarraich1107
Ай бұрын
Excellent and easy to learn
@MuhsinTechnicalengineeringserv
2 күн бұрын
Your The best ever Non comparable
@Dip_Bandopadhyay
2 ай бұрын
Thanks for updated us ❤
@djmojolosangeles8190
2 ай бұрын
Awesome video Kevin, thank you!
@jkontosgr
2 ай бұрын
Great video! Kevin congrats 🎉
@derekduckitt5900
2 ай бұрын
A lot of good tips here, many thanks!
@KevinStratvert
2 ай бұрын
Glad you enjoyed it!
@jcj6892
2 ай бұрын
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.
@djmillen2010
2 ай бұрын
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?
@Zerosandones-dy7lb
2 ай бұрын
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?
@AtractivoPhotography
2 ай бұрын
Outstanding video, Kevin!
@Saintor1
2 ай бұрын
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!
@tube-master
2 ай бұрын
Interesting, not easy but a great function to be used in many situations 👌
@Osmanmaani4
2 ай бұрын
Thanks
@sayedajmalsadat
2 ай бұрын
Cool feature, thanks Kevin for the video.
@KevinStratvert
2 ай бұрын
Any time!
@technousr
2 ай бұрын
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?
@KevinStratvert
2 ай бұрын
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.
@drhoward81
Ай бұрын
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?
@nkechiizeji
2 ай бұрын
Nice one. What of barcoding in Microsoft word and PowerPoint?
@ranbirjaiswal
2 ай бұрын
Awesome kevin
@amilaimesh
2 ай бұрын
Great stuff, Kevin
@feidie64
2 ай бұрын
Love it! Thanks!
@Milkex
2 ай бұрын
Came for the Cuisinart break maker review, stayed for the Excel barcode generation guide
@abrahamjbah
2 ай бұрын
Miss your videos, I look at them even if am not interested in what you are teaching 😂.
@tinab9572
Ай бұрын
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 :-) :-)
@UmarAlFarooq
2 ай бұрын
Wow! Great tip Kevin! Thank you!
@Salah_-_Uddin
Ай бұрын
I will do it.
@alaaldinalqaisi8801
2 ай бұрын
How to scan these QR codes for taking an event attendance on a google sheet?
@smarthelpguides
Ай бұрын
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.
@afwak.we.redak7
Ай бұрын
@@smarthelpguides B
@asquithia
2 ай бұрын
Great thanks
@KevinStratvert
2 ай бұрын
No worries!
@ArifAhmed-ve9fq
Ай бұрын
Hello Kevin. Thank you for your tricks but I do not have IMAGE on the Dialogue box, how to bring it, please advice
@WaqasAli-dq9wg
2 ай бұрын
Would it generate the barcode for 4131 active inventory number?? Happy barcoding 😁
@KevinStratvert
2 ай бұрын
Give it a shot 😉
@noreddinemadi7645
2 ай бұрын
thanks
@wensex2008
2 ай бұрын
Thank you
@gayansamarasekara
2 ай бұрын
Splendid...!
@roaringlegend456
2 ай бұрын
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
@AO_theMAN
11 күн бұрын
Hey Kevin, what version of Excel did you use in this video and in all your videos?
@kebbitechzone9835
2 ай бұрын
Nice boss
@agouveia19
18 күн бұрын
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..
@nawoyskifamily8875
13 күн бұрын
I am receiving the same message.
@Toyly-w6f
13 күн бұрын
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
@rcsontag
21 күн бұрын
Instead of the barcode, Excel posts the word "Blocked" in the cells. What's going on?
@sphericon
2 ай бұрын
I love QR code
@asnyaka
2 ай бұрын
Awesome Kevin!
@Mx81
2 ай бұрын
I would not use „free“ online tool … you never know what they are doing with that data.
@Eternal_Tech
2 ай бұрын
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.
@NewChapterMan
6 күн бұрын
Is there an app which will be able to decipher barcodes?
@hersheyrulz2
2 ай бұрын
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.
@KevinStratvert
2 ай бұрын
Fair point! Thanks for calling that out!
@Ringo_Lin
2 ай бұрын
That's so great!
@alexorozco453
15 күн бұрын
hello no image
@arlenysceballo
Ай бұрын
Love it!
@ucan1
2 ай бұрын
If this video goes viral, my comment is gonna go viral
@user-te2qg7tw7d
2 ай бұрын
Kevinがカッコよくなってる
@KJ-zr2ko
2 ай бұрын
Where do you get the URL from if I'm putting in a ISBN number?
@noorSalem-oq3dv
2 ай бұрын
Create Barcode in Free like Subscribes 👍 thank you
@ziyadcomputer
2 ай бұрын
give me a video of how to use Google vids🙏
@natozeleo7579
2 ай бұрын
Hai Kevin ...I need demo on geocode
@ayufan3
Ай бұрын
Nice.....👍👍👍
@BasBruijnis
2 ай бұрын
Hi, is it possible to set the size also?
@KevinStratvert
2 ай бұрын
Yes! Simply adjust the cell size and that’ll in turn affect the barcode size.
@Kingoffreefire380
29 күн бұрын
Hi
@SportsHunterArea
2 ай бұрын
Create a video on click item picture add value or price to total Like click on pizza picture 🍕 add value or price
@Toyly-w6f
13 күн бұрын
Please help me
@bartsanders1553
9 күн бұрын
I have yet to find a barcode font that doesn't require purchasing. Google is crap. Just an advertising platform. Nothing else.
@bartsanders1553
9 күн бұрын
And I can say that this was zero help as well. Everything is being guarded by gate keepers and requires purchases.
@multidao
2 ай бұрын
For god's sake, just install a free barcode font and use it.
@RichardAgyapong-dh2yg
4 күн бұрын
Just be thankful
@MobileGamerDude
8 сағат бұрын
This is much easier
@Jack-vo7ld
Ай бұрын
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 🙂
@NinaBentley-ll6un
28 күн бұрын
he goes way too fast.
@solostarmlan
2 ай бұрын
Kelvin here again
@amkotler
2 ай бұрын
I clicked the URL in the description and I got an error page.
@Eternal_Tech
2 ай бұрын
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.
Пікірлер: 94