Advanced Excel & Tally Help

I need a sharp Excel specialist who can jump straight into my raw data, clean it up, and turn it into useful information. Day-to-day work will begin with straightforward data entry, then move quickly into advanced territory: building pivot tables that slice the figures the way I need, writing or tweaking VBA macros to automate repetitive steps, and crafting complex formulas so the sheets stay dynamic even as the numbers change.

Once the groundwork is solid, I’ll also ask for clear, standard charts that can be dropped into monthly reports without further editing. Nothing flashy—just accurate visual summaries that decision-makers can read at a glance.

A bonus (and the reason “Tally Prime” sits in the title): most of these datasets originate from our Tally Prime accounting package. If you already know your way around exporting, reconciling, or re-importing data there, we’ll save time; if not, you simply need to be comfortable following my export templates and keeping field formats intact so I can pull everything back into Tally later.

Deliverables
• Cleaned and well-structured Excel workbook
• Pivot tables linked to source data
• VBA macros with clear inline comments
• Formulas tested for accuracy across sample scenarios
• A set of standard bar/line charts tied to the pivots

I’ll review each milestone against sample numbers I provide and confirm the outputs match. Clear communication and documented steps are essential so I can maintain the files once the project wraps up.