Excel Automation (Macros & VBA)
- Rajwol Khadka
- Mar 5
- 1 min read
Typically when working with data, I enjoy exploring and analyzing it to find trends and actionable insights. Recently, I’ve taken that interest a step further by diving into Excel automation, creating custom macros and refining VBA code to streamline repetitive tasks.
This project showcases how I applied automation techniques to a real-world dataset on vehicle collisions in New York City, enhancing efficiency and usability through macros.
Key Automated Processes
Using a sample of NYC crash data, I automated several high-impact tasks, including:
Monitoring vehicle crashes over a 24-hour period
Automatically filtering and analyzing crash data based on time to identify peak crash windows, visualizing the results in a PivotChart.
Listing unique crash locations
Extracting and displaying all unique addresses where collisions were recorded, useful for hotspot mapping.
Summarizing total fatalities and injuries
Quickly generating a summary of key public safety metrics from the dataset.
The Power of Macros
By embedding macros for these tasks directly into Excel:
Users can track vehicle collision trends dynamically as new data is added.
A significant amount of time spent on ad-hoc analysis, formatting, and reporting is now saved.
Repetitive workflows are reduced to just a few shortcut clicks, improving both speed and accuracy.
See It in Action
Watch as the ad-hoc analysis becomes fully automated in Excel:
Comments