Integrated Microsoft Excel System for Sales, Employee Data, and Financial Analysis

I created a complete Microsoft Excel project that combines sales management, employee data management, and financial calculations in one workbook.

The project includes an automated sales invoice with customer information, products, quantities, prices, VAT, and final totals. I used SUM and arithmetic formulas to calculate values automatically and reduce manual work.

I also created an employee database containing employee ID, name, address, and basic salary. Using VLOOKUP, employee information can be retrieved automatically by entering the employee number.

In addition, I created financial calculation models using PV and FV functions to calculate present value and future value based on investment amount, interest rate, payment periods, and payment type.

This project demonstrates my skills in Microsoft Excel, data organization, automation (الأتمتة), financial analysis, employee data management, and professional business calculations.

Work files