Projects using Microsoft Excel in Uttar PradeshProjects using Microsoft Excel in Uttar PradeshGST Sales Register & Invoice Management in Microsoft Excel | GST Reconciliation
I prepared a structured GST Sales Register in Microsoft Excel to maintain and organize sales invoice details for the financial year 2026–27.
Key tasks completed:
Recorded invoice numbers, invoice dates, and customer/party details.
Organized GSTIN, HSN codes, quantities, taxable values, and freight charges.
Maintained GST rate and IGST details for sales transactions.
Calculated invoice amounts and organized invoice-wise tax information.
Prepared a consolidated sales register with grand totals.
Identified missing invoice information and potential discrepancies for verification.
Skills demonstrated: Microsoft Excel, GST Accounting, Sales Register Preparation, Invoice Management, Data Entry, Bookkeeping, and Financial Reporting.
This project demonstrates my ability to maintain organized sales records, manage invoice data, and support accurate accounting and GST reporting for businesses. E-Commerce Sales Performance Dashboard 🛒📊
Designed and built an advanced, interactive E-Commerce analytics dashboard to track key online retail metrics, revenue growth, and regional sales distribution.
Key Highlights:
Financial Overview: Monitored Total Sales ($114K), Total Profit ($22.8K), and maintained a strong Profit Margin (20%).
Regional & Category Filters: Integrated dynamic slicers for Categories and Regions (East, North, South, West) to drill down into specific market performance.
Visual Trends: Visualized monthly profit distribution, yearly sales projections, and order quantities through clean pie charts, bar charts, and area graphs.
Built to help e-commerce store owners uncover hidden trends, optimize inventory, and scale their online revenue effectively. 
