Create multiple QR Codes from URLs in Excel using Python - no API - free download

Based upon the recently released Microsoft QR code template, we can now provide a list of links and get instant QR codes in Excel.
#excel #python #qrcode

You need Office 365 version of Excel on Windows Desktop.
Download sample file
https://efficiency365.com/wp-content/...

Contents 📚
00:00 - The need
01:18 - Use QR template
02:48 - How is QR created
04:10 - Python editor pane
05:11 - Show Excel value
05:39 - Positioning the image
06:51 - Understand the code
07:55 - generate_qr function
10:50 - Create multiple QR codes
11:07 - Define Named Ranges
11:50 - Modify formula
13:25 - Add more URLs
14:06 - Summary

Related videos 📺
Microsoft Forms to Excel - live update -    • Microsoft Forms to Excel - live updat...  
Scanned PDF or picture to Excel data -    • Scanned PDF or picture to Excel data ...  
Instant 3D map from Excel data - no lat long required -    • Instant 3D map from Excel data - no l...  
Everything About Conditional formatting in MS Excel -    • Everything About Conditional formatti...  
Excel PivotBy function - use multiple fields in rows and columns -    • Excel PivotBy function - use multiple...  


Buy Dr Nitin's latest book
-----------------------------------------
Efficiency Best Practices for Microsoft 365
130 best practices everyone must know
Work Smarter, Grow Faster

https://s.efficiency365.com/bk

Dr Nitin Paranjape is the pioneer in maximizing work efficiency in a modern work scenario.
Dr Nitin's Office Masterclass
----------------------------------------------
https://hi.switchy.io/mms

Online Courses by Dr Nitin Paranjape
--------------------------------------------------------------
Pivot Table Advanced - https://s.efficiency365.com/ptyt
Excel to Power BI - https://swiy.io/uxlpbi

Learn more from 1000+ blog articles by Dr Nitin Paranjape
Efficiency 365 blog: https://efficiency365.com/blog

LinkedIn :   / nitinparanjape  
Twitter :   / drnitinp  

Production
--------------------
Music and Effects: https://elements.envato.com/
Created using Adobe Premiere: https://www.adobe.com/in/creativeclou...
AI based captions: https://videoindexer.ai (Microsoft service)