Himanshu Bhandari
Data entry & cleaning, formula automation & Excel dashboards
- 1
- Followers
An automated, print-ready Employee Pay Slip Generator built in Excel using dynamic lookup formulas (VLOOKUP + MATCH). It seamlessly pulls live attendance and salary data to auto-populate detailed employee pay stubs—complete with earnings breakdown, statutory deductions (PF & ESI), overtime pay, and net salary summary.
Key Skills: Excel Automation, Dynamic Pay Slip Templates, Payroll Processing, Data Lookup & Linking, Print-Ready Financial Reporting.
3
80
An automated Excel Payroll & Salary Calculation Sheet designed for error-free compensation processing. It features dynamic formulas (IF, VLOOKUP, etc.) for automated HRA calculation based on city tiers, overtime pay, statutory deductions (PF & ESI), and attendance-linked salary proration—generating instant Net Payable Salary per employee.
Key Skills: Payroll Management, Excel Automation, Statutory Calculations (PF/ESI), Data Entry & Accuracy, Financial Compensation Sheets.
0
22
An automated Employee Attendance & Payroll Management System built in Excel using dynamic formulas (VLOOKUP, MATCH, etc.) and conditional formatting. It streamlines monthly attendance tracking, automatically calculates present/absent/leave counts, and instantly generates summary metrics for error-free salary processing.
Key Skills: Excel Automation, Dynamic Formulas, conditional formatting, Data Entry, Attendance & Payroll Management, Visual Formatting.
0
41
An interactive e-commerce sales dashboard built in Excel using Pivot Tables, Charts, and Slicers. It transforms raw order data into actionable business insights—tracking $20M+ sales trends, order fulfillment rates, top-performing states, and customer demographics across channels like Amazon, Flipkart, and Myntra.
Key Skills: Data Cleaning, Pivot Dashboards, Financial/Sales Analytics, KPI Visualization.
0
59