Automation with VBA
Hello everyone,
I would like to know how analysts are using VBA in Excel in their daily work.
I currently work as a data analyst, and part of my role is to create different types of analysis reports. For example, I analyze sales evolution in Grand Surfaces and other local sales by article and by category and other kpis etc.. to identify which products perform well and which do not.
Most of the time, I use tools like Claude AI and Google Gemini to help structure my analysis by explaining my data and the expected output by one simple click and loge generate well performed analysis and reports (even if it's huge page) in one simple click
For data preparation, I usually:
Clean product names
Standardize category names
Use functions like VLOOKUP, SUMIF DATEEVAL for fixing date NB.SI.ENS, etc. to calculate totals and revenue
However, I am looking for innovative ways to use VBA to automate data cleaning. Any ideas?
My goal is to create simple macros so that even a beginner could run them and clean the dataset automatically.
Unfortunately, I cannot use Microsoft Power BI in my environment, but I can use Microsoft Power Query
I will also begin developing a more interactive dashboard using VBA. This dashboard will explain all (KPIs) and provide guidance on the appropriate placement for pie charts, histograms, and line charts.