quirky functions Archives - Desktop Liberation

Search

July 13, 2019 Comments Off

Search() and Find() are pretty much the same. The only difference is that Find worries about matching case (upper/lower) and search doesn’t. That means that Brass is the same as brass as far as Search is concerned, but find thinks they are different. So you can […]

Quirky Functions

March 30, 2019 Comments Off

Equation plots in Excel Execute SQL from Excel Respect a Filter with Sumproduct Search SumProduct SumProduct – prioritizing lookups Sumproduct Strangeness-2 Using match to categorize

create, implement and test a Workspace Add-on
add functionality from a collection of Google Cloud APIs such as Cloud Storage, CardService, Drive and others
organize extracted data from a variety of documents using the Google AI Platform

Manning LiveProject

All formats are available from O'Reilly, Amazon and all good bookshops. You can also read a preview on O'Reilly

A video course over about 8 hours and 70 lessons taking you through the basics of Apps Script and JavaScript. Available at O'Reilly, Amazon, Infinite Skills & all good media outlets

Google Apps Script for Beginners: A video course over about 8 hours and 70 lessons taking you through the basics of Apps Script and JavaScript. Available from O'Reilly, Infinite Skills and all good media outlets

bruce mcpherson is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License. Based on a work at http://www.mcpher.com. Permissions beyond the scope of this license may be available at code use guidelines