This repository contains all projects, coding standards, boilerplate, and best practices. This is intended to share my experience and expertise so everyone can fork or download everything from this repository even without permission. Happy Coding!

Visual Basic, VB, Access, Dashboard, BI, Business Intelligence, vba

download attachments from an email message automatically

Excel VBA macro automation

Stock yearly Calculations using VBAScript

End-to-end HR MIS reporting project using PostgreSQL and Excel. Covers dimensional modeling, SQL-based KPI validation, Excel Power Query & Power Pivot modeling, KPI reconciliation, and automated A4 MIS report generation with validation controls, closely reflecting real-world HR MIS workflows.

Hands-on Advanced Excel projects covering data analysis, cleaning, and visualization — using Pivot Tables, Power Query, VBA automation, VLOOKUP/INDEX-MATCH, and interactive dashboards for sales, HR, and financial data.

This project demonstrates an end-to-end data workflow using Excel and VBA, starting from raw CSV ingestion, automated data cleaning, and transformation, to an interactive dashboard for sales analysis. The dashboard provides insights into revenue trends, product performance, sales channels, and operational metrics.