Thank you so much Neren. I always appreciate your comments and feedback and I am glad you like this one as well. Next week I will be adding barcodes and product pictures so you won't want to miss it.
I am not a novice in Excel, but I still learn new things with your courses. Thanks. I like this label creator. Normally I use Word mailmerge with an Excel datasheet. This has the advantage, that every entry can have its own format (font, font size, colouring, bold, italics) etc. In the first episode it doesn't seem to work. And not all the font colors are transmitted to the labels; I don't know why. Furthermore, I would like to see an automatic font size decrease when a text box is longer than the label width so it still fits on the label. This is always a problem with any label creator. Wrapping is often causing a problem that the bottom textboxes are (re)moved from the label. These are just some ideas, you, me and others have to struggle with. Nevertheless, thank you for this presentation.
Hello Bert, Thanks very much for your comment. When applying formulas to a shape, the shape takes on the cell formatting, basically losing the formatting that was applied. (Labels works however the data does not) In Part 2 we solve this issue so that all formatting gets copied over again. I will work with the wrap text issue and see if we can solve more of these issues. Thanks very much for your feedback.
thank you very much Mr Randy Austin these magical videos are very helpful this video training able me to make my monthly fee slips for students of my schools it will save my time thanks once again
That is great to hear Arshad, I am really glad you find it helpful. You can also print student ID cards (Part 2 has pictures in it so make sure you catch next weeks episode)
Thank you so much Alexander, make sure to catch next week's Part 2 where I add bar codes and pictures to labels (Link will be live on this Tuesday, but here it is for you to set the reminder: ruclips.net/video/NQ1OY97Ho3c/видео.html
This looks amazing, I have been struggling with a very clunky Word mailmerge and vba to create labels, from an excel db. Some things I would like to see that I have on my word doc: A date textbox on the label choosing either Today() or a date from a cell A Serial Number textbox so each label has an incremental serial default fro 001 or from number entered in a cell A way to save the label design, my first idea is to group and hide the created label and give option to use when creating new label
H Lanser, thanks very much for your comment and ideas. 1. I think the best way to add a date textbox would be simply to add it to your original data, this way you can also include formulas such as Today() or any other date-based formula. 2. Just as with the date, Excel can handle incremental serial #'s inside the data but also outside. Within the macro there is a variable called "LabelNumber" this keeps track of the label numbers and could easily be place on the label itself with just an extra line of code. 3. A way to save the design is a great idea and one I had thought of. If enough people want this, I may add it in week 3, however so often as i do more parts to these application the interest and viewers drop, so hopefully more people want this as I think it would be fantastic to choose from multiple label templates that have been previously created, and would save a lot of time having to re-design the same label again. Thanks so much for the great comments and ideas.
A nice little tool you are developing here, one thing I was wondering when you imported the data and then generated the labels it made a single label for each set of information. is it possible to add a feature to print multiple of the same label ranging from one or two up to a full sheet of labels with the same information on each label? Thanks a bunch and keep making the great vids.
Hi Joshua, thanks for your comment and I am glad you like the training. For sure that is possible, it would only require small modifications of the code, or a database with the exact same details on each row. Make sure you watch Part 2 next week where I go into details on how to create the labels and label sheet, along with adding bar codes and pictures.
I was wandering, as future tax accountant in our 250 files in Excell, which topic/videos should be use as a tax accountant? waiting for your reply, hope you notice me.. Thanks bro Randy😊❤️
Hi and thanks so much, I would say at least 100 of the 250 templates within that pack can be used by an accountant. Please also check out my Accounting In Excel playlist on RUclips for specific videos and corresponding workbooks. ruclips.net/video/Js4pQR2ASsM/видео.html I hope this helps and thanks so much.
@@ExcelForFreelancers Thanks for reply bro Randy, sorry for the noob questions, I am just a noobie in taxation, not yet taking taxation as subject, just advanced study to be a pro just like you🙏❤️
This is an awesome training. I think it would also be useful for people who wanted to purchase card stock and create business cards. Can an option be added to create business cards and allow you to design a two sided card? Since you want to add the option for adding pictures is it possible to layer the pictures with one being like a watermark in the background so your business card could have a design?
Hi great ideas and I am glad you like the training. With the label database sheet you can add any label size or type that you want, to the possibilities are limitless. Also in part 2 I show you how to add 2 different types of pictures. One is a picture, such as a watermark, that would show up on every label, and the other is a product picture, which would be different for every label, based on a file link to that picture in your database. For two sided designs you would simply create two different designs, one for the back and one for the front. Someone suggested to me that a user should be able to save a label design as a template so it can be recalled again, so if there is enough interest I may do this for part 3. Just let me know.
Saving designed cards as templates would be great! Business that use it to make personnel badges could save each employee’s as a template so that badges could be easily replaced when lost or damaged. It might also be useful to incorporate barcodes or QR code’s.
Thanks so much, bar codes, product pictures and misc. pictures are coming next week in Part 2 here: ruclips.net/video/NQ1OY97Ho3c/видео.html I will try to add the ability to "Save Templates" in week three if the interest holds. Thanks so much for the suggestion.
It may be, however I did not find a single source for all of the dimensions, so i just pulled them directly from the Avery site. So any label you want to add, simply add those details to your Label Data table and it will be there forever (as opposed to writing some code to pull the data from word)
Hi Randy, I'm one of your countless fans. Randy can you please make a video on how to make greyed out Text in the TextBox in UserForm in Excel to give the end user a valid information? But as soon soon as End User starts typing something on that TextBox, your greyed out Text will be hidden or deleted. But if he or she deletes the Text he wrote on that TextBox, your Greyed out Text will appear again in that text box. This is similar like we see in the web form. Can it be done in Excel?
Hi the answers are Yes and Yes. It can be done and I have done it. You can find that training here in the Automated Field Names video: ruclips.net/video/CScEzzEhwVs/видео.html Also if you combine this with my Automated Tab order videos you have a very powerful and user-friendly form input. I hope this helps and thanks for the great question.
@@ExcelForFreelancers Wow! Randy you're just awesome. I've never seen a person like you. Can you please teach me Python and SQL from basics to Advanced? I'm really interested to learn them from you. Please give me your phone number. My WhatsApp number is 8777425150. I'm from India.
Hi If you have tried to download this workbook using the links but had a problem please email angeli@ExcelForFreelancers.com . Please supply the email you used along with the workbook you are requesting. Thanks for your patience.
Hi Paul, you can use any data file you want. Import your own data to create the labels. The dynamic nature of this application should allow you to import almost any type of Excel data. Thanks so much. (I also got your question on Messenger too)
I have sent for the FREE Workbook you speak of here, I have received my email but there is no link to the worksheet for this lesson . . . Please, Do you have a link where this Excel worksheet and workbook are . . . Thank You
Hi Mark, please double check the email you got, the title of the email should be "Your Free Excel Label Creator (Part 1) Workbook is Here" and the download link in that email should state the following inside the email: "As promised, you can download your Workbook from the following link: bit.ly/LabelCreatorPt1_WbDl " Many people have downloaded this successfully so as long as you received the correct email it should work. If you still have problems please email me here: Randy@ExcelForFreelancers.com
@@ExcelForFreelancers thank you for your response, my email is titled/ (subject line) "Welcome To Excel For Freelancers" I did just download using your link in this response - Thank you for the link
The Welcome To Excel For freelancers is the Welcome Email you get when you sign up to receive regular emails. If you want any specific workbook, you will have to look in the description of that video. In the description above I have instructions on how to download each workbook. So you will want to go to each video and check the links in the description. Once you click the link, sign up on that individual workbook form, then that email will be delivered, which is different than the one you got.
i have no idea about visual basic and coding n all but i have excel knowledge like all tabs options ,i want to learn this advance level of excel with macro coding. so what do i do first i have to start visual basic?
Hi Kazi, I have a free VBA course taught by MVP Sumit Bansal on my site right here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/
🔥Download 350 Of The Worlds Best Templates Here ► rebrand.ly/350Wkbks_YTPinnedCom
Aww man this presentation should have been called “Printing masterclass!”🧐👍🏻
Thanks so much. I am really glad you enjoyed it Craig
Hi Randy ... WOW brilliant tutorial once again. You never cease to amaze me with the ideas you come up with. Simply awesome and valuable ... thank you
Thank you so much Neren. I always appreciate your comments and feedback and I am glad you like this one as well. Next week I will be adding barcodes and product pictures so you won't want to miss it.
I am not a novice in Excel, but I still learn new things with your courses. Thanks. I like this label creator. Normally I use Word mailmerge with an Excel datasheet. This has the advantage, that every entry can have its own format (font, font size, colouring, bold, italics) etc. In the first episode it doesn't seem to work. And not all the font colors are transmitted to the labels; I don't know why. Furthermore, I would like to see an automatic font size decrease when a text box is longer than the label width so it still fits on the label. This is always a problem with any label creator. Wrapping is often causing a problem that the bottom textboxes are (re)moved from the label. These are just some ideas, you, me and others have to struggle with. Nevertheless, thank you for this presentation.
Hello Bert, Thanks very much for your comment. When applying formulas to a shape, the shape takes on the cell formatting, basically losing the formatting that was applied. (Labels works however the data does not) In Part 2 we solve this issue so that all formatting gets copied over again.
I will work with the wrap text issue and see if we can solve more of these issues. Thanks very much for your feedback.
thank you very much Mr Randy Austin
these magical videos are very helpful this video training able me to make my monthly fee slips for students of my schools
it will save my time thanks once again
That is great to hear Arshad, I am really glad you find it helpful. You can also print student ID cards (Part 2 has pictures in it so make sure you catch next weeks episode)
wauu thanks a lot man I'm from Peru and I think this is fantastic I love your aplications
Thank you so much Alexander, make sure to catch next week's Part 2 where I add bar codes and pictures to labels (Link will be live on this Tuesday, but here it is for you to set the reminder: ruclips.net/video/NQ1OY97Ho3c/видео.html
This is amazing. Thank you so very much Randy. You are the man.
Thanks so much, I am really glad you enjoyed it.
@@ExcelForFreelancers Welcome
Excellent... these videos are very helpful for all..
That is great to hear, I am so glad you enjoyed it.
This looks amazing, I have been struggling with a very clunky Word mailmerge and vba to create labels, from an excel db.
Some things I would like to see that I have on my word doc:
A date textbox on the label choosing either Today() or a date from a cell
A Serial Number textbox so each label has an incremental serial default fro 001 or from number entered in a cell
A way to save the label design, my first idea is to group and hide the created label and give option to use when creating new label
H Lanser, thanks very much for your comment and ideas.
1. I think the best way to add a date textbox would be simply to add it to your original data, this way you can also include formulas such as Today() or any other date-based formula.
2. Just as with the date, Excel can handle incremental serial #'s inside the data but also outside. Within the macro there is a variable called "LabelNumber" this keeps track of the label numbers and could easily be place on the label itself with just an extra line of code.
3. A way to save the design is a great idea and one I had thought of. If enough people want this, I may add it in week 3, however so often as i do more parts to these application the interest and viewers drop, so hopefully more people want this as I think it would be fantastic to choose from multiple label templates that have been previously created, and would save a lot of time having to re-design the same label again.
Thanks so much for the great comments and ideas.
Excellent Training Class Sir I Request you to Please Make Some Video on Excel VBA Class Module
Thanks very much. I will try to do that in the near future.
A nice little tool you are developing here, one thing I was wondering when you imported the data and then generated the labels it made a single label for each set of information. is it possible to add a feature to print multiple of the same label ranging from one or two up to a full sheet of labels with the same information on each label? Thanks a bunch and keep making the great vids.
Hi Joshua, thanks for your comment and I am glad you like the training. For sure that is possible, it would only require small modifications of the code, or a database with the exact same details on each row. Make sure you watch Part 2 next week where I go into details on how to create the labels and label sheet, along with adding bar codes and pictures.
I wish I could as patience as he was 😀
Thanks so much @SMK
I was wandering, as future tax accountant in our 250 files in Excell, which topic/videos should be use as a tax accountant?
waiting for your reply, hope you notice me.. Thanks bro Randy😊❤️
Hi and thanks so much, I would say at least 100 of the 250 templates within that pack can be used by an accountant. Please also check out my Accounting In Excel playlist on RUclips for specific videos and corresponding workbooks. ruclips.net/video/Js4pQR2ASsM/видео.html
I hope this helps and thanks so much.
@@ExcelForFreelancers Thanks for reply bro Randy, sorry for the noob questions, I am just a noobie in taxation, not yet taking taxation as subject, just advanced study to be a pro just like you🙏❤️
No worries. Next week I have a 'Mini Accounting Application' training and download. You Won't Want To Miss This!
This is an awesome training. I think it would also be useful for people who wanted to purchase card stock and create business cards. Can an option be added to create business cards and allow you to design a two sided card? Since you want to add the option for adding pictures is it possible to layer the pictures with one being like a watermark in the background so your business card could have a design?
Hi great ideas and I am glad you like the training. With the label database sheet you can add any label size or type that you want, to the possibilities are limitless.
Also in part 2 I show you how to add 2 different types of pictures. One is a picture, such as a watermark, that would show up on every label, and the other is a product picture, which would be different for every label, based on a file link to that picture in your database.
For two sided designs you would simply create two different designs, one for the back and one for the front.
Someone suggested to me that a user should be able to save a label design as a template so it can be recalled again, so if there is enough interest I may do this for part 3. Just let me know.
Saving designed cards as templates would be great! Business that use it to make personnel badges could save each employee’s as a template so that badges could be easily replaced when lost or damaged. It might also be useful to incorporate barcodes or QR code’s.
Thanks so much, bar codes, product pictures and misc. pictures are coming next week in Part 2 here: ruclips.net/video/NQ1OY97Ho3c/видео.html
I will try to add the ability to "Save Templates" in week three if the interest holds. Thanks so much for the suggestion.
Would it be possible to extract the label template dimension from mail merge to to populate your template table in excel?
It may be, however I did not find a single source for all of the dimensions, so i just pulled them directly from the Avery site. So any label you want to add, simply add those details to your Label Data table and it will be there forever (as opposed to writing some code to pull the data from word)
Hi Randy, I'm one of your countless fans. Randy can you please make a video on how to make greyed out Text in the TextBox in UserForm in Excel to give the end user a valid information? But as soon soon as End User starts typing something on that TextBox, your greyed out Text will be hidden or deleted. But if he or she deletes the Text he wrote on that TextBox, your Greyed out Text will appear again in that text box. This is similar like we see in the web form. Can it be done in Excel?
Hi the answers are Yes and Yes. It can be done and I have done it. You can find that training here in the Automated Field Names video:
ruclips.net/video/CScEzzEhwVs/видео.html
Also if you combine this with my Automated Tab order videos you have a very powerful and user-friendly form input. I hope this helps and thanks for the great question.
@@ExcelForFreelancers Wow! Randy you're just awesome. I've never seen a person like you. Can you please teach me Python and SQL from basics to Advanced? I'm really interested to learn them from you. Please give me your phone number. My WhatsApp number is 8777425150. I'm from India.
Hi thanks so much. I just stick with Excel, so perhaps you can check on Udemy to find specific courses for what you are looking for. Thanks so much.
I wonder if this will be a great training?
I think you will enjoy it and you can also download the free application. Next week I will show you how to add pictures and bar codes in your labels.
@@ExcelForFreelancers thank you i really enjoy your vids
How to get a workbook from this course, nothing came to my email.
Hi If you have tried to download this workbook using the links but had a problem please email angeli@ExcelForFreelancers.com . Please supply the email you used along with the workbook you are requesting. Thanks for your patience.
Waw.. still waiting..
I hope you enjoyed the training.
do i have to create a new sheet for the Label data file?
Hi Paul, you can use any data file you want. Import your own data to create the labels. The dynamic nature of this application should allow you to import almost any type of Excel data. Thanks so much. (I also got your question on Messenger too)
I have sent for the FREE Workbook you speak of here, I have received my email but there is no link to the worksheet for this lesson . . .
Please, Do you have a link where this Excel worksheet and workbook are . . . Thank You
Hi Mark, please double check the email you got, the title of the email should be "Your Free Excel Label Creator (Part 1) Workbook is Here" and the download link in that email should state the following inside the email:
"As promised, you can download your Workbook from the following link: bit.ly/LabelCreatorPt1_WbDl "
Many people have downloaded this successfully so as long as you received the correct email it should work. If you still have problems please email me here: Randy@ExcelForFreelancers.com
@@ExcelForFreelancers thank you for your response, my email is titled/ (subject line) "Welcome To Excel For Freelancers"
I did just download using your link in this response - Thank you for the link
The Welcome To Excel For freelancers is the Welcome Email you get when you sign up to receive regular emails. If you want any specific workbook, you will have to look in the description of that video. In the description above I have instructions on how to download each workbook. So you will want to go to each video and check the links in the description. Once you click the link, sign up on that individual workbook form, then that email will be delivered, which is different than the one you got.
sir i have to ask one question can i ?
Yes sure and thanks. :)
i have no idea about visual basic and coding n all but i have excel knowledge like all tabs options ,i want to learn this advance level of excel with macro coding. so what do i do first i have to start visual basic?
Hi Kazi, I have a free VBA course taught by MVP Sumit Bansal on my site right here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/