Prepare Bank Reconciliation of two Bank: Preparing Bank

reconciliation of two bank & coordinate with the cross functional team to work on the open items.

General Ledger Entries: Passing GL to GL Entry

And (Pivot, V lookup, H lookup, Macros, SUM)

Project Title: Sales Data Analysis for a Retail Company

Tools Used: Microsoft Excel (Pivot Tables, Charts, VLOOKUP, Conditional Formatting)

Description:

Analyzed monthly sales data to identify top-selling products, peak sales periods, Tand underperforming items. Used Excel tools to create dynamic dashboards and visual reports. Recommended strategies to boost sales and reduce inventory waste.

Key Highlights:

Automated data summary using Pivot Tables

Visualized trends using line and bar charts

Improved decision-making with product performance insights