Modern business intelligence demands speed, and utilizing AI tools for Excel is the ultimate way to hyper-charge your data workflows this year.

Previously, I explained how to use a macro to consolidate multiple Excel files received from stores into a single list sheet. This time, I will introduce an Excel macro (VBA) that can instantly ...

As a data analyst, you have a lot of opportunities to process Excel files. At times you need to do the processing using a program. There are several scripting languages to choose. Here we compare them ...

What is this, another json parser? Despite what everybody says, I had a hard time finding a json parser in VBA for Excel that suits my needs. Sure, there is the ...