Hi Peeps So glad you could join me. I’ve started a new tutorial series on learning Python through building console based applications. Below is the starter code for the application that we’ll be working with for the duration of this series. This is a series for beginners, by beginners. As we go along and acquire new skills, …
In this tutorial we’ll have a look at the process required for the creation of a scatter plot, in order to visualize employee utilization data. Scatter plots can be daunting at times, but the steps outlined in this tutorial are easy to follow and should have you plotting in no time. For this example. we’ll …
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 …
If you are familiar with Business Dashboards (via Excel or other business tools), I’m pretty sure that you’ve come across at-least one or two infographics whilst googling creative dashboard designs (because let’s face it, if you build dashboards for a living or even as a hobby, you want them to look stunning – googling is inevitable) So, what …
Need to shorten time spent on endless reporting? Using multiple systems to manage discipline within your organization? Stop!! Grab a copy of our free Disciplinary Management Template here: Free_Template and manage all your Disciplinary Matters in one place. ———————————————————————————————————- A few notes on using the Template: Step 1: Ensure that your Employee Data is up to date …