Rahul Gupta
Microsoft Excel Data Entry, Analysis, Formatting.
New to Contra
Rahul is ready for their next project!
Payment Recovery Analytics Dashboard in Microsoft Excel | Accounts Receivable & Payment Summary Report
Developed a professional Payment Recovery Analytics Dashboard in Microsoft Excel by organizing and analyzing a large payment summary dataset containing 14,000+ records. Created a Recovery Priority List based on overdue days, identified the Top 5 States with the highest pending amounts, and designed pivot tables, KPI summaries, and interactive charts. Leveraged Excel formulas, Pivot Tables, conditional formatting, and data visualization techniques to deliver actionable financial insights for efficient payment tracking and recovery management.
0
17
Converted a raw Amazon sales report from MHT to a structured Microsoft Excel workbook and transformed unorganized data into a clean, analysis-ready dataset. Identified misplaced values, organized them into their respective columns, removed inconsistencies, standardized formatting, and created professional Excel tables. Applied data cleaning techniques to improve accuracy, readability, and reporting efficiency, delivering a business-ready dataset for analysis, dashboards, and decision-making.
0
17
Interactive Sales Analytics Dashboard in Microsoft Excel | Pivot Tables, Charts & Business Insights
0
34
Salon Appointment Analytics Dashboard | Microsoft Excel
0
36