Blog posts on coding, work, education and more.
Recently, I helped a colleague set up an automated script for importing data from Excel files so that they can be formatted on Google Sheets. As the data source did […]
If you found this post, you have most likely gone through the ‘normal’ authentication process before. Otherwise, check out this great post on how to authorise Google Apps Scripts by […]
VLOOKUP is an incredibly simple but powerful function, allowing you to quickly index ‘search keys’ in your spreadsheet. This short post will walk through using VLOOKUP in combination with arrays […]
If you work with a lot of digital marketing channels like Facebook and Google Ads, you might find yourself having to copy & paste a lot of your campaign performance […]
In my most recent project, I worked with a lot of ‘Client Servicing’ staff – a job role which involves engaging with clients, creating the relevant records on Salesforce and […]
If you have ever worked in sales, you might come to realise that we have become all too accustomed with laggy CRMs and clunky user interfaces. Got a lot of […]
When I was working as a salesperson, my company received a lot of prospective leads through Google Forms. When we wanted to reach out to these leads, we found that […]