In this tutorial we’ll have a look at one of the fastest ways to display Google Sheet tables inside a Web App. The method explained in this tutorial is quite literally “quick, simple and dirty”. It’s far from best practice, but it surely gets the job done 🙂 One of the awesome functions of Google …
After almost melting my brain I finally got this working 🙂 In this tutorial we’ll have a look at the process to follow when creating a multi-workbook vlookup formula in Google Sheets (and hopefully keeping ourselves “woooosssaaahh” in the process). Multi-workbook vlookup’s in Excel are fairly simple because Excel does all the heavy lifting in connecting …
One of the more advanced features available to Google users, is the user’s ability to scrape data – from the web – directly into a Google spreadsheet through utilizing the ‘=IMPORTXML‘ function, combined with XPath. The script to follow outlines this functionality by scraping a simple data table from a public website and loading the results into a spreadsheet . In practice, …
This is a 4 part video series on how to create a 9 Box (Employee Performance) Matrix, using Google’s ‘=query’ function in Google Sheets. For an introduction to Google’s Query function, you can jump directly to Video 3 Apologies upfront for the low volume and my weird accent. Still getting used to the new recording equipment. This is a first attempt, …
In early 2017 I posted a tutorial on the creation of randomized HR “data-sets” for use in statistical models, or simply to test your skills at analyzing HR related data in Excel. “If you want to learn how to generate your own randomized HR data in Excel, in order to test statistical models or theories or just …
After much (and by much, I mean muuuuuuuuuuch) Googling and YouTube-ing my little monster is finally alive!!!! This (unpublished) little add-on creates a custom menu item in the Google Sheets ribbon and has two custom items. One launches a custom html side-bar (with quick-launch buttons) and the other runs a custom Apps-Script function. Have fun …