If you find yourself repeating the same steps in Microsoft Excel, Power Query can give you back a substantial amount of time

When you think of automating tasks, generating reports as well as performing several other functions beyond creating and organising spreadsheets, you may well realize that the supreme, mighty Visual Basic for Applications (VBA) has been around for almost 13 years and undoubtly, it has provided excellent business solutions. It has got innumerable advantages especially considering Excel is embraced by the vast majority of the users in business world. I even published a post about how to use VBA…

“Sometimes a cigar is just a cigar.” Is this famous quote geniunely uttered by Sigmund Freud? We don’t know really. But what we know is that a cup of coffee is never only a cup of coffee. A cup of coffee is a brilliant example of sociological imagination, that is, “the awareness of the relationship between personal experience and the wider society”. We don’t consume coffee just for the sake of consuming it. It has symbolic values in our lives. For most of us, it is the indispensable part of our morning routines. We usually have an idle chit-chat along…

I don’t know if someone loves “the smell of napalm” in the morning as one lunatic character in the movie “Apocalypse Now” calmly says, most of us certainly loves the smell of coffee. This referred and perhaps somewhat garish introduction has actually one purpose: To share my experimenting on Vietnamese Iced Coffee, a.k.a. Ca Phe Sua Da.

Here is our list:

Let’s start with the sweetened condensed milk (SCM), the sine qua non ingredient of our “liquified dessert”. Although dairy products such as cheese and cream are not common in Vietnamese market, SCM, milk powder are used in daily lives…

Inserting multiple sheets or copying values to make mass changes? Let’s automate them with Visual Basic for Applications (VBA).

Photo by Christian Fregnan on Unsplash

Admit it or not, we all happen to do boring tasks manually in our daily routines. Most of the time, they are repetitive and should be done in a certain pattern. There is an ocean of tools and programming languages such as Python, Alteryx, R, etc., to automate such tasks, but it is always better to carry on with the one on hand.

Yes, you guessed it right. I am talking about Visual Basic for Application (VBA) for any Microsoft Office…

Burak Piskin

internal auditor/data analyst, coffee enthusiast, passionate about groove, snooker and words

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store