Blog posts on coding, work, education and more.
![You don’t need Youtube Premium! Watch videos without Ads and with a locked screen. [IOS]](https://aimanfikricom.files.wordpress.com/2023/02/img_4641-1-1.png?w=1125)
You don’t need Youtube Premium! Watch videos without Ads and with a locked screen. [IOS]
Sometimes it’s a long video that you want to listen to during your drives. Or maybe there’s a video you want to listen to but you want to use a…
Automatically import data from Excel files to Google Sheets
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…
![“This app is blocked” error on Google Apps Script [solution]](https://aimanfikricom.files.wordpress.com/2022/05/image001-2.png?w=635)
“This app is blocked” error on Google Apps Script [solution]
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…
![Using VLOOKUP with multiple ranges [Google Sheets]](https://aimanfikricom.files.wordpress.com/2022/05/vlookup_multiple_array-2.png?w=770)
Using VLOOKUP with multiple ranges [Google Sheets]
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…
Use Supermetrics to Track Your Digital Marketing Performance
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…
Mass Upload Records to Salesforce
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…
Build your own Mini CRM system on Google Sheets!
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…
Build a Chinese Character Separator tool using Google Sheets!
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…
Aiman Fikri 