Sanjeet Kumar Yadav

EXCEL EXPERTISE
 Excel VBA (Visual Basic for Applications):
o Automated repetitive tasks and reporting processes, saving significant time and reducing human
error.
o Created custom macros and functions tailored to business needs, including tax calculations, financial
reporting, and data extraction.
o Developed complex Excel-based applicaƟons for automated GST and sales tax filings & more.
 Advanced Excel Functions:
o Mastered complex formulas like VLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, IFERROR, and nested
funcƟons for data analysis and reporting.
o Used Pivot Tables and Pivot Charts to summarize and analyse large data sets, providing actionable
insights and efficient reporting.
o Extensive experience in conditional formatting to highlight critical trends and discrepancies in
financial data.
 Data Analysis & Reporting:
o Performed comprehensive data analysis using advanced filtering, sorting, and data validation
techniques to ensure accurate tax filing and business decisions.
o Built interactive dashboards and reports, integrating charts, graphs, and visual data insights to
present findings to senior management and stakeholders.
o UƟlized Power Query for advanced data transformation and cleansing, ensuring that data is in
optimal format for analysis.
 Excel Data Modelling & Visualization:
o Designed and implemented complex financial models, forecasts, and projections to support decision-
making and strategic planning.
o Created and optimized Excel workbooks for efficient data management, with user-friendly interfaces and automated processes.