How to Create a QR Code in Excel for Every Need (FREE File)

  Рет қаралды 48,133

MyOnlineTrainingHub

MyOnlineTrainingHub

Күн бұрын

Пікірлер: 91
@MyOnlineTrainingHub
@MyOnlineTrainingHub 10 ай бұрын
❓Which one of these 3 ways do you find the easiest to work with? Simplify your work in Excel with my Advanced Formulas: bit.ly/advformulas0130
@ianwebster2296
@ianwebster2296 10 ай бұрын
Mynda, I just saw a KZbin short on this very subject and it was on my list for today to investigate it. I arrived at work and your email was there waiting for me on the very same subject. As usual, you explained the subject matter much better and in much more depth. You answered FAQ questions and presented options that allow me to not only obtain the functionality of generating QR codes but increase my skillset in Excel at the same time. Thanks for yet another very informative video on a fun subject. --Ian
@MyOnlineTrainingHub
@MyOnlineTrainingHub 10 ай бұрын
That’s awesome to hear, Ian 😊 glad it was helpful 🙏
@ivanbork4175
@ivanbork4175 10 ай бұрын
Dear Mynda It's great that you keep finding new and very useful topics to bring up, thank you so much
@MyOnlineTrainingHub
@MyOnlineTrainingHub 10 ай бұрын
Thank you for your kind words! Do you have any ideas/requests to share for the upcoming videos? 😃
@ivanbork4175
@ivanbork4175 10 ай бұрын
That a bit like asking a Sunday league player to give ideas to a Premier League player 🙂 One thing that I need to get deeper into is Lambda, but Excel can do so many things, and in different ways. personally, I really enjoy when you introduce new functions that can otherwise be easily overlooked, but perhaps to accommodate new users it is a good idea with examples of more basic functions.
@sowjanyas3846
@sowjanyas3846 8 ай бұрын
@MyOnlineTrainingHub is it possible to make tutorial to generate qr code with nice label designer 10 software mam?
@mikrom
@mikrom 10 ай бұрын
Looks so easy in your case, but what if it has to work on the shopfloor machine with Office 2013 and no access to the internet? I've been there. Tried to generate the image via the VBA, but I couldn't make it work. So I found some PHP library and created my own api on the internal server. As it was already XLSM file, I am just downloading the picture and placing it to the range in VBA. 😎
@MyOnlineTrainingHub
@MyOnlineTrainingHub 10 ай бұрын
Yes, not as easy without a connection to the internet. Glad you found a workaround.
@yassirkhalid5376
@yassirkhalid5376 10 ай бұрын
Great Video as usual! I prefer to do it with Lambda, but since the maximum size is 375, is it possible to make the size as an optional parameter with a default size of 150? So in case the user didn't enter any value it will be by default 150 and if entered more than 375, such as 400, the function takes 375.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 10 ай бұрын
Thanks 😊 yes, you could modify the lambda to allow for a default size value if the user omits it.
@yassirkhalid5376
@yassirkhalid5376 10 ай бұрын
@@MyOnlineTrainingHub Glad to hear this, but still looking forward for a video on these tricks!! This will open a wide door for many improvements to my existing lambda functions.
@ServusLibertate
@ServusLibertate 10 ай бұрын
Fantastic, out of the box thinking at its best!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 10 ай бұрын
Thank you 😊
@normundserglis1795
@normundserglis1795 10 ай бұрын
Cool!!! Till that, I have used the third way with different add-on, but now my favorite will be the first way. Thanks!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 10 ай бұрын
Thank you for the comment 😊
@VVeiQuek
@VVeiQuek 10 ай бұрын
You can also generate QR for your home/company wifi, so that you can share wifi with guests without revealing the password each time and only those who drops by can access it.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 10 ай бұрын
Fantastic idea! 😃👏
@andre6543
@andre6543 4 ай бұрын
🤯 Creating QR codes in Excel! Thank you for posting this video.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 4 ай бұрын
Pleasure 😊
@razvanafloarei6256
@razvanafloarei6256 10 ай бұрын
Should I have a specific formatting in the QR code cell?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 10 ай бұрын
No, no formatting required.
@ireyel
@ireyel 10 ай бұрын
Mynda, you've been a great help thank you for doing this. A bit off topic, I was watching your videos yesterday then suddenly it becomes unavailable saying channel is private. When going to your home page I was redirected to Vitalik Buterin's channel. Checking in this morning and now your channel says Ethereum?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 10 ай бұрын
Thanks for your support. Our channel was hacked yesterday, and I've finally restored it, including the channel name.
@jdalco
@jdalco 10 ай бұрын
Do I need to creat the lamda function in every workbook or is there a way to access it across different workbooks?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 10 ай бұрын
You can either save the LAMBDA in your default workbook, or simply copy the formula from the example file into the file you want to use it in.
@CG-em4kg
@CG-em4kg 10 ай бұрын
Hi Mynda, great work! how do I retrieve a qr code from a qrcode string in excel?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 10 ай бұрын
Not sure what you mean by a 'qrcode string in Excel'?
@IamTheReaper911
@IamTheReaper911 10 ай бұрын
Wow! This was just awesome. Thanks for the video 😊
@MyOnlineTrainingHub
@MyOnlineTrainingHub 10 ай бұрын
Thank you for your kind feedback, I really appreciate it 😊
@FEBear1
@FEBear1 10 ай бұрын
great to see you back after the hack
@MyOnlineTrainingHub
@MyOnlineTrainingHub 10 ай бұрын
Thank you for the support! 🙏
@TheUmaiz
@TheUmaiz 10 ай бұрын
Excellent,👍 How we can create the same with shape inside the QR code?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 10 ай бұрын
Not sure what you mean by 'with shape'.
@TheUmaiz
@TheUmaiz 10 ай бұрын
@@MyOnlineTrainingHub Custom design QR code
@rosemarygrundy3539
@rosemarygrundy3539 10 ай бұрын
Hi Mynda I had the same question. I currently use QRCode Generator which requires a hefty annual fee, but it does allow me to put our LOGO in the centre of the QR Codes. I think thats what Umaiz was talking about. Do you think that’s possible?
@chrism9037
@chrism9037 10 ай бұрын
Super awesome, thanks Mynda!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 10 ай бұрын
Thank you for the support! It means a lot!
@Noura.sa19
@Noura.sa19 10 ай бұрын
Could the QR background be transparent in Excel ?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 10 ай бұрын
Do you mean if it is possible to save a QR code as a PNG file with a transparent background?
@Noura.sa19
@Noura.sa19 10 ай бұрын
@@MyOnlineTrainingHub yes
@bassguitarplayer34
@bassguitarplayer34 10 ай бұрын
Amazing! Much thanks 🥳
@MyOnlineTrainingHub
@MyOnlineTrainingHub 10 ай бұрын
Thank you for the comment and for watching!
@sowjanyas3846
@sowjanyas3846 8 ай бұрын
How can i create multiple column data into 1 qr code ? Example i would like to keep colum a and b data together in one qr code? It would be great if u help
@MyOnlineTrainingHub
@MyOnlineTrainingHub 8 ай бұрын
You could concatenate the text first e.g. =A1&B1
@sowjanyas3846
@sowjanyas3846 8 ай бұрын
@MyOnlineTrainingHub thank you for reply. I would like to ask one more question if I combine A&B in one column...if I give code it's creating qr code for each row but I would like only 1 QR code for all row data is there any possibility mam? It could be helpful if I get help
@MyOnlineTrainingHub
@MyOnlineTrainingHub 8 ай бұрын
QR codes are alternate ways to access a URL, so I'm a bit confused about what you're trying to generate a QR code for. Don't reply here as I won't see it. Please post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
@jerrydellasala7643
@jerrydellasala7643 10 ай бұрын
I've found that if I have a LAMBDA function in an open worksheet, copying a cell with that LAMBDA formula in it, and then pasting that CELL/FORMULA in another (new) Workbook will copy the LAMBDA function to the new Workbook. No need to copy the Worksheet.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 10 ай бұрын
Thanks for sharing 👍
@petercrowther5575
@petercrowther5575 6 ай бұрын
Hi there. Can you create a QR code that will open a Document> Pdf, word etc.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 6 ай бұрын
Yes, if that document is stored in a web enabled URL e.g. saved on OneDrive or a web server.
@4braKadabra
@4braKadabra 10 ай бұрын
What about logo inside the QR code? Do you know a way to create QR codes eith logo inside in bulk ?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 10 ай бұрын
Good question, I don't know of any free ways to do this. Bit.ly allow you to with their paid service.
@MelodyCooper-p8n
@MelodyCooper-p8n 10 ай бұрын
Just tried this first method but it says blocked! any advice would be great!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 10 ай бұрын
This bottom of this page explains possible causes of the #BLOCKED! error: support.microsoft.com/en-us/office/image-function-7e112975-5e52-4f2a-b9da-1d913d51f5d5
@MelodyCooper-p8n
@MelodyCooper-p8n 10 ай бұрын
@@MyOnlineTrainingHub Thank you! I managed to sort that message. Sorry another question, is there a way to take the information from more than 1 cell to generate the QR code? Say I wanted the QR code to bring up a name and an email? Sorry I'm not very good with excel.
@vedmuchandikar-xu6jd
@vedmuchandikar-xu6jd 10 ай бұрын
Can I create QR code like this and provide service to clients who want qr code for their website?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 10 ай бұрын
Probably, but I’m not sure if there are licensing restrictions about using these tools and charging for them. You’d have to look at their terms and conditions.
@vedmuchandikar-xu6jd
@vedmuchandikar-xu6jd 10 ай бұрын
@@MyOnlineTrainingHub Thank you so much.
@ahawk850
@ahawk850 7 ай бұрын
Hello, I have been trying the Google URL, but I get the error : #VALUE! Also, there is a message on the Google website that says: "Warning: This API is deprecated. Please use the actively maintained Google Charts API instead." What can help this error? Thanks - AH
@MyOnlineTrainingHub
@MyOnlineTrainingHub 7 ай бұрын
Sounds like you don't have a version of Excel that has the IMAGE function. I address the API deprecation in the video. It has been deprecated for many years, but it still works, so I don't expect it will stop working anytime soon.
@malakamir8491
@malakamir8491 9 ай бұрын
the first method is not working for me. the qr codes generates but when i come to use my camera to scan it, the link is not popping up
@MyOnlineTrainingHub
@MyOnlineTrainingHub 9 ай бұрын
Did you try making the QR code bigger? Have you tested the link you've fed into the formula actually works?
@jimi93080
@jimi93080 11 күн бұрын
I have tried this with a spreadsheet and it works great, but it will only allow me to convert 10 cells to a QR code. Anything after that says the rate limit is reached.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 11 күн бұрын
Unfortunately, I think they changed the API recently.
@DavidVsOficial
@DavidVsOficial 7 ай бұрын
Excelente vídeo, muchas gracias
@MyOnlineTrainingHub
@MyOnlineTrainingHub 7 ай бұрын
Gracias!
@alisami5434
@alisami5434 7 ай бұрын
hi, i'm doing it exactly like you did, but i'm getting the #Name? error please advice, thank you
@MyOnlineTrainingHub
@MyOnlineTrainingHub 7 ай бұрын
I suspect you don't have the IMAGE function in your version of Excel.
@alisami5434
@alisami5434 7 ай бұрын
@@MyOnlineTrainingHub if my version of excel is missing the image function! Is it possible to add it?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 7 ай бұрын
Only by upgrading Excel. You cannot purchase new functions and put them in old versions of Excel.
@dorislo8671
@dorislo8671 9 ай бұрын
can this function on excel 2016?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 9 ай бұрын
The add-in might be able to, but the IMAGE function is only available to Microsoft 365 users.
@walidmaamar
@walidmaamar 8 ай бұрын
The image function don't work for me, any tips ?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 8 ай бұрын
Use the add-in instead.
@esrAsnataS
@esrAsnataS 10 ай бұрын
This is excellent but sadly add-ins are locked at our company.
@MyOnlineTrainingHub
@MyOnlineTrainingHub 10 ай бұрын
You can create a QR code in Excel without add-ins.
@yametekudasai676
@yametekudasai676 8 ай бұрын
can i use this in google sheet?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 8 ай бұрын
I expect so, yes.
@mikes4177
@mikes4177 8 ай бұрын
How do I make a QR code for text
@MyOnlineTrainingHub
@MyOnlineTrainingHub 8 ай бұрын
Use the Add-in and choose 'Custom' from the drop down.
@cjkleynhans
@cjkleynhans 4 ай бұрын
Great!
@MyOnlineTrainingHub
@MyOnlineTrainingHub 4 ай бұрын
Glad it's helpful!
@erdal4687
@erdal4687 10 ай бұрын
Perfect
@MyOnlineTrainingHub
@MyOnlineTrainingHub 10 ай бұрын
Thank you!
@F5Yourself
@F5Yourself 10 ай бұрын
Excel add error failed to load
@MyOnlineTrainingHub
@MyOnlineTrainingHub 10 ай бұрын
Sorry to hear that. Hopefully you can still use the API method.
@Noura.sa19
@Noura.sa19 10 ай бұрын
Also, Is it free?
@MyOnlineTrainingHub
@MyOnlineTrainingHub 10 ай бұрын
100% free
@geisamendes5887
@geisamendes5887 10 ай бұрын
👏👏👏👏
@MyOnlineTrainingHub
@MyOnlineTrainingHub 10 ай бұрын
Glad it was helpful 😁🙏
10 Excel Formulas That Will Set You Apart (+Cheat Sheet)
18:04
MyOnlineTrainingHub
Рет қаралды 351 М.
How to Create Barcode in Excel
9:35
Kevin Stratvert
Рет қаралды 124 М.
VIP ACCESS
00:47
Natan por Aí
Рет қаралды 30 МЛН
REAL or FAKE? #beatbox #tiktok
01:03
BeatboxJCOP
Рет қаралды 18 МЛН
Арыстанның айқасы, Тәуіржанның шайқасы!
25:51
QosLike / ҚосЛайк / Косылайық
Рет қаралды 700 М.
Beat Ronaldo, Win $1,000,000
22:45
MrBeast
Рет қаралды 158 МЛН
Meshless FEA: Simplify, Simulate, Succeed! | Deep Dive
32:35
Jousef Murad | Deep Dive
Рет қаралды 2
Say Goodbye to IF Statements in Excel with SWITCH
7:45
Teacher's Tech
Рет қаралды 594 М.
Excel LAMBDA Function: How & When to Use It (Beginner-Friendly)
14:10
MyOnlineTrainingHub
Рет қаралды 48 М.
QR Codes - How To Make Them And What To Use Them For
4:19
Michelle Schneider
Рет қаралды 247 М.
How to Create SIMPLEST QR Code Attendance System
14:10
Mr. Sovann
Рет қаралды 5 М.
The Excel Tool That Does What PivotTables Can’t (File Included)
13:59
MyOnlineTrainingHub
Рет қаралды 174 М.
Excel Formatting Tricks That Make You Look Like a Pro
12:15
MyOnlineTrainingHub
Рет қаралды 57 М.
How to Create a QR Code | QR Code for Business (Beginners Guide)
9:25
This 1 Excel function can do 90% of your calculations!
5:41
MyOnlineTrainingHub
Рет қаралды 117 М.
Hidden Formatting Tricks for Slicers
5:01
MyOnlineTrainingHub
Рет қаралды 81 М.
VIP ACCESS
00:47
Natan por Aí
Рет қаралды 30 МЛН