Category: Uncategorized
-
You don’t need Youtube Premium! Watch videos without Ads and with a locked screen. [IOS]
![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=1024)
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 different app at the same time. In this post, I’ll walk through an easy way to get some of the ‘premium’ features of Youtube Premium…
-
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 not provide a public API, this colleague needed to download the required data files from the source and manually copy the required information onto a…
-
Using VLOOKUP with multiple ranges [Google Sheets]
![Using VLOOKUP with multiple ranges [Google Sheets]](https://aimanfikricom.files.wordpress.com/2022/05/vlookup_multiple_array-2.png?w=770)
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 to reference multiple search ranges. The Formula Example In our ‘Employee ID Timesheet’ below, we have a list of time logs and IDs. Say we…
-
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 metrics. And if you have ever used multiple marketing channels at once, then tracking your digital marketing performance becomes a lot more complicated. This is…
-
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 ensuring that our finance team has all the information needed to print out invoices, sales orders and so on. At first glance, this process seemed…
-
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 leads to upload at once? Well I guess you better start clicking your way through those *aesthetic* buttons and pages. Your sales pipeline changed? Alright,…
Aiman Fikri 