Excel invoice generator (Excel)

-
Excel Invoice Generator for Kalyan Jewellers

Excel Invoice Generator for Kalyan Jewellers

I developed an Excel-based invoice generator for Kalyan Jewellers using advanced Excel formulas and automation techniques. This project allows users to input customer details, product weight, and current gold prices in the "Input" sheet, and it automatically generates a detailed and professional tax invoice in the "Invoice" sheet.

Key Features:

  • Automated Invoice Generation: User inputs are processed dynamically to generate accurate invoices.
  • Formula-Based Calculations: Includes gold price calculations, discounts, making charges, and GST.
  • User-Friendly Interface: Easy-to-use structured input sheet for seamless data entry.
  • Dynamic Pricing Update: Adjusts the final invoice based on the latest gold rates and applicable taxes.

This project showcases my expertise in Excel formulas, data automation, and financial calculations, making it a valuable tool for businesses handling product-based invoicing.

👉 GitHub Link:invoice generator

Comments

Post a Comment

Popular posts from this blog

Employee Management System - SQL Database with Triggers & Stored Procedures

-
Image
SQL-Based Employee Management System SQL-Based Employee Management System I designed and implemented an SQL-based Employee Management System that automates employee record handling using triggers and stored procedures . This project ensures that every new employee entry is logged in an audit table, maintaining data integrity and historical tracking. Key Features: ✅ Employee Table – Stores essential details like name, position, salary, and hire date. ✅ Audit Table – Automatically records employee changes with timestamps for tracking modifications. ✅ Trigger for Data Auditing – A SQL trigger (AFTER INSERT) ensures that all new employee records are mirrored in the audit table. ✅ Stored Procedure for Employee Addition – Simplifies employee insertion while enforcing consistency. Technologies Used: SQL (MySQL / PostgreSQL) Triggers & ...
Read more

Super market analysis (Excel)

-
Image
Supermarket Sales Dashboard – Excel Interactive Visualization Supermarket Sales Dashboard – Excel Interactive Visualization I developed an interactive Supermarket Sales Dashboard using Microsoft Excel , incorporating key business metrics and visual analytics to provide actionable insights. Key Features: 📊 Total Revenue & Sales Overview: Displays key performance indicators (KPIs) such as total revenue, total quantity sold, gross income, and average rating. 📦 Product & Category Insights: Showcases revenue distribution across different product lines and branches. 👥 Customer Segmentation: Includes slicers for filtering data by branch, product category, customer type, city, and payment method for in-depth analysis. 📈 Trend Analysis: A dynamic line chart visualizing sales performance over time. 💳 Payment Method Analysis: A pie chart illustrating the distributi...
Read more

Excel: Mother of Business Intelligence - Certified by Codebasics

-
Image
Excel: Mother of Business Intelligence Certification Excel: Mother of Business Intelligence Certification I have successfully completed the Excel: Mother of Business Intelligence course from Codebasics , gaining expertise from beginner to advanced levels. This course focused on real-world business applications , working with datasets exceeding 1 million records , and mastering essential Excel functionalities for data analysis and business intelligence . Key Skills Acquired: Data Cleaning and Transformation Advanced Excel Formulas & Functions Pivot Tables & Data Visualization Business Case Studies & Real-World Applications Handling Large Datasets Efficiently Successfully passed the final exam with 70%+ marks , demonstrating proficiency in Excel for data-driven decision-making. Certificate: ...
Read more