Wednesday, December 9, 2020

Google Sheets - Create a QR Code

Creating a QR (Quick Response) code may sound hard, but it's actually easy to do with Google Sheets. You'd have to use the link from the Google developer site (https://developers.google.com/chart/infographics/docs/qr_codes) and use the required parameters in addition to using the IMAGE function in Sheets. There are two type of QR codes: static & dynamic. The difference is that a static QR code will not change. For example, once the static QR code is created for a the destination link will always be the same. However for a dynamic QR code, the destination link can change. This would be useful if you didn't want to change the QR code, but once scanned it can take you to a different link in the future. The use case would be restaurant menus or some events on the web. You'd want your customers to scan the same QR code now to go to a site, but in the future that same QR code could go to an updated menu or future event on a website. In this video, I'll show you how to create a static and dynamic QR code.

Monday, December 7, 2020

Find the Difference between Two Lists

If you've got two lists or table to compare, most of the time you can use the equal sign to compare the cell values. But sometimes there are complications like having more than one value, values (text or string values) are separated by delimiters (e.g., commas, semicolons, etc.) or the values are not in the "correct" order. Doing the simple cell to cell comparison is not applicable and that's when you can use Power Query to help compare values.

Wednesday, December 2, 2020

Google Sheets - Finding Duplicate Values

When you get a table or list from others or some systems, you might get duplicate records. If you wanted to find those duplicates whether it be in a one column table or a multiple column table, it's fairly easy to do within Google sheets. I'll show a couple of ways this can be done with formulas and with a Pivot Table. Also if you wanted to just delete duplicate records ( and didn't want to bother with the analysis of which records is a duplicate), closer to the end of the video I'll show the command to do this quickly.